{"schemaVersion":"jobsearcher.job.v1","id":"427d9962dd4bfb2a513b9338","url":"https://jobsearcher.com/jobs/427d9962dd4bfb2a513b9338","canonicalUrl":"https://jobsearcher.com/jobs/427d9962dd4bfb2a513b9338","title":"PostgreSQL Database Administrator","description":"We are seeking an experienced PostgreSQL Database Administrator with deep expertise in database performance tuning, backup and recovery, high availability, replication, and troubleshooting. The ideal candidate should have hands-on experience with Postgres (EDB, Open Source, or AWS Aurora Postgres) in enterprise-scale environments, with the ability to diagnose and resolve complex database issues. Responsibilities Database Administration & Performance Monitor and troubleshoot high CPU usage, memory bottlenecks, and long-running queries. Analyze query execution plans, detect sequential scans, and optimize query/index usage. Rebuild and manage indexes; investigate cases where indexes are not being used. Perform database tuning, parameter optimization, and query performance improvements. Configure, monitor, and tune auto-vacuum parameters (thresholds, scale factor, max workers, etc.). Understand and manage vacuum, vacuum full, and analyze operations. Handle table/index bloat issues and minimize vacuum impact on running queries. Validate and fix query execution plan changes post-upgrade. Run vacuum full/analyze after migrations to ensure optimal performance. High Availability & Failover Configure and manage PostgreSQL failover/recovery mechanisms with tools like EDB Failover Manager (EFM) . Investigate failover delays and optimize failover times. Configure and manage replication (physical, logical, streaming, BDR, Aurora, etc.). Ensure seamless synchronization between primary and standby clusters. Backup & Recovery Implement backup strategies including physical (pg_basebackup), logical (pg_dump/pg_restore), and point-in-time recovery (PITR). Schedule and automate backups. Configure BSR (Block Streaming Replication) and ensure backup integrity. Restore corrupted WAL files and manage recovery.conf settings. Security & Encryption Implement encryption methods at rest and in transit for PostgreSQL databases. Ensure compliance with organizational and industry security standards. Cluster & Instance Management Install, configure, and manage multiple PostgreSQL instances on a single server. Troubleshoot cluster installation issues and handle cases of shared data directories. Manage pg_resetwal operations and database restart issues. Work with AWS Aurora PostgreSQL , understanding its replication model and optimizations. Compare and leverage Aurora's replication vs. traditional BDR methods. Required Skills & Experience 5+ years of hands-on experience as a PostgreSQL DBA/Engineer . Strong expertise in performance tuning, query optimization, and execution plans . Deep understanding of vacuum processes, auto vacuum tuning, and index management . Experience with backup & recovery strategies including PITR, pg_basebackup, WAL management. Proficiency in replication, failover, and high availability configurations . Hands-on experience with PostgreSQL upgrades and migrations . Strong knowledge of B-tree, BRIN, and other indexing methods . Familiarity with AWS RDS/Aurora PostgreSQL and replication differences. Good troubleshooting skills with ability to handle production incidents. Preferred Qualifications Experience with EDB Postgres Advanced Server . Knowledge of Linux system administration for database environments. Experience in automation (Shell, Python, Ansible, Terraform) for DBA tasks. Prior exposure to large-scale, mission-critical production environments . Strong problem-solving skills, ability to identify and prevent production risks. Seniority level Associate Employment type Contract Job function Information Technology Industries Banking #J-18808-Ljbffr","company":"Drilloai","rawCompany":"drilloai","city":"St Louis","state":"MO","isRemote":false,"isActive":false,"createdAt":"2026-06-29T03:54:57.527Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1244.00","title":"Network and Computer Systems Administrators","slug":"network-and-computer-systems-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"PostgreSQL Database Administrator","description":"We are seeking an experienced PostgreSQL Database Administrator with deep expertise in database performance tuning, backup and recovery, high availability, replication, and troubleshooting. The ideal candidate should have hands-on experience with Postgres (EDB, Open Source, or AWS Aurora Postgres) in enterprise-scale environments, with the ability to diagnose and resolve complex database issues. Responsibilities Database Administration & Performance Monitor and troubleshoot high CPU usage, memory bottlenecks, and long-running queries. Analyze query execution plans, detect sequential scans, and optimize query/index usage. Rebuild and manage indexes; investigate cases where indexes are not being used. Perform database tuning, parameter optimization, and query performance improvements. Configure, monitor, and tune auto-vacuum parameters (thresholds, scale factor, max workers, etc.). Understand and manage vacuum, vacuum full, and analyze operations. Handle table/index bloat issues and minimize vacuum impact on running queries. Validate and fix query execution plan changes post-upgrade. Run vacuum full/analyze after migrations to ensure optimal performance. High Availability & Failover Configure and manage PostgreSQL failover/recovery mechanisms with tools like EDB Failover Manager (EFM) . Investigate failover delays and optimize failover times. Configure and manage replication (physical, logical, streaming, BDR, Aurora, etc.). Ensure seamless synchronization between primary and standby clusters. Backup & Recovery Implement backup strategies including physical (pg_basebackup), logical (pg_dump/pg_restore), and point-in-time recovery (PITR). Schedule and automate backups. Configure BSR (Block Streaming Replication) and ensure backup integrity. Restore corrupted WAL files and manage recovery.conf settings. Security & Encryption Implement encryption methods at rest and in transit for PostgreSQL databases. Ensure compliance with organizational and industry security standards. Cluster & Instance Management Install, configure, and manage multiple PostgreSQL instances on a single server. Troubleshoot cluster installation issues and handle cases of shared data directories. Manage pg_resetwal operations and database restart issues. Work with AWS Aurora PostgreSQL , understanding its replication model and optimizations. Compare and leverage Aurora's replication vs. traditional BDR methods. Required Skills & Experience 5+ years of hands-on experience as a PostgreSQL DBA/Engineer . Strong expertise in performance tuning, query optimization, and execution plans . Deep understanding of vacuum processes, auto vacuum tuning, and index management . Experience with backup & recovery strategies including PITR, pg_basebackup, WAL management. Proficiency in replication, failover, and high availability configurations . Hands-on experience with PostgreSQL upgrades and migrations . Strong knowledge of B-tree, BRIN, and other indexing methods . Familiarity with AWS RDS/Aurora PostgreSQL and replication differences. Good troubleshooting skills with ability to handle production incidents. Preferred Qualifications Experience with EDB Postgres Advanced Server . Knowledge of Linux system administration for database environments. Experience in automation (Shell, Python, Ansible, Terraform) for DBA tasks. Prior exposure to large-scale, mission-critical production environments . Strong problem-solving skills, ability to identify and prevent production risks. Seniority level Associate Employment type Contract Job function Information Technology Industries Banking #J-18808-Ljbffr","datePosted":"2026-06-29T03:54:57.527Z","dateModified":"2026-06-29T03:54:57.527Z","hiringOrganization":{"@type":"Organization","name":"Drilloai","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"St Louis","addressRegion":"MO","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"427d9962dd4bfb2a513b9338"},"url":"https://jobsearcher.com/jobs/427d9962dd4bfb2a513b9338"}}