Database Consultant-I (PostgreSQL)

8 years

13 - 14 Lacs

Posted:1 month ago| Platform: Linkedin logo

Apply

Work Mode

Remote

Job Type

Full Time

Job Description

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

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

  • Job Type: Full-time
  • Work Days: 5 Days
  • Work Mode: Work From Home
  • Experience Required: 3–5 years
Skills:- PostgreSQL, Linux OS, Scripting, AWS RDS, Aurora PostgreSQL, SQL tuning and Google Cloud Platform (GCP)

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Mydbops logo
Mydbops

Database Management

Tech City

RecommendedJobs for You