Job Description

Enterprise Database Services is looking for a Senior Oracle Database Administrator who has extensive experience in designing and supporting oracle databases with a strong understanding of database concepts, performance tuning, troubleshooting and root cause analysis. The ability to troubleshoot complex SQL performance issues with a deep understanding of SQL execution plans and different SQL tuning techniques is required.

Please note, candidates must be local to a Cigna offic

Roles and Responsibilities

• Review of SQL and PL/SQL code to identify performance issues, in-depth knowledge of SQL and PL/SQL is a must.
• Provide consultation to Application Development teams on SQL and PL/SQL best practices.
• Extensive experience leading troubleshooting calls with various infrastructure and application teams.
• Efficiently work with Oracle vendor to find root cause for complex database issues.
• In-Depth knowledge of Oracle wait events to troubleshoot complex performance issues is a must.
• In-depth knowledge in Linux and storage internals that influence database activity is a must.

• Install and manage Oracle Database Software, build databases per requirements and standards, and set up database backups.
• Install and manage Oracle ClusterWare and troubleshoot issues with ClusterWare processes.
• Experience with database migrations, export/import and transportable tablespaces.

• Proficient with restoring and recovering of oracle databases using RMAN is required, must be able to restore databases from block corruptions and logical corruptions, and recover the database to Point-In-Time.
• Apply Quarterly Patches to Database, Standalone Grid Infrastructure, and ClusterWare and troubleshoot any issues with patching (requires good understanding of the oracle internal processes).
• Setup and Manage Oracle Enterprise Manager (OEM) Infrastructure,and setup monitoring using OEM for database environments.
• Automation of routine database operations using Ansible, with broad understanding of CI/CD tools.
• Participate in 24*7 On-call support to resolve Incident tickets and be responsible for database availability.
• Mentor team members to develop talent

Experience/Education

• 8+ years of relevant experience and knowledge of Oracle database administration with oracle 11g, 12c, 19c, Oracle RAC, dataguard, goldengate and ASM in Linux is required.
• 3+ years of hands-on experience with Automation tools and technologies like Ansible, GitHub, and similar CI/CD technologies.
• Ability to stay very organized while managing multiple tasks and activities and takes initiative and is a self-starter.
• Knowledge in AWS and Python is a plus

• Strong collaboration skills and experience working across multiple teams both within a division and enterprise-wide
• Strong Team Lead skills
• Strong interpersonal, problem solving, facilitation, and prioritization skills
• Strong technical acumen, able to ensure that technical solutions, strategies, practices, and governance deliver business and customer value
• Development experience with one or more modern scripting/automation languages (Ansible, Python, etc.) - preferred
• Energy, integrity, and strong work ethic

If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.

About The Cigna Group

Doing something meaningful starts with a simple decision, a commitment to changing lives. At The Cigna Group, we\'re dedicated to improving the health and vitality of those we serve. Through our divisions Cigna Healthcare and Evernorth Health Services, we are committed to enhancing the lives of our clients, customers and patients. Join us in driving growth and improving lives.

Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.

If you require reasonable accommodation in completing the online application process, please email: SeeYourself@cigna.com for support. Do not email SeeYourself@cigna.com for an update on your application or to provide your resume as you will not receive a response.

The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State.

eQuest