Job Description for Database Consultant-I (PostgreSQL)

Job Title: Database Consultant-I (PostgreSQL)

Company: Mydbops

About Us:

Mydbops is a trusted leader with 8+ years of excellence in open-source database management. We deliver best-in-class services across MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. Our focus is on building scalable, secure, and high-performance database solutions for global clients. As a PCI DSS-certified and ISO-certified organisation, we are committed to operational excellence and data security.

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.

Solid 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, repl

📌 Database Consultant (Bengaluru)
🏢 Mydbops It
📍 Bengaluru