- 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:
- 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
- Competitive salary and benefits package.
- Opportunity to work with a dynamic and innovative team.
- Professional growth and development opportunities.
- Collaborative and inclusive work environment.
- Work time: General shift
- Working days: 5 Days
- Mode of Employment - Work From Home
- Experience - 4-5 years
Skills Required
- 4–5 years of PostgreSQL administration experience
- At least 2 years of leadership experience
- Expertise in query tuning, indexing, partitioning, and execution plan analysis
- Proficiency with PostgreSQL extensions including pg_stat_statements, pg_partman, pg_repack, uuid-ossp, pg_cron, and auto_explain
- Deep experience with pgBackRest, Barman, and Point-in-Time Recovery
- Expertise configuring and managing Patroni, repmgr, and streaming replication
- Operational knowledge of AWS RDS and Aurora PostgreSQL
- Linux system administration and advanced Bash and Python scripting skills
- Familiarity with PMM, Nagios, Grafana, and Prometheus
- Strong problem-solving, communication, stakeholder collaboration, and leadership skills
- Bachelor’s or master’s degree in computer science, engineering, or equivalent
- PostgreSQL certification such as EDB or AWS
- Consulting or service-delivery experience in managed services or support
- Experience with large-scale migrations and modernization projects
- Exposure to multi-cloud environments and DBaaS platforms
What We Do
Mydbops is a leading open-source database management company, specializing in delivering cutting-edge solutions for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and other open-source database technologies. With over eight years of experience, we pride ourselves on providing comprehensive managed services, performance optimization, and consulting to help businesses achieve seamless database operations and scalability. Our team of certified database experts works closely with clients to understand their unique challenges and develop customized solutions tailored to their needs. From database design and implementation to ongoing monitoring and maintenance, we ensure optimal performance, security, and reliability for mission-critical applications. At Mydbops, we offer a range of services, including: Managed Services: Continuous monitoring, incident management, backup and recovery, high availability setup, and disaster recovery solutions. Consulting Services: Architecture design, migration strategies, performance tuning, and security audits to enhance database efficiency. Performance & Security Audits: Comprehensive analysis to identify bottlenecks, optimize queries, and strengthen database security protocols. Remote DBA Support: 24/7 assistance from our dedicated team, ensuring your database environment runs smoothly at all times. Cloud Cost Optimization: Tailored strategies to optimize cloud infrastructure, reducing costs while maintaining performance. Database Proxies: Implementing proxies like ProxySQL and MaxScale to enhance query handling, load balancing, and security. With a track record of handling over 10 billion database transactions daily, monitoring 3000+ servers, and successfully migrating more than 120 databases to the cloud, Mydbops has become a trusted partner for businesses across industries. Our commitment to delivering high-quality solutions, coupled with a passion for innovation, makes us the go-to choice for database management. In addition to our technical expertise, we prioritize building strong client relationships through transparent communication and collaborative decision-making. Our team believes in sharing knowledge and empowering clients, offering training sessions, webinars, and access to industry best practices.
Why Work With Us
Mydbops stands out as a leader in open-source database management, combining deep technical expertise with a strong commitment to innovation and security. What makes Mydbops unique is its focus on delivering tailored solutions for complex database challenges while fostering a supportive, growth-oriented work environment.
Gallery
