PostgreSQL Lead

Company: Mydbops

Website: Visit Website

Business Type: Small/Medium Business

Company Type: Product

Business Model: B2B

Funding Stage: Bootstrapped

Industry: Information Technology

Salary Range: ₹ 20-25 Lacs PA

Job Description Company Overview 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 9+ 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

Required Expertise

• 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.
• Collaborative and inclusive work environment.

Job Details

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