Help us architect our future. Get ready for a job that encourages you to think strategically yet stay connected with your teams. Do you have a premium-brand regional or strategy experience? If so, prepare to innovate, create, and inspire. The Database Administration Senior Advisor is responsible for all activities related to the administration of computerized databases.
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, native SQL Mail, and DB Job management, SPLUNK, RedGate, GitHub, TFS, Idera DM, DDBoost, CA Clarity, HP Service Manager, Info Center (or equivalent Enterprise Toolsets)
- 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.
This role is Flex/WFH which allows most work to be performed at home or on occasion at a Cigna office location. Employees must be fully vaccinated if they choose to come onsite
This position is not eligible to be performed in Colorado.
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.