Simple Logic - Lead Database Administrator - IT Operations

Description :

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, pgdump

- 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) :