Job Description & How to Apply Below
Lead Database Administrator (Postgre
SQL + Cloud)
Location:
Mumbai (all areas) & Navi Mumbai
Required
Skills & Experience:
Postgre
SQL DBA
4+ years of hands-on Postgre
SQL DBA experience in production environments.
Deep knowledge of Postgre
SQL internals, architecture, and tuning.
Proven experience with pgBackRest, Barman, , .
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 (, logical replication), cross-version and cross-platform migrations (on-prem ↔ cloud), ensuring minimal downtime and data integrity.
Strong hands-on experience with AWS Postgre
SQL 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 Postgre
SQL 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, ).
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.
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
×