15+ years of experience in database management systems with deep expertise in PostgreSQL
Proven PostgreSQL performance tuning, backup/restoration, and security administration experience
Experience migrating databases and applications from Oracle to PostgreSQL
Ability to train, coach, and define enterprise-level DBA strategy across teams
Requirements:
Create database objects such as triggers and indexes and manage related schema objects
Monitor database performance to ensure optimum operation and reliability
Maintain backups and disaster recovery plans, and provide consultant guidance to client teams
Lead migrations and provide strategy for Oracle-to-PostgreSQL transitions
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.
