HIH - Database Administration Advisor

Position Overview

Cigna is looking for a talented Oracle database administrator to support and build new Oracle Databases

Job Overview

The ideal candidate will have a minimum of 10 years experience in production database operation support, database development, database administration, knowledge of general database concepts, and server administration. Experience with database administration task automation is a big plus.

Responsibilities:

• Assist with intake requests, collaborate with the database engineering team and the database production support team and internal customers to deliver an enterprise-level database backend solution for top-tier applications ensuring infrastructure, use, supportability and cost align with company standards
• Responsible for all aspects of database administration for Oracle databases including problem solving, configuration, and implementation efforts for large and / or complex projects with an emphasis in operation excellence and continuous improvement of database related processes and procedures
• Collaborate with application architects, scrum masters, product managers, business analysts and technical management team to design, develop and document databases, schemas, tables, functions, triggers, procedures, relationships and other necessary aspects of the database
• Clearly articulate database standards and policies to business customers.
• Provide database solutions for organizational needs while working in accordance with internal policies and procedures
• Works with project teams to create needed database solutions
• Responsible for quality control and auditing of database access to ensure accurate and appropriate use of data
• Consults with and advises users on access to and performance of databases
• Works directly with users to resolve data conflicts and inappropriate data usage
• Responsible for ensuring high levels of data available and database performance
• Tunes and optimizes SQL Statements, Instance Parameters, and Data Storage, including the identification of performance related issues
• Creates database objects
• document standards for where new rules apply or ad hoc changes are driven by project requirements.
• Participation in the design, creation, and maintenance of databases
• Participate in scrum/work assignment meetings
• Responsible for indexes, buffers, and cache

Qualifications

Education:

• Bachelor's degree in Computer Science or related discipline (or equivalent experience)

Experience:

• Minimum of 11-13 years of experience required
• 10-12 years of Database experience
• Must have hands-on Oracle experience as a systems DBA on 12c & 19c, with the latest tuning and optimization techniques.
• Hands-on Oracle DB upgrade experience, Oracle 12c to 19c is required.
• Understanding relational and dimensional data-modeling is required in addition to experience designing and developing new databases and schemas.
• Required experience with tools such as:
• Monitoring tools: New Relic, Dynatrace OEM, Splunk
• Scheduling tools: ESP
• DBA tools: TOAD, PuTTY
• Experience in database performance monitoring and tuning skills, SQL and Stored-Procedure tuning OEM AWR/ADDM/GRID.
• Understanding of the SQL language and ability to write SQL queries
• Experience with query tuning, performance tuning and database design
• Experience in developing and maintaining MS SQL Server databases, data warehouse and multidimensional DBs
• Installing SQL server
• Using encryption at a database level

About Evernorth Health Services

Evernorth Health Services, a division of The Cigna Group, creates pharmacy, care and benefit solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention and treatment of illness and disease more accessible to millions of people. Join us in driving growth and improving lives.