onsite
PostgreSQL DBA - Zanusys Ltd
Database Administrator
Experienced PostgreSQL DBA responsible for designing, developing, and maintaining high‑performance database solutions, writing complex PL/pgSQL code, optimizing queries, and ensuring security, availability, and disaster recovery.
About the role
Key Responsibilities
- Design, develop, and maintain PostgreSQL database solutions, including scalable schemas and data models.
- Write and optimize complex SQL queries, stored procedures, functions, and triggers using PL/pgSQL.
- Monitor and tune database performance, implementing indexing, partitioning, and query‑restructuring strategies.
- Ensure database security, integrity, and high availability through role‑based access control and regular audits.
- Implement and manage backup, recovery, and disaster‑recovery processes to meet RTO/RPO objectives.
- Troubleshoot and resolve database‑related issues in collaboration with application developers and data engineering teams.
Requirements
- 5–7 years of hands‑on experience as a PostgreSQL DBA or developer.
- Strong proficiency in SQL and PL/pgSQL programming.
- Demonstrated expertise in performance tuning, indexing, and query optimization.
- Experience designing relational schemas and data models for large‑scale applications.
- Solid understanding of backup, recovery, and disaster‑recovery strategies, as well as security best practices.