Job Description For PostgreSQL Lead
Job Title: PostgreSQL Lead
Company: Mydbops
About Us
Mydbops helps rapid-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 Optimizatio
📌 PostgreSQL Lead (India)
🏢 Mydbops
📍 India