PostgreSQL Lead

Mydbops LLP; Karnataka; Hybrid; INR 2,400,000 - 4,800,000; Full time

Benefits offered by this job

Competitive salary and benefits

Growth opportunities

Collaborative environment

Professional development

Job summary

Mydbops LLP is seeking a PostgreSQL Lead to own the design, implementation, and operations of PostgreSQL environments. You’ll lead technical decisions, mentor the team, interface with customers, and drive initiatives across performance tuning, high availability architectures, migrations, and cloud deployments.

You will collaborate with DevOps and cloud teams to manage backups, monitoring, and security practices, and provide guidance during complex problem solving.

Qualifications

• 4-5 years PostgreSQL administration with leadership experience.
• Expert in query tuning, indexing, partitioning, and execution plan analysis.
• Proficient with PostgreSQL extensions including pg_partman, pg_repack, pg_cron, auto_explain.
• Deep experience with backup/recovery tools like pgBackRest and Barman.
• High availability and clustering with Patroni, repmgr, streaming replication.
• Cloud platforms knowledge with AWS RDS/Aurora PostgreSQL.
• Strong scripting in Bash and Python; DevOps collaboration.

Responsibilities

• Lead PostgreSQL production environments: architecture, stability, performance, and scalability.
• Oversee complex troubleshooting, query optimisation, and performance analysis.
• Architect and maintain HA/DR systems (Streaming Replication, Patroni, repmgr).
• Define backup, recovery, replication, and failover protocols.
• Guide DB migrations, patches, and upgrades across environments.
• Collaborate with DevOps and cloud teams for infrastructure automation.
• Use monitoring (pg_stat_statements, PMM, Nagios; Grafana/Prometheus) to resolve issues.
• Provide technical mentorship—peer reviews, upskilling, onboarding junior DBAs.
• Lead customer interactions: understand requirements, design solutions, present proposals.
• Drive process improvements and establish database best practices.

Skills

Leadership

Mentoring

Stakeholder communication

Query optimisation

Education

Bachelor's/Master's in CS/Engineering

PostgreSQL certifications (EDB, AWS)

Tools

Patroni

repmgr

pgBackRest

Barman

pg_partman

pg_repack

pg_cron

auto_explain

AWS RDS

Aurora PostgreSQL

Grafana

Prometheus

Nagios

PMM

Job description

Mydbops helps fast-growing teams and unicorns run mission-critical databases with speed, scale, and reliability. Trusted by 800+ clients, including 30+ unicorns, we optimize and manage systems like MySQL, PostgreSQL, MongoDB, MariaDB, TiDB, and Cassandra, powering 10B+ transactions daily across industries such as fintech, SaaS, healthcare, logistics, and e-commerce.

With 10 years of deep expertise, we build automation tools, lead complex migrations, and solve high-impact performance and database challenges. We are ISO and PCI-DSS certified, combining engineering excellence with enterprise-grade security and compliance.

Role Overview

As the PostgreSQL Lead , you will own the design, implementation, and operational excellence of PostgreSQL environments. You’ll lead technical decision-making, mentor the team, interface with customers, and drive key initiatives covering performance tuning, HA architectures, migrations, and cloud deployments.

Key Responsibilities

• Lead PostgreSQL production environments: architecture, stability, performance, and scalability
• Oversee complex troubleshooting, query optimisation, and performance analysis
• Architect and maintain HA/DR systems (e.g., Streaming Replication, Patroni, repmgr)
• Define backup, recovery, replication, and failover protocols
• Guide DB migrations, patches, and upgrades across environments
• Collaborate with DevOps and cloud teams for infrastructure automation
• Use monitoring (pg_stat_statements, PMM, Nagios or any monitoring stack) to resolve issues proactively
• Provide technical mentorship—conduct peer reviews, upskill, and onboard junior DBAs
• Lead customer interactions: understand requirements, design solutions, and present proposals
• Drive process improvements and establish database best practices

Requirements

• Experience: 4-5 years in PostgreSQL administration, with at least 2+ years in a leadership role
• Performance Optimisation: Expert in query tuning, indexing strategies, partitioning, and execution plan analysis.
• Extension Management: Proficient with critical PostgreSQL extensions including:

pg_partman – partition maintenance

pg_repack – online table reorganisation

pg_cron – native job scheduling

auto_explain – capturing costly queries

• Backup & Recovery: Deep experience with pgBackRest, Barman, and implementing Point-in-Time Recovery (PITR).
• High Availability & Clustering: Proven expertise in configuring and managing HA environments using Patroni , repmgr , and streaming replication.
• Cloud Platforms: Strong operational knowledge of AWS RDS and Aurora PostgreSQL , including parameter tuning, snapshot management, and performance insights.
• Scripting & Automation: Skilled in Linux system administration, with advanced scripting capabilities in Bash and Python .
• Monitoring & Observability: Familiar with pg_stat_statements, PMM , Nagios , and building custom dashboards using Grafana and Prometheus .
• Leadership & Collaboration: Strong problem-solving skills, effective communication with stakeholders, and experience leading database reliability and automation initiatives.

Preferred Qualifications

• Bachelor’s/Master’s degree in CS, Engineering, or equivalent
• PostgreSQL certifications (e.g., EDB, AWS)
• Consulting/service delivery experience in managed services or support roles
• Experience in large-scale migrations and modernisation projects
• Exposure to multi-cloud environments and DBaaS platforms

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.