Database Administration Senior Advisor (35665406) - The Cigna Group

This is a temporary contract opportunity with The Cigna Group through Magnit, an enterprise third-party vendor for contingent work.

Schedule Notes:

Open to 100% remote, USA only. Core hours are 8am-5pm but need availability to work overtime in evenings and weekends for releases, up to 40-50% of the year.

Responsibilities

• Assist with intake requests, collaborate with the database engineering team and the database production support team and internal customers to deliver an enterprise-level database backend solution for top-tier applications
• Responsible for all aspects of database administration for SQL Server databases including problem solving, configuration, and implementation efforts for large and / or complex projects with an emphasis in operation excellence and continuous improvement of database related processes and procedures
• Provide database solutions for organizational needs while working in accordance with internal policies and procedures
• Works with project teams to create needed database solutions
• Responsible for quality control and auditing of database access to ensure accurate and appropriate use of data
• Consults with and advises users on access to and performance of databases
• Works directly with users to resolve data conflicts and inappropriate data usage
• Responsible for ensuring high levels of data available and database performance
• Tunes and optimizes SQL Statements, Instance Parameters, and Data Storage, including the identification of performance related issues
• Creates database objects
• Participation in the design, creation, and maintenance of SQL databases
• Participate in scrum/work assignment meetings
• Responsible for indexes, buffers, and cache

Required Skills:

• Upgrade DB versions and migrations of database from one server to another server for SQL versions 2016 to 2022
• Implementation of High Availability, replication and mirroring
• Providing access and limiting unauthorized access
• SSIS deployment
• Performance testing evaluation
• Implementation of the SQL and Windows security model
• Taking SQL backups using native SQL tools and 3^rd party backup tools such as DDBoost and Cohesity
• Strong collaboration skills and experience working across multiple teams both within a division and enterprise-wide
• Superior skills using Microsoft Office and Outlook
• Strong written and verbal communication skills required
• 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
• Bachelor's degree in Computer Science or related discipline (or equivalent experience)
• At minimal 5 years of Database experience
• Understanding of the SQL language and ability to write SQL queries
• Experience with query tuning, performance tuning and database design
• Experience in developing and maintaining MS SQL Server databases, data warehouse and multidimensional DBs
• Installing SQL server
• Using encryption at a database level
• Proven track record of implementing changes that have measurable impact

Hourly Pay Rate Range (dependent on location, experience, expectation)

The pay range that Magnit reasonably expects to pay for this position is: $47.00/hour-$62.00/hour

Benefits: Medical, Dental, Vision, 401K (provided minimum eligibility hours are met)