NOIDA · FULLTIME
PostgreSQL Database Administrator (On-Premise, Multi–Data Center Replication)
DPDP Consultants
Noida · onsite · Posted 5d ago
Your match
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
Principal Rights 18005711333 Contact Us
- About us + Who we are + Mission and Vision + Our Team + What we do + Awards & Certifications
- DPDP Act 2023 + Draft DPDP Rules 2025 + Administrative Fines And Penalties + Subcontractor And Third Party Issues + DPDPA And Business Discontiniuity + Case Study
- Compliance-Tools + Data Principal Consent Management + Data Principal Grievance Redressal + Data Protection Awareness Program + Data Protection Impact Assessment + Data Protection Third Party Assessment + Cookie Consent Management
- Services + Gap assessment review + Data Protection Officer as a Service + Contract Review & Data Processing Agreements + Consulting, Advisory and Audit + Training Programs for DPDPA Compliance
- Resources + Blogs + Whitepapers + Newsletters + Research Reports + In the News + Webinars + Upcoming Events
- Career + Join our Team + DPDP Act Foundation Course
- Partner with us Principal Rights 18005711333 Who we are Mission and Vision Our Team What we do Awards & Certifications Draft DPDP Rules 2025 Administrative Fines And Penalties Subcontractor And Third Party Issues DPDPA And Business Discontiniuity Case Study Data Principal Consent Management Data Principal Grievance Redressal Data Protection Awareness Program Data Protection Impact Assessment Data Protection Third Party Assessment Gap assessment review Data Protection Officer as a Service Contract Review & Data Processing Agreements Consulting, Advisory and Audit Training Programs for DPDPA Compliance Blogs Whitepapers Newsletters Reasearch Reports In the News Webinars Upcoming Events Join our Team DPDP Act Foundation Course Contact Us Comprehensive Grievance Redressal for Compliance, Accountability, and User Confidence Our solution streamlines grievance redressal while upholding compliance, transparency, and user satisfaction. Current Openings PostgreSQL Database Administrator (On-Premise, Multi–Data Center Replication) 1 Open Role
Team: Product
Location: Noida
Work Schedule: Full-Time / Contract
Work Mode: On-site
Experience: 3 to 5+ years (PostgreSQL Administration & Replication)
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 Useful links
- Home
- About us
- Compliance Tools
- Services
- Why us?
- Our Team
- FAQs
- Privacy Notice Documentation
- Blogs
- Newsletters
- Whitepapers
- Research Reports
- In the news
- Webinars
- Upcoming Events Social
- YouTube
- Quora
- Pinterest Ready to ensure your compliance? Get in touch For data protection inquiries, contact our DPO at: dpo@dpdpconsultants.com DPDP Consultants (Privacyium Tech Pvt. Ltd.) 0120-6930999, 1800-5711333 info@dpdpconsultants.com career@dpdpconsultants.com partners@dpdpconsultants.com GM IT Park, 4th Floor, Plot no 32-33, Sector 142, Noida 201305, Uttar Pradesh SJR Equinox, Velankanni Drive. Electronic City Phase 1, Bangalore, PIN code 560100 B451, Orchid Corporate Park, Royal Palms, Aarey Colony, Goregaon East, Mumbai, PIN code 400065 Mon - Fri
9:00 am to 6:00 pm Sunday Appointment only Copyright ©2026 DPDP Consultants (Privacyium Tech Pvt. Ltd.) - All Rights Reserved.
🍪 Cookie Preferences We use cookies to personalize content and analyze traffic.Choose what to allow. Essential Cookies These cookies are necessary for the website to function and cannot be switched off. They help with navigation, security, and user preferences. Name Domain Platform Provider Expiration Description/Purpose _dp_curr_ demdex.net Adobe Audience Manager Adobe 89 days Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dp_just_ demdex.net Adobe Audience Manager Adobe 59 minutes Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dp_gang_ demdex.net Adobe Audience Manager Adobe 29 days Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dp_thum_ demdex.net Adobe Audience Manager Adobe 9 days Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dp_user_ demdex.net Adobe Audience Manager Adobe 23 hours Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html PHPSESSID PHP.net PHP.net Cookie generated by applications based on the PHP language. This is a general purpose identifier used to maintain user session variables. It is normally a random generated number, how it is used can be specific to the site, but a good example is maintaining a logged-in status for a user between pages.
Privacy Link: https://www.php.net/privacy.php _dpc_uid_ demdex.net Adobe Audience Manager Adobe 364 days Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html Analytics Cookies These cookies help us understand how visitors interact with our website by collecting anonymous data. They allow us to improve site functionality and user experience. Name Domain Platform Provider Expiration Description/Purpose _ga_SRHQK2GY9G Google Analytics Google 399 days ID used to identify users
Privacy Link: https://business.safety.google/privacy/ _ga Google Analytics Google Analytics 399 days ID used to identify users
Privacy Link: https://business.safety.google/privacy/ _ga_7RLH0S8S6T Google Analytics Google 399 days ID used to identify users
Privacy Link: https://business.safety.google/privacy/ Targeting Cookies These cookies are used to deliver ads that are relevant to users based on their browsing history and interactions. Name Domain Platform Provider Expiration Description/Purpose _fbp facebook.com Facebook Facebook 89 days Used by Facebook to deliver a series of advertisement products such as real time bidding from third party advertisers
Privacy Link: https://www.facebook.com/about/privacy/ _gcl_au Google Google 89 days Used by Google AdSense for experimenting with advertisement efficiency across websites using their services.
Privacy Link: https://business.safety.google/privacy/ li_sugr LinkedIn LinkedIn 89 days Used to make a probabilistic match of a user's identity outside the Designated Countries
Privacy Link: https://www.linkedin.com/legal/privacy\-policy bscookie linkedin.com LinkedIn LinkedIn 364 days Used by LinkedIn to track the use of embedded services.
Privacy Link: https://www.linkedin.com/legal/privacy\-policy _dp_curr_ demdex.net Adobe Audience Manager Adobe 89 days Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dp_just_ demdex.net Adobe Audience Manager Adobe 59 minutes Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dp_gang_ demdex.net Adobe Audience Manager Adobe 29 days Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dp_thum_ demdex.net Adobe Audience Manager Adobe 9 days Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dpc_uid_ demdex.net Adobe Audience Manager Adobe 364 days Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html _dp_user_ demdex.net Adobe Audience Manager Adobe 23 hours Used to determine if browser of user accepts cookies or not
Privacy Link: https://www.adobe.com/nl/privacy.html Functional Cookies These cookies allow the website to remember choices you make and provide enhanced functionality, such as saving user preferences or chat support. Name Domain Platform Provider Expiration Description/Purpose test_cookie Salesforce Salesforce 14 minutes Used to avoid duplicate access checks.
Privacy Link: https://www.salesforce.com/company/privacy/ PHPSESSID PHP.net PHP.net Cookie generated by applications based on the PHP language. This is a general purpose identifier used to maintain user session variables. It is normally a random generated number, how it is used can be specific to the site, but a good example is maintaining a logged-in status for a user between pages.
Privacy Link: https://www.php.net/privacy.php Data Protection Officer Email : dpo@dpdpconsultants.com Phone : 0120-6930999, 1800-5711333 Address : GM IT Park, 4th Floor, Plot no 32-33, Sector 142, Noida 201305, Uttar Pradesh
- Principal Rights
- Privacy Policy
Sourced from linkedin · view original
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02