Senior PostgreSQL Database Administrator (PostgreSQL DBA)

We are seeking an experienced Senior PostgreSQL DBA to manage, maintain, and optimize enterprise PostgreSQL database environments. The ideal candidate will be responsible for database administration, performance tuning, high availability, disaster recovery, replication management, security compliance, and database automation for mission-critical applications.

• Install, configure, administer, and maintain PostgreSQL databases in production and non-production environments.
• Monitor database health, availability, performance, and capacity to ensure optimal system reliability.
• Perform database performance tuning, query optimization, and troubleshooting of complex issues.
• Manage PostgreSQL replication technologies, including Streaming Replication and Logical Replication.
• Implement and maintain High Availability (HA) solutions using tools such as Patroni, PgPool-II, or Repmgr.
• Design, manage, and test Disaster Recovery (DR) and Business Continuity solutions.
• Perform database backup and recovery operations using pgBackRest, Barman, or native PostgreSQL tools.
• Support database upgrades, migrations, and patch management activities.
• Conduct failover and switchover testing to ensure business continuity readiness.
• Monitor replication lag, backup success rates, storage utilization, and database performance metrics.
• Implement database security controls, user access management, encryption, and auditing.
• Ensure compliance with security policies, governance standards, and regulatory requirements.
• Drive Root Cause Analysis (RCA) for database incidents and implement preventive actions.
• Automate routine database administration tasks using Shell Scripting, Python, Ansible, or similar tools.
• Collaborate with application, infrastructure, cloud, and DevOps teams to support business-critical workloads.
• Support PostgreSQL deployments across on-premises, Azure, AWS, and Hybrid Cloud environments.
• Create and maintain operational documentation, SOPs, and database runbooks.
• Participate in 24x7 production support and major incident management activities.