Postgres Administrator (PostgreSQL, Postgres Architecture, Cluster Management, Galera)

Responsibilities:

• Design, implement, and manage PostgreSQL clusters (v9.6 to v16.x) using tools such as repmgr, Pgpool-II, Patroni, or HAProxy.
• Manage MySQL/MariaDB clusters using Galera, NDB, and GTID-based replication setups.
• Set up and maintain synchronous/asynchronous replication,logical replication, and physical streaming.
• Perform tuning, troubleshooting, and capacity planning using tools like pg_stat_statements, pgBadger, pg_profile, and EXPLAIN PLAN.
• Implement and manage backup/recovery strategies using pg_basebackup, pg_dump, BARMAN, and BART.
• Lead the automation of PostgreSQL cluster health checks,alerting, and scaling using Shell scripting or Ansible.
• Monitor database health and availability using PEM, OpsCenter,and cron-based checks.
• Handle table bloat analysis, VACUUM planning, memory tuning (shared_buffers, work_mem, etc.), and schema optimization.
• Administer Oracle RAC databases with ASM and Oracle Data Guard for DR.
• Support MongoDB Replica Sets, Cassandra (DataStax), and TimesTen as part of a distributed NoSQL architecture.
• Ensure secure role-based access, patching, and compliance across RDBMS and NoSQL environments.
• Perform end-to-end lifecycle support including installation,patching, upgrade, cloning, schema refreshes, and decommissioning.
• Participate in DR drills, change requests, audits, and incident response for business continuity.
• Automate backup, monitoring, and reporting tasks using scripting tools (Shell/Ansible).

Requirements:

• Minimum 7 years of hands-on Postgres DBA experience,with at least 5 years of experience in Postgres L3 Support and 2 years in Postgres architecture.
• PostgreSQL expert with hands-on experience in clustering, replication, and performance tuning.
• Familiar with enterprise use of Repmgr, Pgpool-II, HAProxy,Patroni, or equivalent.
• Working knowledge of other RDBMS such as Oracle (RAC/Data Guard), MySQL, Galera, NDB), and MSSQL
• Familiarity with ITIL/ITSM processes and change management protocols.
• Certifications in Postgres strongly preferred
• Strong understanding of database internals, query planning, and database architecture.
• Competence in scripting (Bash, Ansible) for automation and operations support.
• Experience with database monitoring tools such as Nagios, OEM,PEM, OpsCenter, HPOBM.