Cigna Health and Life Insurance Company
Database Administration Senior Advisor-Hybrid
Cigna Health and Life Insurance Company, Saint Louis, Missouri, United States, 63146
Database Administration Senior Advisor-Hybrid
Apply remote type Hybrid locations St. Louis, MO time type Full time posted on Posted 16 Days Ago job requisition id 24014797The 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.Install and manage Oracle Database Software, building databases per requirements and standards, and setting up database backups.Install and manage Oracle ClusterWare and troubleshoot 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 GroupDoing 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.
#J-18808-Ljbffr
Apply remote type Hybrid locations St. Louis, MO time type Full time posted on Posted 16 Days Ago job requisition id 24014797The 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.Install and manage Oracle Database Software, building databases per requirements and standards, and setting up database backups.Install and manage Oracle ClusterWare and troubleshoot 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 GroupDoing 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.
#J-18808-Ljbffr