PostgreSQL DBA

PostgreSQL DBA

A PostgreSQL DBA is an expert in managing the PostgreSQL database system. Below are the primary responsibilities with minimum 15+ years in database management system.

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, who can be consultant, train and act as advise the Client teams as a consultant DBA.

He need to define the training topics and train the application teams and Act as an enterprise level DBA who can define and coach the teams within the enterprise.

He needs to provide guidance and address technical challenges and define strategy for migration approach.

Ensure the performance, availability, security, and integrity of the databases while providing support to application teams and other stakeholders.

Proven migration experience with integration from Oracle to Postgres.

Monitor security and prevent any unauthorized access to the database and Schedule consistent maintenance on the server.

Maintain database schema, Manage database availability, Give best practice guidance to the development team and Resolve any production data issues.

Table space 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 and Maintain the database using different utilities. This includes using like pg_ctl and psql.