Drillo.AI
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 Auroras 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
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 Auroras 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