Data Engineering Consultant

Caring. Connecting. Growing Together.

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale.

Primary Responsibilities:

• Managing Oracle 11g and 12c, 19c databases on HP UNIX and LINUX environments
• Performing all forms of database maintenance and administrative activities; installing, configuring, patching and upgrading Oracle server software, applications and related products
• Design and implement database backups using Oracle Recovery Manager
• Automating routine maintenance tasks as appropriate utilizing OEM, Shell scripting and PL/SQL batch processing
• Support the production environment on 11g,12c, 19c databases on HP UNIX and Linux
• Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment
• Manage, troubleshoot and resolve oracle database and applications issues
• Perform database and application tuning through the use of AWR and ADDM
• Assist the application development team with tuning and optimization of long running SQL and PL/SQL queries for better performance
• Perform and develop the PL/SQL code for automation process
• Manage /support Oracle Golden gate
• Working knowledge of Exadata
• Manager and troubleshoot and resolve Oracle database and Performance its issues
• MySQL database administration
• Manager and troubleshoot and resolve MySQL Issues
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• Oracle Certification 19c or 23c
• Experience with Oracle enterprise manager 13c
• Experience in RAC and Multi-tenant (CDB-PDB) environments and performance tuning as well
• Working knowledge of percona/Proxy clustering with MySQL