PostgreSQL DBA

Description

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 Discover 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 stakeholder
● 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.