Database Administrator - Postgresql

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

Experience required - 3 year(minimum) in MERN Stack

Salary - 15-20 LPA

About the Company

The company is one of the fastest-growing B2B SAAS Marketplace to procure industrial materials. The startup is generating an Annual Revenue of Rs. 100 Crore. You will get to work in a fast-paced environment with a brilliant agile tech team led by top engineers.

Location: Pune, 3 months Remote then Work from Office or Hybrid Working

Qualifications & Criteria

1. 3+ Years of development experience in the full-stack development (preferred MERN technology stack). Should be proficient in working with technologies like JavaScript, CSS, and JS with frameworks like NodeJs and ReactJS.

2. Should have good knowledge of databases like Linux.

3. As part of the brains of the startup, You are smart, creative, and love solving business challenges and thereby find new ways to propel the growth of the company.

4. You are passionate about the growth and want to become a future technical leader within the company. Your work and attitude should reflect your commitment for the same.

Responsibilities:

1. Should be able to work independently once proper guidance is provided.

2. Knowledge of professional software engineering practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations

3. Ensure timely completion of development activity.

4. Prepare training documents and provide training to internal teams on tools.

5. Consult, design, and develop well-structured, scalable in-house tools.

6. Should be able to write optimized business logic for business functions

• NoSQL DB (MongoDB, CouchDB), PostgreSQL
• Mocha test environment
• Should JS testing framework
• Experience implementing mock services
• Nock API mocking
• NPM, Redis
• Typescript / Coffee script experience will be an added advantage
• Experience working with opensource JS projects
• Experience in developing REST API
• Source code management tool - Git / GitHub
• Understanding of TCP/IP networking and client/server web programming model
• Good communication skills
• Should be able to work with the cross-geo client team