Database Administration Senior Advisors- Hybrid

Location: Bloomfield, CT

Remote Type: Hybrid

Time Type: Full time

Job Description

The job profile for this position is Database Administration Senior Advisor, which is a Band 4 Senior Contributor Career Track Role with Cigna-Evernorth Services Inc.

Responsibilities-

• Design, implement, and optimize large-scale databases in regulated and performance-critical domains which also include high availability, multi-tenant architecture, replication, and sharding across Multi-region Datacenters.

• Manage multi-terabyte enterprise healthcare data environments with advanced replication, hybrid architecture, and capacity planning.

• Utilize database administration skills in 12c, 19c, 19c RAC and ExaCC, 19c on OCI, 12c/19c ASM in Linux, for database upgrades and RHEL migrations.

• Standardize database lifecycle operations using automations tools, such as Ansible, and APIs.

• Hybrid work schedule.

Qualifications-

Requires a Bachelor’s degree in Computers or Engineering or a related field and 5 years of Database Administration experience. (or Master’s degree in Computers or Engineering or a related field and 4 years of Database Administration experience).

Must have experience with: Oracle on-prem, OCI, ExaCC and ADB Administration; Tuning Databases using smart scan, HCC and flash cache; Full-stack performance optimization; Forecasting Capacity planning of databases which are limited to memory, IOPS, and storage by analyzing through data; Implementing and configuring Oracle management databases using VPD (virtual private database); Configuring databases across environments and standardizing the effort using Shell and running via Ansible; Upgrading and migrating production and development databases from 12c to 19c both off-site and in-place methods; Enterprise database migrations to ExaCC using oracle Hybrid Dataguard setup; Proactive diagnostics using AWR, AHF and SQL plan Baselines including optimizing complex queries; Performance tuning on ORM-generated SQL via hibernate, entity framework and tune them in stored procedures; Implementing Smart scan offloading, Storage indexes, and hybrid columnar compression (HCC) on ExaCC databases; Designing machine learning models to adapt silent version upgrades and rollback validation logics; Drift detection; Advanced queuing; Sharding; and, Red-Hat Linux and Oracle Linux (RHEL6, RHEL7, OL7).

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: [email protected] for support. Do not email [email protected] 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.

Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state and local ordinances.