PostgreSQL Lead

SourcingXPress; Bengaluru; Remote; INR 2,000,000 - 2,500,000; Full time

Benefits offered by this job

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 summary

A tech solutions provider is seeking a PostgreSQL Lead to design and maintain PostgreSQL environments. Responsibilities include leading technical decisions, mentoring a team, and collaborating with customers to drive performance tuning and establish best practices. The ideal candidate has 4-5 years of PostgreSQL administration experience, including leadership in a tech setting and a strong background in performance optimization and cloud platforms. Competitive salary and work from home options are provided.

Qualifications

• 4-5 years in PostgreSQL administration, with at least 2+ years in a leadership role.
• Expert in query tuning, indexing strategies, partitioning, and execution plan analysis.
• Deep experience with pgBackRest, Barman, and implementing Point-in-Time Recovery (PITR).

Responsibilities

• Lead PostgreSQL production environments: architecture, stability, performance, and scalability.
• Oversee complex troubleshooting, query optimization, and performance analysis.
• Guide DB migrations, patches, and upgrades across environments.

Skills

Performance Optimization

Cloud Platforms

Scripting & Automation

Monitoring & Observability

Leadership & Collaboration

Education

Bachelor’s/Master’s degree in CS, Engineering, or equivalent

Tools

pg_stat_statements

AWS RDS and Aurora PostgreSQL

Bash

Python

Grafana

Prometheus

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.

Company Details

• 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

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