PostgreSQL DBA

Job Summary:

The PostgreSQL Database Administrator (DBA) will be responsible for managing, maintaining, and optimizing PostgreSQL database environments. The role involves database installation, configuration, upgrades, cluster management, and performance monitoring while ensuring high availability and reliability of PostgreSQL databases.

Key Responsibilities:

• Install, configure, and maintain PostgreSQL database servers.
• Manage and maintain PostgreSQL clusters to ensure high availability and performance.
• Perform database upgrades, migrations, and version management for PostgreSQL environments.
• Monitor database performance and troubleshoot issues to ensure system stability.
• Utilize community-supported tools such as Pgbadger, Slony, PGAdmin, Pgpool, and PgBouncer for monitoring, administration, and connection pooling.
• Perform routine database maintenance activities to maintain database health and performance.
• Analyze database logs and performance metrics to identify and resolve issues.
• Work independently to troubleshoot and provide solutions for database-related issues.

Qualifications and Skills:

• In-depth knowledge of EDB PostgreSQL database architecture.
• Experience with PostgreSQL cluster management.
• Hands-on experience with PostgreSQL upgrades and database migrations.
• Familiarity with PostgreSQL community tools such as Pgbadger, Slony, PGAdmin, Pgpool, and PgBouncer.
• Strong analytical and troubleshooting skills.
• Ability to work independently and manage PostgreSQL database environments effectively.