Description

You will manage and maintain production and development PostgreSQL database environments.

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL databases.
• Ensure optimal database performance by monitoring, troubleshooting, and fine-tuning.
• Design, implement, and maintain high availability solutions like replication and clustering.
• Develop and test disaster recovery plans to ensure minimal data loss.
• Automate routine tasks such as backups, migrations, and maintenance jobs.

Required Skills

• 8+ years managing PostgreSQL databases in production.
• Expertise in designing and implementing HA architectures (e.g., streaming replication, Patroni).
• Proficiency in database performance tuning, query optimization, and indexing.
• Strong knowledge of database security principles and access controls.
• Experience with backup and recovery solutions (e.g., pgBackRest, Barman).
• Proficient in advanced SQL queries, stored procedures, and triggers.
• Scripting experience in Bash or Python for database automation.
• Solid understanding of Linux systems and shell scripting.
• Familiarity with Docker and Kubernetes environments.

Preferred Skills

• Experience with CI/CD Pipelines.
• Familiarity with MySQL, MongoDB, or Oracle.
• Knowledge of Hadoop.

Key Skills

Education

Bachelor's degree