PostgreSQL Cloud DBA

Job Title : Lead Database Administrator (PostgreSQL + Cloud)

Location : Mumbai (all areas) & Navi Mumbai

Required Skills & Experience : PostgreSQL DBA

• 4+ 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) :