What are the responsibilities and job description for the Senior PostgreSQL Database Administrator (DBA) position at TekShapers?
Senior PostgreSQL Database Administrator (DBA)
Location: Miniiapolis, MN or Hartford, CT
Duration: Long Term
Job Details:
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.conf parameters, 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, and pg_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.
• 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.conf parameters, 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, and pg_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.
Tekshapers is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information, or any characteristic protected by law.