Lead PostgreSQL DBA

e-IT; United States; On-site; USD 150,000 - 230,000; Full time

Job summary

e-IT seeks an experienced PostgreSQL Database Expert to deliver enterprise-grade PostgreSQL administration, support, performance tuning, and reliability services. You will ensure availability, performance, security, and scalability for mission-critical PostgreSQL environments across production, non-production, and disaster recovery systems.

Responsibilities include administering across Production, UAT, QA, and Development; monitoring health and performance; backups, upgrades, replication,

Qualifications

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

Responsibilities

• Administer PostgreSQL databases across production and non-production environments.
• Monitor health, performance, capacity, and availability.
• Manage upgrades, patching, and version migrations.
• Design and support high availability and disaster recovery solutions.
• Configure security controls and access management.
• Provide on-call support and incident response.

Skills

Database administration

PostgreSQL

HA/DR

Performance tuning

Replication

Security controls

Scripting

Monitoring

CI/CD

Cloud platforms

Tools

pgAdmin

pgBackRest

Barman

Shell/Python scripting

Observability tools (Grafana, Prometheus)

Job description

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:
• WAL, Replication & Streaming Replication
• Backup & Recovery
• Performance Tuning
• Query Optimization
• Experience with:
• pgAdmin
• pgBackRest / Barman
• 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

• 10-15+ years overall IT experience
• 6+ years dedicated PostgreSQL experience