What are the responsibilities and job description for the Senior PostgreSQL Database Administrator :: Minneapolis, MN or Hartford, CT (Onsite Position) position at TekLeaders, Inc?
Need locals to Minneapolis, MN or Hartford, CT Only.....
Role: Senior PostgreSQL Database Administrator
Location: Minneapolis, MN or Hartford, CT (Onsite Position)
Job Description:
We are seeking an experienced PostgreSQL Database Administrator to serve as a subject matter expert for our database ecosystems. You will be responsible for the health, performance, and security of our PostgreSQL instances across both on-premises data centers and cloud environments (Google Cloud Platform/Azure). The ideal candidate is a proactive problem-solver who excels at performance tuning, high-availability architecture, and seamless cloud migrations.
Key Responsibilities
- Core Administration: Lead the installation, configuration, and lifecycle management of PostgreSQL. Manage database refreshes, security patching, and version upgrades to ensure 99.9% uptime.
- Performance Engineering: Actively monitor and optimize database performance. You will analyze execution plans, tune
postgresql.confparameters, and manage indexing strategies to resolve bottlenecks. - High Availability: Design and maintain robust HA clusters using repmgr. Take ownership of failover testing, node recovery, and split-brain prevention.
- Cloud & Migration: Design and execute low-downtime migration strategies from legacy on-premises hardware to Cloud SQL or Azure Database for PostgreSQL.
- Data Protection: Oversee comprehensive Backup & Recovery (PITR) and Disaster Recovery (DR) strategies using both native tools and enterprise solutions.
- Replication Management: Configure and troubleshoot streaming and logical replication to support data synchronization and reporting offloads.
Technical Qualifications
- Postgres Internals: Deep understanding of WAL (Write-Ahead Logging), MVCC, Autovacuum tuning, and memory architecture ($shared\_buffers$, $work\_mem$).
- Clustering: Proven hands-on experience with repmgr for automated failover and cluster management.
- Tooling: Proficiency with standard tools like
pg_dump,pg_restore,pg_basebackup, andpg_upgrade. - Cloud Platforms: Working knowledge of Google Cloud Platform (Google Cloud Platform) or Microsoft Azure database services.
- Infrastructure as Code: (Preferred) Experience automating deployments with Ansible or Terraform.
- Observability: Familiarity with monitoring stacks such as Prometheus, Grafana, or pgAdmin.
Kumar K
Sr. US IT Recruiter
Email:
LinkedIn: