Sr PostgreSQL DBA (Local to Harrtford, CT or Minneapolis, MN)

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