PostgreSQL DBA

PostgreSQL DBA

Plano, TX / Dallas, TX - Onsite

12+ Months with possible extension

Contract Type : W2

Requirement: 12+ years hands-on experience supporting PostgreSQL  and Oracle MySQL databases.
This role will be primarily focused on production database administration
for PostgresSQL databases.

Job Summary:
We are seeking a highly skilled PostgreSQL Database Architect to join our team and support the design, development, and management of high-availability (HA) database environments. The ideal candidate will bring extensive experience with PostgreSQL administration in production environments, along with strong scripting and automation capabilities. You will be responsible for ensuring system performance, availability, and disaster recovery readiness.

Key Responsibilities:

• Support and maintain production PostgreSQL database systems with a focus on stability and performance.
• Troubleshoot system issues and conduct root cause analysis for recurring problems.
• Implement proactive monitoring and alerting strategies to ensure uptime and performance
• Architect, implement, and support highly available PostgreSQL database clusters.
• Collaborate with engineering, development, and infrastructure teams on deployment and optimization strategies.
• Develop and maintain automation scripts and Ansible playbooks for database maintenance tasks.
• Plan and execute failovers, database migrations, and backup/recovery processes using pgBackRest.
• Lead incident triage calls and provide on-call support including weekend rotations.
• Ensure business continuity through disaster recovery strategies and periodic testing.
• Create and maintain detailed documentation and operational playbooks.