PostgreSQL DBA

Role Summary

We are seeking an experienced PostgreSQL Database Expert to provide enterprise-grade PostgreSQL administration, support, performance tuning, and database reliability services. The individual will be responsible for ensuring the availability, performance, security, and scalability of mission-critical PostgreSQL environments while supporting production, non-production, and disaster recovery systems.

Database Administration & Support

• Administer and maintain PostgreSQL databases across Production, UAT, QA, and Development environments.
• Monitor database health, performance, capacity, and availability.
• Perform proactive issue identification and resolution.
• Manage database upgrades, patching, and version migrations.
• Implement and maintain backup, recovery, and archival strategies.

Performance Optimization

• Analyze SQL queries and execution plans.
• Perform database performance tuning and optimization.
• Optimize indexing strategies, partitioning, and database design.
• Identify and resolve database bottlenecks.

High Availability & Disaster Recovery

• Design and support PostgreSQL HA solutions.
• Configure and maintain replication environments.
• Support failover and disaster recovery testing.
• Ensure RPO/RTO objectives are met.

Security & Compliance

• Configure database security controls and access management.
• Implement role-based access controls.
• Support audit, compliance, and vulnerability remediation activities.
• Manage encryption and data protection requirements.

Incident & Problem Management

• Provide L2/L3 production support.
• Troubleshoot critical database incidents.
• Perform root cause analysis (RCA) and implement preventive measures.
• Participate in on-call support and major incident management.

Automation & DevOps

• Develop automation scripts for monitoring, deployment, backup, and maintenance activities.
• Support Infrastructure-as-Code and CI/CD initiatives where applicable.
• Integrate PostgreSQL monitoring with enterprise observability platforms.

Experience

• 10+ years of database administration experience.
• 6+ years of hands-on PostgreSQL administration experience.
• HA/DR, performance tuning, and PostgreSQL migration expertise.
• Strong knowledge of:

Skills

• PostgreSQL Architecture
• WAL, Replication & Streaming Replication
• Backup & Recovery
• Performance Tuning
• Partitioning & Indexing
• PostgreSQL Security
• Query Optimization

Experience with

• pgAdmin
• pgBackRest / Barman
• Patroni / RepMgr
• Linux Administration
• Shell/Python Scripting
• Monitoring tools (Grafana, Prometheus, Datadog, Splunk, etc.)

Preferred Skills

• PostgreSQL on AWS, Azure, or Google Cloud Platform.
• PostgreSQL migration from Oracle, SQL Server, DB2, or other RDBMS platforms.
• Experience supporting large-scale banking or financial services environments.
• Knowledge of Kubernetes/OpenShift-hosted PostgreSQL deployments.
• Exposure to enterprise data governance and regulatory compliance requirements.

Experience Level

• Lead PostgreSQL DBA / PostgreSQL Support Lead
• 10-15+ years overall IT experience
• 6+ years dedicated PostgreSQL experience