Mydbops - Database Consultant I - PostgreSQL

Job Title : Database Consultant-I : : 3 to 5 : 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 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 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 :
• 3 to 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 Qualifications :
• Bachelors or Masters 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 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 : Days : 5 Mode : Work From Required : 3 to 5 years

(ref:hirist.tech)

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 Overview