JOBSEARCHER

Lead PostgreSQL DBA / PostgreSQL Support Lead

Job Description: Detailed JD: please find below
Sell Rate: $65-68/hour or 130K
Client Full Address: 300 Fifth Avenue, Pittsburgh, PA 15222.
Remote / WFO / Hybrid: Remote is OK Hire Type (FTE/Contract): FTE preferable, Contract is OK
Project Duration: 1 year
Expected Start Date: Immediate Day 1 Billing Confirmation: Yes No. of client interviews for this role: 1-2 rounds
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.
Key Responsibilities: 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.
Required Skills: 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: 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 GCP. 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