Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in noida
>
Dpdp Consultants
>
PostgreSQL Database Administrator

PostgreSQL Database Administrator

Dpdp Consultants

5 - 8 years

8 - 12 Lacs

noida

Posted:1 day ago| Platform:

Apply

Skills Required

zabbix linux networking conflict resolution postgresql disaster recovery data integrity database administrator python firewall

Work Mode

Work from Office

Job Type

Full Time

Job Description

We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage and maintain our on-premise PostgreSQL infrastructure deployed across multiple data centers. The DBA will be responsible for implementing, monitoring, and optimizing logical replication between data centers, ensuring high availability, data integrity, and automatic recovery in case of network or hardware failures.

The role involves working on a one-master-at-a-time replication model, ensuring seamless master rotation every six months, and maintaining synchronization between the data centers even during internet or network interruptions.

Key Responsibilities:

Design, configure, and maintain PostgreSQL databases for high availability and performance across multiple on-premise data centers.
Implement and manage logical replication with one master node active at a time.
Ensure replication auto-start and auto-sync in case of network or connectivity disruptions.
Plan and execute scheduled master rotations (every six months) between data centers with minimal downtime.
Continuously monitor database health, replication status, and performance metrics.
Develop and maintain scripts for automated failover, recovery, and sync resumption after outages.
Perform backup and restore operations ensuring data consistency across environments.
Optimize database performance through indexing, query tuning, and partitioning strategies.
Collaborate with DevOps, Networking, and Application teams to ensure database reliability and security.

Required Skills & Qualifications

Strong hands-on experience (5+ years) administering PostgreSQL (v12 or higher) in production environments.
Proven expertise in setting up and managing logical replication, streaming replication, and high-availability clusters.
Experience with multi data center replication and failover/fallback mechanisms.
Proficient in designing auto-start and auto-sync replication scripts (using Bash, Python, or Ansible).
Understanding of network routing, firewall, and latency optimization for database replication across sites.
Experience with PgBouncer, Patroni, or repmgr for HA management.
Solid understanding of backup and disaster recovery strategies.
Familiarity with monitoring tools (Prometheus, Grafana, pgAdmin, Zabbix, or similar).
Strong problem-solving and analytical skills, with a focus on reliability and fault tolerance.

Preferred Qualifications

Certification in PostgreSQL Administration or Linux Systems.
Experience with Docker-based PostgreSQL deployments.
Prior work with Python Flask or web applications connecting to PostgreSQL backends.
Knowledge of PostgreSQL replication conflict resolution and logical decoding.

Key Environment Details

Deployment Model: On-Premise
Data Centers: DC1, DC2 (active replication)
Replication Type: Logical (one master active)
Failover Behavior: Auto start on network recovery, auto sync after downtime
Master Rotation: Scheduled every 6 months

More Jobs at Dpdp Consultants

React Native Senior Developer

Noida

6 - 8 yrs

INR 8 - 10 Lacs

React Native Software Engineer

Noida

3 - 5 yrs

INR 5 - 7 Lacs

React.js Senior Web Application Developer

Noida

6.0 - 8.0 yrs

INR 5 - 9 Lacs

React.js Web Application Developer

Noida

3.0 - 5.0 yrs

INR 3 - 7 Lacs

Senior Python Engineer

Noida

4.0 - 8.0 yrs

INR 6 - 10 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Dpdp Consultants

Login to

Please Verify Your Phone or Email

Confirm Action

PostgreSQL Database Administrator