Postgresql Database Administrator (Chennai)

Postgresql Database Administrator (Chennai)

20 Nov
|
Bahwan Cybertek
|
Chennai

20 Nov

Bahwan Cybertek

Chennai

PostgreSQL Architecture & Design

- Design and maintain scalable, faulttolerant PostgreSQL architectures aligned with Fareportals business and growth strategy
- Define standards for PostgreSQL cluster design, configuration, versioning, and lifecycle management
- Architect and operate highavailability PostgreSQL environments using Patroni with distributed consensus systems (etcd / Consul)
- Lead PostgreSQL upgrades, migrations, and platform modernization initiatives with minimal downtime
- Evaluate and implement PostgreSQL extensions, features, and best practices suitable for largescale production workloads

Operations & Production Support (Primary Focus)

- Own the daytoday operational health of PostgreSQL platforms across production and nonproduction environments
- Lead major incident response, including failovers, performance degradation, replication issues, and data consistency problems
- Perform deep rootcause analysis (RCA) and drive longterm corrective and preventive actions
- Tune PostgreSQL for performance and stability, including:
- Memory and storage optimization
- WAL and checkpoint tuning
- Autovacuum and bloat management
- Query optimization and execution plan analysis

- Manage and validate backup, restore, and pointintime recovery strategies (pgBackRest, Barman, or equivalent)
- Act as a senior escalation point during oncall rotations and highseverity production events

Patroni & High Availability

- Design, configure,



and operate Patronibased PostgreSQL clusters in production
- Troubleshoot and resolve complex HA scenarios such as:
- Leader election failures
- Splitbrain conditions
- Network partitions and fencing issues

- Define and tune HA behavior (failover, switchover, synchronous replication settings)
- Establish safe maintenance, patching, and upgrade procedures for HA environments

Automation, Monitoring & Reliability

- Drive automation initiatives for PostgreSQL provisioning, configuration, patching, and deployments
- Implement proactive monitoring and alerting for performance, replication, capacity, and availability
- Partner with SRE and infrastructure teams to improve platform reliability, alert quality, and operational tooling
- Develop and maintain operational documentation, runbooks, and standard operating procedures

CrossDatabase Expertise (Desired)

- Provide architectural and operational guidance for MySQL platforms where applicable
- Troubleshoot MySQL performance, replication, and availability issues
- Support coexistence or migration strategies between PostgreSQL and MySQL environments

Infrastructure & Tooling

- Robust Linux fundamentals
- Experience with cloud or hybrid environments (AWS / Azure / GCP)
- Familiarity with monitoring tools (Prometheus, Grafana, Datadog, etc.)
- Scripting skills in Bash, Python, or similar

📌 Postgresql Database Administrator (Chennai)
🏢 Bahwan Cybertek
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: postgresql database administrator (chennai) / chennai