SQL Server Database Administration Senior Advisor - The Cigna Group
Nashville, TN
About the Job
Sr SQL DBA JOB DESCRIPTION
The SQL Server Database Administrator (DBA) is responsible for providing technical support for the database environments SQL 2012-2022 in 24/7 environment. Day to Day responsibilities include production support, access provisioning, dba related tasks, monitor systems alerts, technical reviews. Participate in on-call rotation. Provide assessment of database performance and the identification of problem areas. Document the company’s database environment.
Responsibilities
+ Provides 24 x7 support for various SQL databases, including all levels of troubleshooting. Performs the role of level 2 and level 3 operational support including acting as a focal point on managed database incidents.
+ Responsible for performance tuning and analysis, performance reviews, database health checks, the configuration of all aspects of SQL Server, support, and configuration of database backup and maintenance jobs.
+ Responsible for the configuration and implementation of complex monitoring tools for reporting and alerting on the significant application and system-level events.
+ Create and design database structures and standards to solve operational issues.
+ Project long-range requirements for database administration in conjunction with other managers in the information systems function.
+ Responsible for automation of both simple and complex tasks across the database function. Mentor and knowledge-share with members of the database team.
+ Act in an operational consulting mode to validate new technology to be introduced into the environment.
+ Responsible for relaying SQL Server-specific information through a presentation layer to the broader Cigna IT community.
Qualifications
+ High School diploma; Bachelor's degree preferred.
+ Experience with database standard concepts, practices, and procedures is required. The ability to track these items within a large-scale environment and communicate to diverse groups accordingly.
+ Self-directed and able to work with minimal supervision as well as provide direction and oversight to application team partners and other members of the database team.
+ 5 or more years of work experience in the SQL Database field.
+ Extensive database administration skills in SQL Server 2016 and below as well as the ability to quickly learn SQL Server 2019 features and capabilities
+ SQL Server replication, AlwaysOn high availability, SSIS, SSRS, SPLUNK, Idera DM, DDBoost, Cohecity.
+ In-depth Windows Clustering, Windows Services, and Windows Server Configuration knowledge
+ Knowledge of Active Directory as it relates to SQL Server
+ Knowledge of storage and network layers as they relate to SQL Server
+ SQL database upgrade experience (in-place upgrades, initial configurations, service pack updates, driver installs and updates)
+ Database performance monitoring and tuning and capacity planning skills Excellent PL/SQL and SQL PLUS Development and tuning skills are plus. Automation/development in Ansible, Splunk, Python or other like tools is a must-have
+ Understanding of server resources and how they interact with and impact SQL
+ Automation tool experience with Ansible, Rally, UDeploy, Powershell or other like tools
+ Comprise very strong verbal and written skills, including the ability to produce excellent documentation
+ Ability to work on-call schedule.
+ Ability to change work shifts due to deployments.
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 109,500 - 182,500 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 Group .
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._
The SQL Server Database Administrator (DBA) is responsible for providing technical support for the database environments SQL 2012-2022 in 24/7 environment. Day to Day responsibilities include production support, access provisioning, dba related tasks, monitor systems alerts, technical reviews. Participate in on-call rotation. Provide assessment of database performance and the identification of problem areas. Document the company’s database environment.
Responsibilities
+ Provides 24 x7 support for various SQL databases, including all levels of troubleshooting. Performs the role of level 2 and level 3 operational support including acting as a focal point on managed database incidents.
+ Responsible for performance tuning and analysis, performance reviews, database health checks, the configuration of all aspects of SQL Server, support, and configuration of database backup and maintenance jobs.
+ Responsible for the configuration and implementation of complex monitoring tools for reporting and alerting on the significant application and system-level events.
+ Create and design database structures and standards to solve operational issues.
+ Project long-range requirements for database administration in conjunction with other managers in the information systems function.
+ Responsible for automation of both simple and complex tasks across the database function. Mentor and knowledge-share with members of the database team.
+ Act in an operational consulting mode to validate new technology to be introduced into the environment.
+ Responsible for relaying SQL Server-specific information through a presentation layer to the broader Cigna IT community.
Qualifications
+ High School diploma; Bachelor's degree preferred.
+ Experience with database standard concepts, practices, and procedures is required. The ability to track these items within a large-scale environment and communicate to diverse groups accordingly.
+ Self-directed and able to work with minimal supervision as well as provide direction and oversight to application team partners and other members of the database team.
+ 5 or more years of work experience in the SQL Database field.
+ Extensive database administration skills in SQL Server 2016 and below as well as the ability to quickly learn SQL Server 2019 features and capabilities
+ SQL Server replication, AlwaysOn high availability, SSIS, SSRS, SPLUNK, Idera DM, DDBoost, Cohecity.
+ In-depth Windows Clustering, Windows Services, and Windows Server Configuration knowledge
+ Knowledge of Active Directory as it relates to SQL Server
+ Knowledge of storage and network layers as they relate to SQL Server
+ SQL database upgrade experience (in-place upgrades, initial configurations, service pack updates, driver installs and updates)
+ Database performance monitoring and tuning and capacity planning skills Excellent PL/SQL and SQL PLUS Development and tuning skills are plus. Automation/development in Ansible, Splunk, Python or other like tools is a must-have
+ Understanding of server resources and how they interact with and impact SQL
+ Automation tool experience with Ansible, Rally, UDeploy, Powershell or other like tools
+ Comprise very strong verbal and written skills, including the ability to produce excellent documentation
+ Ability to work on-call schedule.
+ Ability to change work shifts due to deployments.
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 109,500 - 182,500 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 Group .
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