Database Administration Senior Advisor-Hybrid

Posted 9 Hours Ago
Be an Early Applicant
St. Louis, MO
Senior level
Healthtech • Insurance
The Role
The Database Administration Senior Advisor will review SQL and PL/SQL code for performance issues, consult on best practices, lead troubleshooting efforts, manage Oracle database software, oversee migrations and backup processes, and set up monitoring systems. The role includes automating database operations, providing on-call support, and ensuring database availability.
Summary Generated by Built In

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:

  • Review SQL and PL/SQL code to identify performance issues.

  • Provide consultation to Application Development teams on SQL and PL/SQL best practices.

  • Lead troubleshooting calls with various infrastructure and application teams.

  • Work with Oracle vendor to find root cause for complex database issues. Troubleshoot complex performance issues of Oracle wait events.

  • Review Linux and storage internals that influence database activity. I

  • nstall and manage Oracle Database Software, building databases per requirements and standards, and setting up database backups.

  • Install and manage Oracle ClusterWare and troubleshooting issues with ClusterWare processes.

  • Review database migrations, export/import, and transportable tablespaces. Restore and recover Oracle databases using RMAN.

  • 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 by utilizing a good understanding of Oracle internal processes.

  • Set up and manage Oracle Enterprise Manager (OEM) infrastructure and set up monitoring using OEM for database environment.

  • Automate routine database operations using Ansible. Participate in 24*7 on-call support to resolve Incident tickets and be responsible for database availability. Virtual/work from home benefit available.

Qualifications:

Requires a Master’s degree in Computer Science or a closely related field and 3 years of Oracle database administration experience (or a Bachelor’s degree in Computer Science or a closely related field and 5 years of Oracle database administration experience).

Must have experience with: implementing backup and recovery strategies and procedures; RMAN; SQL*Loader; EXP; IMP; Expdp; Impdp; TOAD; TKPROF; Explain Plan; STATSPACK; SQL Developer; Exadata; GoldenGate; Linux Shell Scripting; Ansible; Python; Microsoft Azure; Oracle Enterprise Manager (“OEM”); SQL; PL/SQL; and performance tuning reports generated by SQL Trace, TKPROF, AWR, ADDM, ASH, and SQL-T. 



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.

Top Skills

Pl/Sql
Python
SQL
The Company
HQ: Bloomfield, CT
74,000 Employees
On-site Workplace

What We Do

At Cigna, we're more than a health insurance company. We are your partner in total health and wellness. And we’re here for you 24/7 – caring for your body and mind.

As a global health service company, Cigna's mission is to improve the health, well-being, and peace of mind of those we serve by making health care simple, affordable, and predictable.

Our values are the core of our culture. Our values guide how all 74,000 of us around the world work together, serve our customers, patients, clients, communities, and deliver on our mission.

Similar Jobs

Cloudflare Logo Cloudflare

Data Center Selection Manager

Cloud • Information Technology • Security • Software • Cybersecurity
Hybrid
Mexico, MO, USA
3900 Employees
111K-174K Annually

Spectrum Logo Spectrum

Sr Director - Data Analytics

Information Technology • Internet of Things • Mobile • On-Demand • Software
St Louis, MO, USA
100000 Employees

Merge (mergeedu) Logo Merge (mergeedu)

Sr. Director, Analytics

Edtech • Hardware • Information Technology • Mobile • Virtual Reality
Kansas City, MO, USA
29 Employees

BAE Systems, Inc. Logo BAE Systems, Inc.

Geospatial Analyst - St. Louis, MO

Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Hybrid
St Louis, MO, USA
40000 Employees
69K-117K Annually

Similar Companies Hiring

Zealthy Thumbnail
Telehealth • Social Impact • Pharmaceutical • Healthtech
New York City, NY
13 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana
Cencora Thumbnail
Pharmaceutical • Logistics • Healthtech
Conshohocken, PA
46000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account