Oracle Database Administration Senior Advisor at Cigna in Bloomfield, Connecticut

Job Description:

Remote

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

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.

For this position, we anticipate offering an annual salary of 97,100 - 161,900 USD / yearly, depending on relevant factors, including experience and geographic location.

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

We want you to be healthy, balanced, and feel secure. That’s why you’ll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. Starting on day one of your employment, you’ll be offered several health-related benefits including medical, vision, dental, and 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 paid holidays. For more details on our employee benefits programs, visit Life at Cigna.

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.

Apply Now