Lead the architecture, performance, reliability, and scalability of PostgreSQL production environments. Design high-availability and disaster-recovery systems, define backup and failover protocols, manage migrations and upgrades, and collaborate on cloud automation. Troubleshoot complex database issues, implement monitoring and observability, mentor DBAs, engage customers, present technical solutions, and establish database best practices.
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 optimisation, 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 resolve issues proactively
- 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
- Experience: 4-5 years in PostgreSQL administration, with at least 2+ years in a leadership role
- Performance Optimisation: 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 reorganisation
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.
- 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 modernisation 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
MYDBOPS Bengaluru, Karnataka, IND Office
Indiqube Penta, 32, Shanthala Nagar, Bengaluru, Karnataka, India, 560025
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Owns strategy, roadmap, backlog, requirements, and delivery for digital healthcare and pharmacy products. Translates stakeholder needs into features, user stories, wireframes, and acceptance criteria; partners with UX, engineering, and business teams to prioritize releases and manage product lifecycles. Analyzes data, communicates product vision, conducts demonstrations, manages risks, and drives continuous improvement within Agile development environments.
Top Skills:
Aha!ChatbotsConversational AiIvrJIRARally
Events • Food • Travel • Hospitality • Hotels & Resorts
Manage corporate and group hotel accounts, develop new business, drive room and food-and-beverage revenue, negotiate contracts, conduct site visits, and oversee the full sales cycle. Analyze sales performance, build strategic revenue plans, coordinate service delivery across departments, and coach sales team members. The role requires hotel group-sales experience, strong relationship-building and negotiation skills, revenue management capabilities, and proficiency with hotel sales systems.
Top Skills:
DelphiMarket Planner SurveyOnqSalesforce
Cloud • Software
Lead complex customer investigations involving cloud services, network data, logs, and product behavior. Coordinate escalations with Engineering and Product, recommend fixes, create automation and documentation, mentor engineers, and support customers through scheduled 24-hour coverage. Diagnose technologies including DNS, HTTP/HTTPS, TCP/IP, routing, proxies, authentication, and SSO.
Top Skills:
APIsAuthenticationCiscoCloud ServicesContainersDnsHTTPHttpsJavaLinuxLogsMonitoring DataNetwork TracesProxy ServersPythonRoutingSaaSSingle Sign-OnTcp/IpThousandeyesVirtual Machines
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
