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)

: 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

- Robust 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
- LinkedIn
- Instagram
- YouTube
- Twitter
- Facebook
- Quora
- Pinterest

Ready to ensure your compliance? Get in touch For data protection inquiries, contact our DPO at: [email protected]

DPDP Consultants (Privacyium Tech Pvt. Ltd.)

0120-6930999, 1800-5711333

[email protected] [email protected] [email protected]

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 : [email protected]

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

📌 PostgreSQL Database Administrator (On-Premise, Multi–Data Center Replication) (Noida)
🏢 DPDP Consultants
📍 Noida