PostgreSQL DBA Dearborn, MI Onsite for fulltime

PostgreSQL DBA

Dearborn, MI Onsite

Fulltime

Roles & Responsibilities

• 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.
• Monitor security and prevent any unauthorized access to the database
• Schedule consistent maintenance on the server
• Maintain database schema
• Manage database availability
• Give best practice guidance to the development team
• Resolve any production data issues
• Tablespace 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
• Maintain the database using different utilities. This includes using like pg_ctl and psql.
• Good to have AWS Cloud Platform Knowledge.
• Must have Aurora PostgreSQL knowledge.
• DMS knowledge
• Migration from Oracle to AWS PostgreSQL database
• S3 Bucket Knowledge.