Database Administration Senior Advisor-Hybrid - The Cigna Group
St. Louis, MO
About the Job
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:_ _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._
_Qualified applicants with criminal histories will be considered for employment in a manner_ _consistent with all federal, state and local ordinances._
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:_ _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._
_Qualified applicants with criminal histories will be considered for employment in a manner_ _consistent with all federal, state and local ordinances._
Source : The Cigna Group
