Senior EDB PostgreSQL Database Administrator (Postgres EDB)

EY; New Delhi; On-site; INR 1,500,000 - 2,600,000; Full time

Job summary

EY seeks an experienced Senior PostgreSQL DBA to manage enterprise PostgreSQL environments across on-premises and cloud deployments in India, with a focus on Delhi. You will handle performance tuning, high availability, disaster recovery, replication, backup, security auditing, and automation to support mission-critical applications.

You will lead performance tuning, HA/DR design, replication management, and RCA-driven improvements while coordinating with DevOps and application teams to ensure

Qualifications

• Experience with PostgreSQL administration in production environments.
• Strong skills in performance tuning and query optimization.
• Experience implementing HA/DR solutions and replication technologies.
• Familiarity with security controls, encryption, and auditing in database environments.

Responsibilities

• Install, configure, and maintain PostgreSQL databases in production and non-production environments.
• Monitor database health, availability, performance, and capacity.
• Perform database performance tuning, query optimization, and troubleshooting.
• Manage PostgreSQL replication technologies (Streaming & Logical).
• Implement HA solutions using Patroni, PgPool-II, or Repmgr.
• Design, test, and maintain Disaster Recovery and Business Continuity plans.
• Perform backup and restore operations with pgBackRest, Barman, or native tools.
• Support upgrades, migrations, and patch management.
• Coordinate failover/switchover testing for business continuity.
• Monitor replication lag, backups, storage, and performance metrics.
• Enforce database security controls, access management, encryption, and auditing.
• Drive RCA for incidents and implement preventive actions.
• Automate routine tasks using Shell, Python, Ansible, etc.
• Collaborate with application, infrastructure, cloud, and DevOps teams.

Skills

PostgreSQL administration

Performance tuning

HA/DR design

Replication management

Automation

Security auditing

Tools

Patroni

PgPool-II

Repmgr

pgBackRest

Barman

Python

Ansible

Shell scripting

Job description

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.