Job Description

Job Summary

We are looking for an experienced PostgreSQL Database Administrator to join our infrastructure team. In this role, you will be responsible for the full lifecycle management of our PostgreSQL environments — from installation and performance tuning to high availability, disaster recovery, and cloud migration. You will work closely with application teams and contribute to building a scalable, reliable, and secure data platform.

Key Responsibilities

Installation, Configuration & Maintenancern▸ Install, configure, and maintain PostgreSQL databases, including patching, version upgrades, and environment optimization.rn▸ Configure and administer PostgreSQL for high performance, availability, and security.rn▸ Monitor database health, capacity, and growth trends while proactively troubleshooting and resolving incidents.rnHigh Availability & Disaster Recoveryrn▸ Implement and manage HA/DR solutions using tools such as Patroni, etcd, and PgBouncer, ensuring robust replication and recovery capabilities.rn▸ Design and implement backup & recovery strategies using pg_basebackup, WAL backup, pgBackRest, and Barman.rn▸ Manage backup and recovery processes, ensuring compliance with defined RTO/RPO metrics.rnPerformance Tuning & Optimizationrn▸ Develop and execute performance tuning strategies including query optimization, indexing, and database configuration adjustments.rn▸ Troubleshoot production issues including locks, deadlocks, replication lag, and table bloat.rnDatabase Migrationrn▸ Lead database migrations from Oracle/MySQL to PostgreSQL, ensuring data integrity and minimal downtime.rn▸ Manage on-premises to cloud migrations, including planning, execution, and validation.rn▸ Collaborate with application teams to rewrite and optimize PL/SQL code into PostgreSQL-compatible PL/pgSQL functions and procedures.rnAutomation & Documentationrn▸ Automate routine DBA tasks using Shell scripting, Python, or Ansible.rn▸ Prepare and maintain documentation for migration strategies, configuration standards, and operational procedures.rn

Skill Requirements

Required Skills & Toolsrn▸ PostgreSQL — advanced administration, configuration, and tuningrn▸ HA/DR — Patroni, etcd, PgBouncer, streaming replicationrn▸ Backup & Recovery — pg_basebackup, WAL archiving, pgBackRest, Barmanrn▸ Migration — Oracle-to-PostgreSQL, MySQL-to-PostgreSQL, on-prem-to-cloudrn▸ PL/pgSQL — stored procedures, functions, triggersrn▸ Automation — Shell scripting, Python, Ansiblern▸ Monitoring — database health, capacity planning, incident responsern▸ Cloud Platforms — AWS / Azure / GCP (PostgreSQL managed services a plus)rn

Other Requirements

Automate routine DBA tasks using Shell scripting, Python, or Ansible.rn▸ Prepare and maintain documentation for migration strategies, configuration standards, and operational procedures.rn