Lead PostgreSQL DBA / PostgreSQL Support
PeopleNTech· enterprise· Information Technology And Services· Oct 22, 2026 · 6d ago
Santa Clara, CA
Remote
Full-time
Lead/Staff
$75–$78/hr
Job description
Indent id - SF_OP_210129-2
Sell Rate: $75-78/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
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
Application prep
Use the role’s language and application details while tailoring your materials.
Keywords to mirror
sqlci/cdpythonawsazuregcpkubernetes
- Platform
- jobdiva
- Effort
- medium