Cigna Work from Home

By | July 12, 2022

Job Responsibilities : Database Administration Senior Advisor – Work From Home

Salary : $97,100 – $161,900 a year

Company : Cigna

Location : Remote US

Operations DBA 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.

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

For this position we anticipate offering an annual salary of $97100 – $161900 depending on relevant factors including experience and geographic location.

This role is also anticipated to be eligible to participate in an annual bonus plan.

Helping our customers achieve healthier more secure lives is at the heart of what we do. While you take care of our customers we’ll take care of you through a comprehensive benefits program that helps you be at your best. Starting on day one of your employment you’ll be offered several health-related benefits including medical vision dental and best in class well-being and behavioral health programs. We also offer 401(k) with company match company paid life insurance tuition reimbursement a minimum of 18 days of paid time off per year and dozens of corporate discounts on essentials you use every day. For more details on our employee benefits programs please visit the “Life at Cigna” tab on our careersite: www.cigna.com/careers

About Cigna

Cigna Corporation exists to improve lives. We are a global health service company dedicated to improving the health well-being and peace of mind of those we serve. Together with colleagues around the world we aspire to transform health services making them more affordable and accessible to millions. Through our unmatched expertise bold action fresh ideas and an unwavering commitment to patient-centered care we are a force of health services innovation. When you work with us or one of our subsidiaries you’ll enjoy meaningful career experiences that enrich people’s lives. What difference will you make?

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.

Cigna 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.

Click Here : Apply Now