*Delivery Manager** **\|** **Engineering, AI \& Data – Engineering \|** **PostgreSQL DBA**
*Location:** **Mumbai**
*The team**
Engineering helps Reimagine and re\-engineer mission\-critical operations and processes; Leverage engineering\-led design, deep industry knowledge, and AI and data\-driven insights to transform the technology platforms at the heart of business.
Working alongside team, we empower and drive mission\-critical solutions whether we need to modernize existing systems or implement new technology products and platforms. Through innovation, we improve financial performance, accelerate new digital businesses and fuel growth. Learn more about Engineering, AI and Data
*Your work profile**
We are seeking a highly experienced Senior Database Administrator specializing in PostgreSQL and EDB Postgres (EPAS) to manage enterprise\-grade on\-premise environments. The role involves designing and implementing high availability (HA) and disaster recovery (DR) solutions, performance tuning, security hardening, and leading modernization initiatives, including Oracle\-to\-Postgres migrations.
Architecture \& High Availability
Design and manage HA/DR solutions using Streaming Replication, Logical Replication, Patroni, repmgr, pgpool\-II, and EDB Failover Manager (EFM).
Plan capacity, WAL strategies, and storage optimization for large\-scale deployments.
Administration
Install, configure, patch, and upgrade PostgreSQL and EPAS clusters.
Implement robust backup \& recovery strategies using pgBackRest, Barman, and perform PITR and DR drills.
Performance \& Optimization
Conduct query tuning using pg\_stat\_statements, EXPLAIN ANALYZE, and auto\_explain.
Optimize indexes (B\-tree, GIN/GiST, BRIN), partitioning, vacuum/autovacuum, and statistics for performance.
Security \& Compliance
Configure SCRAM\-SHA\-256, SSL/TLS, pg\_hba.conf policies, and RBAC.
Implement Row\-Level Security (RLS) and integrate with LDAP/Kerberos for enterprise authentication.
*Key skills required:**
Bachelor’s/Master’s degree in Computer Science, IT, or related field.
9–15 years of DBA experience with strong PostgreSQL and EPAS expertise in on\-premise production environments.
Hands\-on experience with HA/DR, replication, and failover strategies.
Strong knowledge of performance tuning, indexing, partitioning, and vacuum strategies.
Proficiency in Linux administration and scripting (Bash/Python).
Familiarity with monitoring tools (Prometheus/Grafana, PEM) and automation frameworks.
Experience with Oracle\-to\-Postgres migration using EDB tools.
Knowledge of pgBouncer, pgpool\-II, and advanced PostgreSQL extensions (PostGIS, TimescaleDB).
Certifications: PostgreSQL Professional or EDB Postgres Advanced DBA.