Description :
Job Title : Lead Database Administrator
Location : Onsite in Vikhroli, Mumbai (all areas) & Navi Mumbai
Required Skills & Experience :
PostgreSQL DBA (Level 3)5+ years of hands-on PostgreSQL DBA experience in production environmentsDeep knowledge of PostgreSQL internals, architecture, and tuningProven experience with pgBackRest, Barman, pg basebackup, pgdumpStrong expertise with HA and replication solutions (Patroni, repmgr)Hands-on experience with PITR, disaster recovery, and cluster rebuildsProficiency in Linux / Unix environments, shell scripting, and automationSolid understanding of database security and compliance best practicesExcellent troubleshooting skills and experience handling critical incidentsMonitor and optimize performance, tune queries and indexes, manage vacuuming and bloat, implement pooling (PgBouncer), and maintain robust monitoring and alertsDiagnose and recover from cluster corruption using advanced tools and procedures, leveraging backups and replicas to ensure business continuityPlan and execute major upgrades (pg_upgrade, logical replication), cross-version and cross-platform migrations (on-prem ? cloud), ensuring minimal downtime and data integrityStrong hands-on experience with AWS PostgreSQL services like RDS and Aurora, including parameter groups, snapshot management, performance insights, and multi-AZ failoverExperience with monitoring tools (Prometheus, Grafana, or similar) is a plusGood communication skills and ability to work collaboratively in a 24x7 production support environmentExperience with logical replication and foreign data wrappersFamiliarity with cloud-managed PostgreSQL servicesFamiliarity with connection pooling and proxy tools (PgBouncer, HAProxy)Maintain SOPs, runbooks, and knowledge base articlesAutomate routine tasks and checks using scripts or scheduling tools (cron, pg_cron)Mentor junior DBAs and conduct knowledge-sharing sessionsMySQL DBA Responsibilities (Secondary) :
Good knowledge of MySQL architecture and installationPerform MySQL backup and restore operationsManage MySQL users, roles, and permissionsSetup and troubleshoot MySQL replication(ref : hirist.tech)