PostgreSQL Database Architect

Join to apply for the Postgre

SQL Database Architect role at Collabera

1 day ago Be among the first 25 applicants

Join to apply for the Postgre

SQL Database Architect role at Collabera

This range is provided by Collabera. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

$68.00/hr - $72.00/hr

Direct message the job poster from Collabera

Job Title:
Postgre

SQL Database Architect
Location:
Plano, TX / Chandler, AZ / Charlotte, NC
Job Type: 12-Month Contract
Pay Range: $68 - $72 per hour
Interview Process: 2 Rounds

Job Summary :
We are seeking a highly skilled Postgre

SQL 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 Postgre

SQL 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 Postgre
  
  SQL 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 Postgre
  
  SQL 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.

Required Skills & Qualifications:

• 7+ years of hands-on experience in Postgre
  
  SQL database administration in a 24x7 production environment.
• Strong understanding of Postgre
  
  SQL HA/replication, failover mechanisms, and performance tuning.
• Expertise in Unix/Linux system administration and shell scripting.
  Proficiency with pgBackRest for Postgre
  
  SQL backups and recovery.
• Experience managing Postgre
  
  SQL in Kubernetes/Open Shift environments.
• Strong scripting skills in Shell or Python.
• Familiarity with Ansible for infrastructure automation.
• Understanding of monitoring tools and log analysis (e.g., Splunk).
• Experience with Kafka and cron-based job scheduling is a plus.
• Strong problem-solving skills with the ability to manage complex production issues effectively.
• Excellent communication and documentation skills.

• Seniority level
  
  Mid-Senior level

• Employment type
  
  Contract

• Job function
  
  Information Technology

Referrals increase your chances of interviewing at Collabera by 2x

Irving, TX $-$ 1 month ago

Plano, TX $-$ 1 month ago

Dallas, TX $-$ 1 month ago

Dallas, TX $-$ 2 weeks ago

Plano, TX $-$ 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.