Job ID: JOB_ID_5917
Job Title: Senior PostgreSQL Database Administrator (DBA)
Location: Minneapolis, MN or Hartford, CT (4 days onsite)
Employment Type: Contract
Role Overview:
We are seeking an experienced and highly skilled Senior PostgreSQL Database Administrator (DBA) to join our team. As a subject matter expert, you will be responsible for the overall health, performance, security, and availability of our diverse database ecosystems, spanning both on-premises data centers and cloud environments (GCP/Azure). The ideal candidate is a proactive problem-solver with a proven track record in performance tuning, designing and implementing high-availability architectures, and executing seamless cloud migrations. This role requires a deep understanding of PostgreSQL internals and best practices.
Key Responsibilities:
- Core Administration: Lead the end-to-end lifecycle management of PostgreSQL instances, including installation, configuration, patching, and version upgrades. Ensure optimal database performance and maintain 99.9% uptime through diligent management and proactive maintenance.
- Performance Engineering: Continuously monitor and optimize database performance. Analyze complex execution plans, tune critical
postgresql.confparameters, and implement effective indexing strategies to identify and resolve performance bottlenecks. - High Availability (HA): Design, implement, and maintain robust HA clusters utilizing tools like repmgr. Take full ownership of failover testing, node recovery procedures, and strategies to prevent split-brain scenarios, ensuring business continuity.
- Cloud & Migration Expertise: Design and execute low-downtime migration strategies for moving databases from legacy on-premises hardware to cloud-based solutions such as Cloud SQL (GCP) or Azure Database for PostgreSQL.
- Data Protection & Disaster Recovery: Oversee and manage comprehensive Backup & Recovery (PITR) and Disaster Recovery (DR) strategies, leveraging both native PostgreSQL tools and enterprise-grade solutions to safeguard critical data.
- Replication Management: Configure, manage, and troubleshoot various replication methods, including streaming and logical replication, to support data synchronization needs and reporting offloads.
Technical Qualifications:
- PostgreSQL Internals: Deep and practical understanding of core PostgreSQL concepts such as WAL (Write-Ahead Logging), MVCC, Autovacuum tuning, and memory architecture (e.g.,
$shared_buffers$,$work_mem$). - Clustering & HA: Proven hands-on experience with repmgr for automated failover and cluster management is essential.
- Tooling Proficiency: Expertise with standard PostgreSQL administration tools including
pg_dump,pg_restore,pg_basebackup, andpg_upgrade. - Cloud Platforms: Working knowledge and practical experience with cloud database services on GCP (Google Cloud Platform) or Microsoft Azure.
- Infrastructure as Code (Preferred): Experience automating database deployments and management using tools like Ansible or Terraform is a plus.
- Observability: Familiarity with monitoring stacks such as Prometheus, Grafana, or pgAdmin for performance tracking and alerting.
Additional Requirements:
- Candidates must be local to Minneapolis, MN or Hartford, CT.
- This is a contract position requiring 4 days onsite per week.
Special Requirements
Need only local candidates. 4 days onsite.
Compensation & Location
Salary: $70 – $95 per year (Estimated)
Location: Minneapolis, MN
Recruiter / Company – Contact Information
Recruiter / Employer: Ampstek
Email: esh.pathak@ampstek.com
Recruiter Notice:
To remove this job posting, please send an email from
esh.pathak@ampstek.com with the subject:
DELETE_JOB_ID_5917