PostgreSQL DBA
Ritik SinghalRemoteSENIORPosted 13d ago
PostgreSQLWALStreaming ReplicationBackupRecoveryHA/DRPatroniRepMgrpgBackRestBarmanpgAdminPerformance TuningSQL OptimizationIndexingPartitioningLinux AdministrationShellPythonGrafanaPrometheusDatadogSplunk
About the Role
We are looking for an experienced PostgreSQL DBA to manage enterprise-grade PostgreSQL environments and ensure high availability, performance, security, and reliability across mission-critical systems.
Key Responsibilities
• Administer PostgreSQL databases across Production, UAT, QA, and Development environments
• Lead database performance tuning, query optimization, indexing, and partitioning
• Design and support High Availability (HA), Disaster Recovery (DR), and replication solutions
• Manage PostgreSQL backups, recovery, upgrades, patching, and migrations
• Handle L2/L3 production support, critical incidents, RCA, and preventive actions
• Implement database security, access controls, and compliance requirements
• Automate database operations using Shell/Python scripting
• Monitor database health, performance, and availability using enterprise monitoring tools
Requirements
• PostgreSQL Architecture, WAL, Streaming Replication
• Backup and Recovery
• HA/DR solutions using Patroni / RepMgr
• pgBackRest / Barman, pgAdmin
• Advanced Performance Tuning, SQL Optimization, Indexing & Partitioning
• Linux Administration and Shell/Python Scripting
• Grafana, Prometheus, Datadog, Splunk, or similar monitoring tools
Good to Have
• PostgreSQL on AWS, Azure, or GCP
• Database migrations from Oracle, SQL Server, DB2, or other RDBMS platforms
• Banking / Financial Services domain experience
• Kubernetes / OpenShift and Infrastructure-as-Code exposure.