Postgresql Database Administrato

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, autovacuum 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.