Offer summary

Qualifications:

Minimum 15 years of experience in database management systems, specifically PostgreSQL., Proven experience in database migration from Oracle to PostgreSQL., Strong understanding of database performance optimization and security measures., Ability to train and guide application teams on best practices and database management..

Key responsabilities:

Create and manage database objects such as triggers and indexes.

Monitor database performance and address potential issues proactively.

Maintain backups and execute disaster recovery plans as needed.

Provide technical guidance and support to application teams and stakeholders.

Job description

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.