PostgreSQL DBA Lead

Job Title : PostgreSQL DBA Lead

Experience: 4 to 7 Years

Location: Chennai/ Nagercoil

Employment Type: Full-time

We are seeking an experienced PostgreSQL DBA Lead to own the design, performance, availability, and security of PostgreSQL databases across mission-critical systems. This role involves hands-on database administration, technical leadership, and collaboration with application, DevOps, and security teams.

Database Administration & Operations

• Lead installation, configuration, upgrade, and patching of PostgreSQL databases (on-prem & cloud).
• Ensure high availability using replication, clustering, and failover solutions (Streaming Replication, Patroni, etc.).
• Design and manage backup, restore, and disaster recovery strategies.
• Perform capacity planning and proactive performance tuning.

Performance & Reliability

• Monitor database health, identify bottlenecks, and optimize queries, indexes, and schemas.
• Ensure SLAs for uptime, latency, and throughput are met.
• Handle complex production issues and lead root-cause analysis (RCA).

Security & Compliance

• Implement database security best practices (roles, privileges, encryption, auditing).
• Ensure compliance with organizational and regulatory standards.
• Manage data access controls and vulnerability remediation.

Automation & DevOps Integration

• Drive automation using scripting (Shell, Python) and infrastructure-as-code tools.
• Collaborate with DevOps teams on CI/CD pipelines, containerization, and cloud deployments.
• Manage PostgreSQL on cloud platforms (AWS RDS/Aurora, Azure, GCP).

Leadership & Stakeholder Management

• Lead, mentor, and review work of DBA team members.
• Define database standards, documentation, and operational runbooks.
• Partner with architects, developers, and product teams on data design decisions.

Technical Skills

• 47 years of database experience with at least 3+ years in PostgreSQL administration.
• Strong knowledge of PostgreSQL internals, indexing, query optimization, and VACUUM strategies.
• Experience with HA/DR solutions (Streaming Replication, Patroni, PgBouncer).
• Hands-on experience with cloud-managed PostgreSQL services.
• Strong Linux/Unix system administration skills.
• Scripting experience (Shell, Python).

Leadership & Soft Skills

• Proven experience leading or mentoring DBAs or technical teams.
• Strong troubleshooting and analytical skills.
• Excellent communication and stakeholder management abilities.

Good to Have

• Experience with other databases (MySQL, Oracle, MongoDB).
• Exposure to Kubernetes and containerized database deployments.
• PostgreSQL or cloud certifications (AWS/Azure/GCP).