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.
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.