As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Our Customer Account Management team is vital in ensuring client satisfaction and loyalty.
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.
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
Job Types: Full-time, Permanent
Pay: ?1,500,000.00 - ?2,200,000.00 per year
Benefits:
Provident Fund
Schedule:
Fixed shift
Monday to Friday
Supplemental Pay:
Performance bonus
Education:
Bachelor's (Required)
Experience:
PostgreSQL: 4 years (Required)
PostgreSQL Lead: 2 years (Required)
Work Location: Remote
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.