Description

The SQL Server Administrator will provide essential support for over 300 SQL databases across 3 Data Centers and 2 Cloud Providers within the NC Department of Health and Human Services (DHHS). This role requires a seasoned professional with 7+ years of experience in SQL Server administration, a robust understanding of database monitoring, performance tuning, and troubleshooting of database issues.

Compensation and Benefits

• W-2 Rate: up to $50/hour
• 6-month hybrid contract
• Remote work flexibility
• Opportunity for Professional Development

Why you should apply for this position today

This role presents a unique opportunity to work with a large-scale SQL Server environment, contributing to impactful health initiatives within the state. You will be part of a dedicated team focused on enhancing the performance and reliability of critical database systems.

Skills

• Strong understanding of SQL database monitoring and performance tuning
• Experience with backups, restores, and High Availability (Always On)
• Installation and configuration of SQL Server 2014, 2016, and 2019 (Standard and Enterprise)
• Configuration and deployment of SSIS and SSRS packages
• Database upgrade, patching, and refresh experience
• SQL tuning, data conversion/migration, enterprise systems support
• Experience in database maintenance, backup, and recovery
• Ability to establish and enhance operational and monitoring processes
• Familiarity with replication, linked server objects, and database mirroring
• Knowledge of SQL transactional replication and clustered environments
• Experience in SQL 2016 Availability groups and Spotlight (a plus)
• Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) knowledge (a plus)

Responsibilities

• Perform SQL Server performance analysis, tuning, and capacity planning
• Collaborate with DBAs and developers to troubleshoot database and application errors
• Actively monitor the database environment to ensure optimal performance and prevent production issues
• Open and follow up on Service Request tickets to resolve problems promptly
• Provide Production On-Call Support on a rotational basis, including off-hours and weekends

Qualifications

• 7+ years of experience as a SQL Server Administrator
• Proven expertise in SQL database monitoring and performance tuning
• Strong troubleshooting capabilities for database problems
• Experience with various SQL Server features and functionalities
• Excellent communication skills for collaboration with team members

Education Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field preferred

Education Requirements Credential Category

• Bachelor’s degree

Experience Requirements

• 7+ years of experience in SQL Server administration and support
• Demonstrated experience in managing and optimizing large SQL database environments

Why work in Raleigh, NC

Raleigh, NC is known for its vibrant tech scene, rich history, and quality of life. The city offers a blend of cultural attractions, green spaces, and excellent educational institutions. With a growing job market and a supportive community, Raleigh provides a conducive environment for both professional and personal growth.