PostgreSQL DBA

Request-ID : 29568-1

BFS

• Max rate $75
• Riverwoods - IL Onsite 5 days

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 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.