PostgreSQL DBA

Job Title : Lead Database Administrator

Location : Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai

• Immediate Joiners Only

Required Skills & Experience : PostgreSQL DBA (Level 3)

5+ years of hands-on PostgreSQL DBA experience in production environments.

Deep knowledge of PostgreSQL internals, architecture, and tuning.

Proven experience with pgBackRest, Barman, pg_basebackup, pg_dump.

Strong expertise with HA and replication solutions (Patroni, repmgr).

Hands-on experience with PITR, disaster recovery, and cluster rebuilds.

Proficiency in Linux / Unix environments, shell scripting, and automation.

Solid understanding of database security and compliance best practices.

Excellent troubleshooting skills and experience handling critical incidents.

Monitor and optimize performance, tune queries and indexes, manage vacuuming and bloat, implement pooling (PgBouncer), and maintain robust monitoring and alerts.

Diagnose and recover from cluster corruption using advanced tools and procedures, leveraging backups and replicas to ensure business continuity.

Plan and execute major upgrades (pg_upgrade, logical replication), cross-version and cross-platform migrations (on-prem ↔ cloud), ensuring minimal downtime and data integrity.

Strong hands-on experience with AWS PostgreSQL services like RDS and Aurora , including parameter groups, snapshot management, performance insights, and multi-AZ failover.

Experience with monitoring tools (Prometheus, Grafana, or similar) is a plus.

Good communication skills and ability to work collaboratively in a 24x7 production support environment.

Experience with logical replication and foreign data wrappers.

Familiarity with cloud-managed PostgreSQL services.

Familiarity with connection pooling and proxy tools (PgBouncer, HAProxy).

Maintain SOPs, runbooks, and knowledge base articles.

Automate routine tasks and checks using scripts or scheduling tools (cron, pg_cron).

Mentor junior DBAs and conduct knowledge-sharing sessions.

MySQL DBA Responsibilities (Secondary) :

Good knowledge of MySQL architecture and installation.

Perform MySQL backup and restore operations.

Manage MySQL users, roles, and permissions.

Setup and troubleshoot MySQL replication.