Description

You will manage and maintain PostgreSQL databases across various environments.

Responsibilities

• Install, configure, and maintain PostgreSQL databases in development, staging, and production.
• Analyze and optimize database performance using tools like EXPLAIN, ANALYZE, and pg_stat_activity.
• Implement, test, and maintain backup and recovery procedures for data integrity.
• Configure and enforce security policies, including user roles and access controls.
• Configure and maintain replication strategies (master-slave, synchronous replication) for high availability.

Required Skills

• Minimum 3-5 years of experience as a PostgreSQL DBA or in a similar role.
• Proficiency in PostgreSQL database installation, configuration, and administration.
• Strong understanding of SQL and database optimization techniques.
• Experience with PostgreSQL tools such as pgAdmin and psql.
• Familiarity with backup and recovery tools (e.g., pg_dump, pg_restore, WAL logs).
• Understanding of database replication concepts.
• Experience with cloud services like AWS RDS.
• Bachelor's degree.

Key Skills

Education

Bachelor's degree