Join to apply for the PostgreSQL Database Architect role at Collabera
1 day ago Be among the first 25 applicants
Join to apply for the PostgreSQL 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.
Base pay range
$68.00/hr - $72.00/hr
Direct message the job poster from Collabera
Job Title: PostgreSQL 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 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.
Required Skills & Qualifications:
- 7+ years of hands-on experience in PostgreSQL database administration in a 24x7 production environment.
- Strong understanding of PostgreSQL HA/replication, failover mechanisms, and performance tuning.
- Expertise in Unix/Linux system administration and shell scripting.
Proficiency with pgBackRest for PostgreSQL backups and recovery. - Experience managing PostgreSQL in Kubernetes/OpenShift 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
Seniority level
Mid-Senior level
Employment type
Employment type
Contract
Job function
Job function
Information Technology
Referrals increase your chances of interviewing at Collabera by 2x
Sign in to set job alerts for Database Architect roles.
Irving, TX $200,000.00-$230,000.00 1 month ago
Director, Enterprise Architecture Cross Functional Initiatives
Director, ServiceNow Solution Architecture
Plano, TX $154,639.68-$223,368.43 1 month ago
Dallas, TX $154,639.68-$223,368.43 1 month ago
Senior Architect - Data Engineering and Analytics
Dallas, TX $140,000.00-$170,000.00 2 weeks ago
Plano, TX $114,700.00-$192,100.00 2 weeks ago
Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr