We are looking for a skilled PostgreSQL DBA with strong Ansible automation expertise to join our dynamic team as a Subject Matter Expert (SME) with experience of opens source and EDB PostgreSQL.
**Required Skills and Qualifications:**
- Bachelor’s degree in Computer Science, Information Technology, or related field. –
- 8-10 years of experience as a Database Administrator (DBA) with a focus on PostgreSQL.
- Strong expertise in PostgreSQL database management, optimization, and troubleshooting.
- Proficiency in Ansible automation for database operations and infrastructure management.
- Experience with PostgreSQL tools such as pgAdmin, pg_dump, pg_backup, Barman, and pg_stat_statements for backup, recovery, and performance tuning. – Knowledge of PostgreSQL replication tools like pg_logical and high-availability solutions like Patroni. –
- Experience with PostgreSQL monitoring tools such as pg_stat_activity, pgBadger, and Prometheus for performance and availability monitoring.
Experience with PostgreSQL backup, recovery, and performance tuning. – Solid understanding of PostgreSQL security best practices. – Excellent problem-solving and troubleshooting skills. – Strong communication and collaboration skills. – Expertise in shell scripting, Ansible scripting.