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 Team), 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:

- Prospect 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 Details:

- Job Type: Full-time
- Work Days: 5 Days
- Work Mode: Work From Home
- Experience Required: 3–5 years

Job Types: Full-time, Permanent

Benefits:

- Provident Fund

Education:

- Bachelor's (Required)

Experience:

- PostgreSQL: 3 years (Required)
- Database administration: 3 years (Required)

Work Location: Remote

📌 Database Consultant-I (PostgreSQL) (India)
🏢 Mydbops
📍 India