Manage and optimize production PostgreSQL environments for performance, stability, scalability, and high availability. Responsibilities include troubleshooting, query optimization, backups, recovery, replication, failover, upgrades, patching, migrations, monitoring, and cloud database management. The role collaborates with DevOps and cloud teams, designs and implements client solutions, provides customer-facing technical delivery, and mentors junior engineers.
Job Description for Database Consultant-I (PostgreSQL)
Job Title: Database Consultant-I (PostgreSQL)
Company: Mydbops
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.
As a Database Consultant – I (PostgreSQL), you will take ownership of PostgreSQL database environments, offering expert-level support to our clients. This role involves proactive monitoring, performance tuning, troubleshooting, high availability setup, and guiding junior team members. You will play a key role in customer-facing technical delivery, solution design, and implementation.
Manage PostgreSQL production environments for performance, stability, and scalability.
Handle complex troubleshooting, performance analysis, and query optimisation.
Implement backup strategies, recovery solutions, replication, and failover techniques.
Set up and manage high availability architectures (Streaming Replication, Patroni, etc.).
Work with DevOps/cloud teams for deployment and automation.
Support upgrades, patching, and migration projects across environments.
Use monitoring tools to proactively detect and resolve issues.
Mentor junior engineers and guide troubleshooting efforts.
Interact with clients to understand requirements and deliver solutions.
3–5 years of hands-on experience in PostgreSQL database administration.
Strong Linux OS knowledge and scripting skills (Bash/Python).
Proficiency in SQL tuning, performance diagnostics, and explain plans.
Experience with tools like pgBackRest, Barman for backup and recovery.
Familiarity with high availability, failover, replication, and clustering.
Good understanding of AWS RDS, Aurora PostgreSQL, and GCP Cloud SQL.
Experience with monitoring tools like pg_stat_statements, PMM, Nagios, or custom dashboards.
Knowledge of automation/configuration tools like Ansible or Terraform is a plus.
Strong communication and problem-solving skills.
Bachelor’s or Master’s degree in Computer Science, Engineering, or equivalent.
PostgreSQL certification (EDB/Cloud certifications preferred).
Past experience in a consulting, customer support, or managed services role.
Exposure to multi-cloud environments and database-as-a-service platforms.
Prior experience with database migrations or modernisation projects.
Opportunity to work in a dynamic and growing industry.
Learning and development opportunities to enhance your career.
A collaborative work environment with a supportive team.
Job Type: Full-time
Work Days: 5 Days
Work Mode: Work From Home
Experience Required: 3–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.
