PostgreSQL DBA

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.