Senior Database Administrator

Company: Mydbops

Website: Visit Website

Business Type: Enterprise

Company Type: Service

Business Model: B2B

Funding Stage: Bootstrapped

Industry: Information Technology

Salary Range: ₹ 20-25 Lacs PA

Job Description

Company Overview:

MyDBOPS is a specialized database consulting and managed services company focused on open-source technologies such as MySQL, PostgreSQL, MongoDB, MariaDB, TiDB, and Cassandra. Since 2015, we have partnered with fast-growing startups, enterprises, and unicorns to ensure high performance, scalability, and reliability for mission-critical database environments.

Trusted by 800+ clients, including 30+ unicorns, we power over 10 billion transactions daily across industries such as fintech, SaaS, healthcare, logistics, and e-commerce. Our team brings 9+ years of deep domain expertise, delivering automation solutions, leading complex migrations, and resolving high-impact database and performance challenges.As an ISO and PCI-DSS certified organization, we combine engineering excellence with enterprise-grade security, compliance, and operational reliability.

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, PMRM, 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
  
  

• 4–5 years of PostgreSQL administration experience
• Minimum 2+ years in a technical leadership or senior role
  
  

• Advanced query tuning, indexing strategies, partitioning
• Execution plan analysis and workload optimization
  
  

• 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
  
  

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

• Proven expertise in configuring and managing HA environments using Patroni, repmgr, and streaming replication.
  
  

• Operational knowledge of AWS RDS and Aurora PostgreSQL
• Parameter tuning, snapshot management, and performance insights
  
  

• PMM, Nagios, Grafana, Prometheus
• Building custom monitoring dashboards
  
  

• Linux system administration
• Advanced scripting with Bash and Python
  
  

• Strong problem-solving skills and effective communication with stakeholders
• Experience leading database reliability, automation, and mentoring initiatives
  
  

• 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
  
  

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