MYDBOPS Jobs

Database Consultant - l (PostgreSQL)

MYDBOPS

Database Consultant - l (PostgreSQL)

Posted 16 Days Ago

Be an Early Applicant

Hiring Remotely in KA, IND

Remote

Mid level

Cloud • Information Technology • Database • Analytics • Big Data Analytics • Automation • Data Privacy

Empowering Businesses with Expert Database Solutions

The Role

Manage and optimize production PostgreSQL environments for performance, stability, scalability, and high availability. Responsibilities include troubleshooting, query optimization, backups, recovery, replication, failover, upgrades, patching, migrations, monitoring, and cloud database management. The role collaborates with DevOps and cloud teams, designs and implements client solutions, provides customer-facing technical delivery, and mentors junior engineers.

Summary Generated by Built In

Job Description for Database Consultant-I (PostgreSQL)

Job Title: 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.

Job Details:

Job Type: Full-time

Work Days: 5 Days

Work Mode: Work From Home

Experience Required: 3–5 years

Skills Required

3-5 years of hands-on PostgreSQL database administration experience
Strong Linux operating system knowledge
Bash or Python scripting skills
Proficiency in SQL tuning, performance diagnostics, and explain plans
Experience with pgBackRest or Barman for backup and recovery
Familiarity with high availability, failover, replication, and clustering
Understanding of AWS RDS, Aurora PostgreSQL, and GCP Cloud SQL
Experience with monitoring tools such as pg_stat_statements, PMM, Nagios, or custom dashboards
Strong communication and problem-solving skills
Knowledge of Ansible or Terraform
Bachelor's or Master's degree in Computer Science, Engineering, or equivalent
PostgreSQL certification, preferably EDB or cloud certification
Experience in consulting, customer support, or managed services
Exposure to multi-cloud environments and database-as-a-service platforms
Experience with database migrations or modernization projects

View all jobs at MYDBOPS

View MYDBOPS Profile

Report Job

Am I A Good Fit?

beta

Get Personalized Job Insights.

Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

HQ: Bengaluru, Karnataka

200 Employees

Year Founded: 2015

What We Do

Mydbops is a leading open-source database management company, specializing in delivering cutting-edge solutions for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and other open-source database technologies. With over eight years of experience, we pride ourselves on providing comprehensive managed services, performance optimization, and consulting to help businesses achieve seamless database operations and scalability. Our team of certified database experts works closely with clients to understand their unique challenges and develop customized solutions tailored to their needs. From database design and implementation to ongoing monitoring and maintenance, we ensure optimal performance, security, and reliability for mission-critical applications. At Mydbops, we offer a range of services, including: Managed Services: Continuous monitoring, incident management, backup and recovery, high availability setup, and disaster recovery solutions. Consulting Services: Architecture design, migration strategies, performance tuning, and security audits to enhance database efficiency. Performance & Security Audits: Comprehensive analysis to identify bottlenecks, optimize queries, and strengthen database security protocols. Remote DBA Support: 24/7 assistance from our dedicated team, ensuring your database environment runs smoothly at all times. Cloud Cost Optimization: Tailored strategies to optimize cloud infrastructure, reducing costs while maintaining performance. Database Proxies: Implementing proxies like ProxySQL and MaxScale to enhance query handling, load balancing, and security. With a track record of handling over 10 billion database transactions daily, monitoring 3000+ servers, and successfully migrating more than 120 databases to the cloud, Mydbops has become a trusted partner for businesses across industries. Our commitment to delivering high-quality solutions, coupled with a passion for innovation, makes us the go-to choice for database management. In addition to our technical expertise, we prioritize building strong client relationships through transparent communication and collaborative decision-making. Our team believes in sharing knowledge and empowering clients, offering training sessions, webinars, and access to industry best practices.

Why Work With Us

Mydbops stands out as a leader in open-source database management, combining deep technical expertise with a strong commitment to innovation and security. What makes Mydbops unique is its focus on delivering tailored solutions for complex database challenges while fostering a supportive, growth-oriented work environment.