Database Consultant - l (PostgreSQL)

Mydbops LLP; Karnataka; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Mydbops LLP seeks a Database Consultant I (PostgreSQL) to own PostgreSQL environments, provide expert support, and guide junior engineers. You will engage in performance tuning, proactive monitoring, and design of scalable, reliable database solutions for customer projects.

The role emphasizes collaboration with DevOps, clients, and cross-functional teams to ensure high availability, smooth migrations, and successful delivery of services across multi-cloud and on-premise environments.

Qualifications

• 3-5 years of hands-on PostgreSQL database administration experience.
• Strong Linux OS knowledge and scripting in Bash/Python.
• Proficiency in SQL tuning, performance diagnostics, and explain plans.
• Experience with backup/recovery tools like pgBackRest or Barman.
• Familiarity with high availability, replication, and clustering.
• Knowledge of AWS RDS/Aurora PostgreSQL and GCP Cloud SQL.

Responsibilities

• 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.

Skills

PostgreSQL administration

Linux

Scripting (Bash/Python)

Education

Bachelor's or Master's in CS/Engineering

Tools

pgBackRest

Barman

pg_stat_statements

PMM

Nagios

Ansible

Terraform

Job description

Job Description for Database Consultant-I (PostgreSQL)

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 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.

Key Responsibilities:

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.

Requirements:

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.

Preferred Qualifications:

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.

Why Join Us:

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.