Job Description for PostgreSQL Lead

Job Title: PostgreSQL Lead

Company: Mydbops

About us:

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 optimization, 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 proactively resolve issues
- 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 Optimization: Expert in query tuning,



indexing strategies, partitioning, and execution plan analysis.
- Extension Management: Proficient with critical PostgreSQL extensions including:
- pg_stat_statements – query performance tracking
- pg_partman – partition maintenance
- pg_repack – online table reorganization
- uuid-ossp – UUID generation
- 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 modernization 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.
- Cooperative and inclusive work environment.

Job Details:

- Work time: General shift
- Working days: 5 Days
- Mode of Employment - Work From Home
- Experience - 4-5 years

Skills:- PostgreSQL, Amazon Web Services (AWS), Linux administration, Backup, Disaster recovery, AWS RDS, Deployment management and Monitoring

📌 PostgreSQL Lead (India)
🏢 Mydbops
📍 India