What are the responsibilities and job description for the PostgreSQL DBA position at Yochana?
Role: PostgreSQL DBA - Level 3
Location: Dallas, TX & Atlanta, GA (Onsite)
Position Type: Fulltime
Skills & Experience
- Expert hands‑on experience with PostgreSQL in large‑scale, mission‑critical production environments.
- Strong expertise in PostgreSQL backup, restore, and recovery strategies.
- Deep understanding of PostgreSQL High Availability and Disaster Recovery architectures, owned and executed within L2/L3 operations.
- Advanced performance tuning skills, including query optimization, indexing strategies, vacuum/analyze tuning, locking analysis, and capacity planning.
- Strong experience with PostgreSQL security features, including role‑based access, auditing, encryption, and vulnerability remediation.
- Proven experience operating in a 24x7, SLA‑driven managed services environment.
- Hands‑on ownership of Sev‑1 / Sev‑2 incidents, problem management, RCA creation, and CAP execution.
- Solid understanding of ITIL processes (Incident, Problem, Change, Request Management).
- Experience supporting regulated enterprise environments, including audits and compliance evidence generation.
- Ability to identify and drive automation opportunities using approved scripting and workflow tools.
- Strong analytical, communication, and mentoring skills with the ability to guide L2 teams under high‑pressure situations
Recommended Certifications
- PostgreSQL Professional Certification
- Windows 2019/22/ Redhat Linux 8.x/9.x
- ITIL V4