Postgres DBA

Key requirements:

A PostgreSQL DBA is an expert in managing the PostgreSQL database system. Let us take a look at their primary responsibilities.

● Create the objects in the database, such as triggers, indexes, etc.

● Monitor the performance of the database and ensure optimum performance.

● Identify potential issues in the database to solve them early.

● Maintain backups and perform disaster recovery in case a disaster destroys the database.

● Monitor security and prevent any unauthorized access to the database

● Schedule consistent maintenance on the server

● Maintain database schema

● Manage database availability

● Give best practice guidance to the development team

● Resolve any production data issues

● Taplespace management

● Role management

● Develop automation technologies to accelerate the process of data loading.

● Develop relational databases

● Ensure data integrity

● Manage user access and permissions by adding and removing users as required

● Maintain the database using different utilities. This includes using like pg_ctl and psql.

Background:

The candidate should be degree educated and needs to have at least 6 plus years solid experience as Production Support DBA.