MyDBOPS

Job Description for PostgreSQL Lead

Job Title: PostgreSQL Lead

Company: Mydbops

About us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Our Customer Account Management team is vital in ensuring client satisfaction and loyalty.

Role Overview

As the PostgreSQL Lead, you will own the design, implementation, and operational excellence of PostgreSQL environments. You’ll lead technical decision-making, mentor the team, interface with customers, and drive key initiatives covering performance tuning, HA architectures, migrations, and cloud deployments.

Key Responsibilities

• Lead PostgreSQL production environments: architecture, stability, performance, and scalability

• Oversee complex troubleshooting, query optimization, and performance analysis

• Architect and maintain HA/DR systems (e.g., Streaming Replication, Patroni, repmgr)

• Define backup, recovery, replication, and failover protocols

• Guide DB migrations, patches, and upgrades across environments

• Collaborate with DevOps and cloud teams for infrastructure automation

• Use monitoring (pg_stat_statements, PMM, Nagios or any monitoring stack) to proactively resolve issues

• Provide technical mentorship—conduct peer reviews, upskill, and onboard junior DBAs

• Lead customer interactions: understand requirements, design solutions, and present proposals

• Drive process improvements and establish database best practices

Requirements

• Experience: 4-5 years in PostgreSQL administration, with at least 2+ years in a leadership role

• Performance Optimization: Expert in query tuning, indexing strategies, partitioning, and execution plan analysis.

• Extension Management: Proficient with critical PostgreSQL extensions including:
• pg_stat_statements – query performance tracking
• pg_partman – partition maintenance
• pg_repack – online table reorganization
• uuid-ossp – UUID generation
• pg_cron – native job scheduling
• auto_explain – capturing costly queries

• Backup & Recovery: Deep experience with pgBackRest, Barman, and implementing Point-in-Time Recovery (PITR).

• High Availability & Clustering: Proven expertise in configuring and managing HA environments using Patroni, repmgr, and streaming replication.

• Cloud Platforms: Strong operational knowledge of AWS RDS and Aurora PostgreSQL, including parameter tuning, snapshot management, and performance insights.

• Scripting & Automation: Skilled in Linux system administration, with advanced scripting capabilities in Bash and Python.

• Monitoring & Observability: Familiar with pg_stat_statements, PMM, Nagios, and building custom dashboards using Grafana and Prometheus.

• Leadership & Collaboration: Strong problem-solving skills, effective communication with stakeholders, and experience leading database reliability and automation initiatives.

Preferred Qualifications

• Bachelor’s/Master’s degree in CS, Engineering, or equivalent

• PostgreSQL certifications (e.g., EDB, AWS)

• Consulting/service delivery experience in managed services or support roles

• Experience in large-scale migrations and modernization projects

• Exposure to multi-cloud environments and DBaaS platforms

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.

Job Details:

• Work time: General shift
• Working days: 5 Days
• Mode of Employment - Work From Home
• Experience - 4-5 years

Job Description for PostgreSQL Lead

Job Title: PostgreSQL Lead

Company: Mydbops

About us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Our Customer Account Management team is vital in ensuring client satisfaction and loyalty.

Role Overview

As the PostgreSQL Lead, you will own the design, implementation, and operational excellence of PostgreSQL environments. You’ll lead technical decision-making, mentor the team, interface with customers, and drive key initiatives covering performance tuning, HA architectures, migrations, and cloud deployments.

Key Responsibilities

• Lead PostgreSQL production environments: architecture, stability, performance, and scalability
• 
  
• Oversee complex troubleshooting, query optimization, and performance analysis
• 
  
• Architect and maintain HA/DR systems (e.g., Streaming Replication, Patroni, repmgr)
• 
  
• Define backup, recovery, replication, and failover protocols
• 
  
• Guide DB migrations, patches, and upgrades across environments
• 
  
• Collaborate with DevOps and cloud teams for infrastructure automation
• 
  
• Use monitoring (pg_stat_statements, PMM, Nagios or any monitoring stack) to proactively resolve issues
• 
  
• Provide technical mentorship—conduct peer reviews, upskill, and onboard junior DBAs
• 
  
• Lead customer interactions: understand requirements, design solutions, and present proposals
• 
  
• Drive process improvements and establish database best practices

Requirements

• Experience: 4-5 years in PostgreSQL administration, with at least 2+ years in a leadership role
• 
  
• Performance Optimization: Expert in query tuning, indexing strategies, partitioning, and execution plan analysis.
• 
  
• Extension Management: Proficient with critical PostgreSQL extensions including:
• 
  
• pg_stat_statements – query performance tracking
• 
  
• pg_partman – partition maintenance
• 
  
• pg_repack – online table reorganization
• 
  
• uuid-ossp – UUID generation
• 
  
• pg_cron – native job scheduling
• 
  
• auto_explain – capturing costly queries
• 
  
• Backup & Recovery: Deep experience with pgBackRest, Barman, and implementing Point-in-Time Recovery (PITR).
• 
  
• High Availability & Clustering: Proven expertise in configuring and managing HA environments using Patroni, repmgr, and streaming replication.
• 
  
• Cloud Platforms: Strong operational knowledge of AWS RDS and Aurora PostgreSQL, including parameter tuning, snapshot management, and performance insights.
• 
  
• Scripting & Automation: Skilled in Linux system administration, with advanced scripting capabilities in Bash and Python.
• 
  
• Monitoring & Observability: Familiar with pg_stat_statements, PMM, Nagios, and building custom dashboards using Grafana and Prometheus.
• 
  
• Leadership & Collaboration: Strong problem-solving skills, effective communication with stakeholders, and experience leading database reliability and automation initiatives.
• 
  
• 
  

Preferred Qualifications

• Bachelor’s/Master’s degree in CS, Engineering, or equivalent
• 
  
• PostgreSQL certifications (e.g., EDB, AWS)
• 
  
• Consulting/service delivery experience in managed services or support roles
• 
  
• Experience in large-scale migrations and modernization projects
• 
  
• Exposure to multi-cloud environments and DBaaS platforms

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.
• 
  

Job Details:

• Work time: General shift
• Working days: 5 Days
• Mode of Employment - Work From Home
• Experience - 4-5 years

Job Description for Intern Associate People Manager

Job Title: Intern Associate People Manager

Location: Bangalore

Work mode: Work from Office

About us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Mydbops takes pride in being a PCI DSS-certified and ISO-certified company, reflecting our unwavering commitment to maintaining the highest security and operational excellence standards

Job Summary:

We are seeking a dynamic and results-driven Associate People Manager to join our HR team. This role will be responsible for supporting the People Manager in managing the employee lifecycle, ensuring employee engagement, and driving talent development initiatives within the organization. The ideal candidate will have a passion for people management and a strong ability to foster a positive work environment.

Key Responsibilities:

• Employee Relations: Serve as a primary point of contact for employees to address concerns, resolve issues, and offer guidance on HR policies and procedures.
• Employee Onboarding: Oversee the complete onboarding process and ensure proper documentation for new employees.
• Performance Management: Assist with the performance review process, offering feedback and supporting the development of improvement plans.
• Employee Offboarding: Manage the entire process for voluntary and involuntary exits, ensuring smooth transitions.
• Internal Transfers and Conversions: Handle full-time conversions and internal transfers for employees.
• Employee Engagement: Support initiatives designed to boost employee morale, including organizing events, conducting surveys, and facilitating team-building activities.
• HR Administration: Maintain accurate employee records, monitor attendance, track leave balances, and ensure compliance with internal procedures.
• Conflict Resolution: Aid in resolving conflicts and fostering effective communication between employees and management.
• HR Reporting: Produce HR-related reports to track employee performance, engagement, and other critical metrics for management.
• HR Policy Implementation: Ensure compliance with company policies and communicate updates effectively to employees.

Qualifications:

• Bachelor’s or Master's degree in Human Resources, Business Administration, or a related field.
• Strong communication and interpersonal skills.
• Ability to manage multiple priorities in a fast-paced environment.
• Knowledge of labour laws and HR best practices.
• Strong problem-solving skills and a proactive approach to employee management.

Desirable Skills:

• Experience with employee engagement initiatives and programs.
• Ability to work collaboratively and build strong relationships across teams.
• Knowledge of talent management and organisational development strategies.

Key Competencies:

• Leadership
• Problem-Solving
• Teamwork
• Adaptability
• Emotional Intelligence

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.

Job Details:

• Job Type: Full-time opportunity 
• Work Days - 5 days
• Work time: General Shift
• Mode of Employment: Work From Office
• Location: Bangalore

 Job Description For Database Engineer

Job Title: Database Engineer(MySQL)

Company: Mydbops 

About Us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Mydbops takes pride in being a PCI DSS-certified and ISO-certified company, reflecting our unwavering commitment to maintaining the highest standards of security and operational excellence.

Role Overview:

You will work in a fast-paced environment where we are responsible for the most critical systems. Our external teams ( Customers ) count on us to keep their MySQL database running and we are vital to the success of their business. You will troubleshoot and resolve customer issues related to the DB system's availability and performance.  You will develop relationships with customers, comprehend and fulfil their needs, and maintain their satisfaction through regular communication and engagement with their environments.

Responsibility :

• The major focus is on handling all the alerts in MDS MySQL.
• Optimising the complex SQL Queries.
• On-Demand Query Optimization.
• Monthly Query optimization assigned ( based on customer list ).
• Get into Client calls on Performance issues and other tasks.
• Reaching the DBE-2 and DBRE's for escalations.
• Assisting and mentoring the ADBEs.
• Efficient troubleshooting using MySQL MDS Internal tools 
• Writing the technical and process documents.
• Managing the client-based operations documents to ease scheduled & repeated tasks for the database engineering team.

Skills Required :

• Teamwork in a fast-paced environment.
• Alarm resolution expert
• Good in SQL language.
• Linux commands for day-to-day operations.
• Kernel tuning and Linux performance tools
• Expertise in MySQL backup tools
• mysqldump
• mydumper/myloader
• Xtrabackup.
• mariabackup
• Knowledge on AWS basic operations
• log collections
• S3 Push
• AWS Workspace
• Deep Skills in query optimization, index tuning and implementing the database features for SQL optimisation.
• Polite, friendly and professional; this position requires significant customer interaction and teamwork.
• Process-oriented and teamwork play a pivotal role.
• Excellent and strong written and spoken English Communication Skills.
• Strong work ethic and accepts feedback from others.
• Strong understanding of MySQL architecture, storage engines (InnoDB, MyISAM), and replication (Binlog Based And  GTID).
• Good understanding of database security practices (users, roles, encryption, authentication mechanisms).
• Strong problem-solving and troubleshooting skills.
• Experience with monitoring tools such as PMM (Percona Monitoring and Management), Prometheus, Grafana

Good to Have (Optional but Preferred): Experience with AWS RDS/Aurora MySQL.

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 opportunity 
• Work Days - 6 days
• Work time: Rotational shift
• Mode of Employment - Work From Home

Job Description for Senior Frontend Engineer

Job Title: Senior Frontend Engineer

Company: Mydbops

Job Overview:

We’re building an agentic AI database platform where intelligent automation meets intuitive design. Join our small, execution-focused development team powered by deep database expertise as we redefine how teams monitor and optimize database performance.

About Mydbops

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 9+ 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:

You'll architect and build our frontend from the ground up, crafting a modern, production-ready agentic AI application that makes complex database insights clear, accessible, and actionable. In this high-impact role, your technical decisions will shape how our platform scales and evolves.

What You'll Own

• Design and implement the entire frontend architecture using modern technologies
• Build responsive, performant UIs that handle real-time data and complex user workflows
• Collaborate closely with backend and AI teams to define system boundaries, advocate for optimal data flows, and craft experiences that make AI accessible
• Establish engineering standards for testing, CI/CD, and code quality
• Balance technical excellence with product intuition and a deep focus on user experience

What We're Looking For

Core Requirements:

• 3 to 5 Years building production frontends with proven performance, security, and architectural ownership
• Strong proficiency in React, TypeScript, and modern component-based architecture
• Deep knowledge of authentication, RBAC, session management, and frontend security best practices
• Experience with state management (e.g., Redux, Zustand) and integrating complex or real-time APIs
• Strong design intuition with exposure to design systems, responsive UX, and accessibility standards
• Experience building real-time UIs, data visualizations, or telemetry dashboards
• Familiarity with data visualization libraries like Recharts, D3, Chart.js, or similar open-source solutions
• A track record of clean, maintainable code and a proactive ownership mindset

Culture Fit

We value execution over meetings, ownership over hand-holding, and long-term thinking over quick fixes. We're looking for someone who:

• Takes initiative and drives projects to completion independently
• Writes clean, maintainable code with testing in mind
• Cares equally about performance, security, and user experience
• Balances technical debt with product velocity and user impact

This role likely isn't a fit if:

• You need daily task breakdowns to make progress
• You haven't built and shipped production-grade applications end-to-end
• You avoid dealing with performance, authentication, or architecture
• You prefer polishing UI components over solving deep product problems

Ready to help build intelligent database performance tools? We'd love to hear from you.

Job Details:

• Job Type: Full-time opportunity 
• Work time: General Shift
• Mode of Employment - Hybrid (Chennai Location)
• Experience - 3 to 5 years

Job Description for Associate Database Engineer

Job Title: Associate Database Engineer

Company: Mydbops

About us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Our Customer Account Management team is vital in ensuring client satisfaction and loyalty.

Role Overview:

We are seeking an enthusiastic and skilled Associate Database Engineer to join our growing team. This role focuses on cloud-based MySQL solutions and requires hands-on experience in managing, securing, and optimising relational databases in leading cloud platforms such as AWS and Google Cloud.

The ideal candidate will have a passion for automation, cost optimisation, and cloud-native database best practices.

Key Responsibilities:

• Manage and optimise MySQL databases in cloud environments, including AWS RDS for MySQL, Amazon Aurora, and Google Cloud SQL for MySQL.
• Implement and enhance security measures for cloud database services (DBaaS), including encryption, IAM integration, and network controls.
• Execute cloud operations efficiently using AWS CLI and other automation tools.
• Design and implement cloud backup solutions, ensuring reliability, compliance, and recovery readiness.
• Lead and support database migrations and cutover activities with minimal downtime
• Apply best practices in cost optimisation across various cloud MySQL services, balancing performance and budget.
• Proactively identify opportunities for automation in routine cloud database tasks and processes.
• Demonstrate innovative thinking with a continuous improvement mindset for database operations and cloud solutions.
• Management of Cloud infrastructure using Terraform.
• 
  

Required Skills:

• Solid knowledge of MySQL on AWS and GCP cloud platforms
• Understanding of cloud DBaaS security enhancements (e.g., encryption at rest/in transit, IAM, VPC peering)
• Proficiency with AWS CLI for managing database resources and services
• Experience in cloud backup strategies and disaster recovery planning
• Hands-on experience with migration and cutover techniques in cloud databases (ex: Blue green deployment, DMS)
• Familiarity with cost optimisation approaches for cloud-based MySQL deployments
• Strong inclination towards automation and scripting in cloud environments
• Creative problem-solver with a focus on innovation and operational efficiency

Preferred Qualifications:

• AWS Certification (e.g., AWS Certified Database – Speciality) is a strong plus
• Exposure to additional cloud platforms like Azure Database for MySQL is an advantage

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.

Job Details:

• Work time: General shift
• Mode of Employment - Work From Home
• Experience - 1 to 2 years

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:

• 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

Job Description For Associate Database Engineer (PostgreSQL)

Job Title: Associate Database Engineer (PostgreSQL)

Company: Mydbops

About us:

As a seasoned industry leader for 8 years in open-source database management, we specialize in providing

unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At

Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers.

Mydbops takes pride in being a PCI DSS-certified and ISO-certified company, reflecting our unwavering

commitment to maintaining the highest security and operational excellence standards.

Position Overview:

An Associate Database Engineer is responsible for the administration and monitoring of database systems and is

available to work in shifts.

Responsibilities

● Managing and maintaining various customer database environments.

● Monitoring proactively database performance using internal tools and metrics.

● Implementing backup and recovery procedures.

● Ensuring data security and integrity.

● Troubleshooting database issues with a focus on internal diagnostics.

● Assisting with capacity planning and system upgrades.

● This role requires a solid understanding of database management systems, proficiency in using internal tools for performance monitoring, and flexibility to work in various shifts to ensure continuous database support.

Requirements

● Good knowledge of Linux OS and its tools

● Strong expertise in PostgreSQL database administration

● Proficient in SQL and any programming languages (Python, bash)

● Hands-on experience with database backups, recovery, upgrades, replication and clustering

● Troubleshooting of database issues

● Familiarity with Cloud (AWS/GCP)

● Working knowledge of AWS RDS, Aurora, CloudSQL

● Strong communication skills

● Ability to work effectively in a team environment

Preferred Qualifications:

● B.Tech/M.Tech or any equivalent degree

● Deeper understanding of databases and Linux troubleshooting

● Working knowledge of upgrades and availability solutions

● Working knowledge of backup tools like pg backrest/barman

● Good knowledge of query optimisation and index types

● Experience with database monitoring and management tools.

● Certifications on PostgreSQL or related technologies are a plus

● Prior experience in customer support or technical operations

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 Mode: Work From Home

● Experience: 1-3 years