SQL Server Admin

Please take note of the following information:

Job ID: 748082

Title: SQL Server Administrator

Client: State of North Carolina DHHS

Location: Raleigh NC (Onsite)

Job Description:

NC DHHS is seeking an experienced SQL Server Administrator to provide support for 300 SQL databases across 3 Data Centers and 2 Cloud Providers.

This role requires 7 years of demonstrated experience working as a SQL Server administrator; a strong understanding of SQL database monitoring and performance tuning; experience in troubleshooting and resolving database problems; experience with the following:

Backups restores and High Availability (Always On)

Installation and configuration of SQL Serverand 2019 Standard and Enterprise

Configuration of SSIS and SSRS

Work experience on SSIS and SSRS to create and deploy packages and reports

Database upgrade patching and refresh

SQL tuning data conversion/migration supporting enterprise systems

Database maintenance backup and recovery

Setup and improvement of maintenance operational and monitoring processes

Export/Import replication maintaining backup jobs creating Linked Server Objects

Experience in Database Mirroring log shipping and disaster recovery procedures

Experience in SQL transactional replication

Supporting MS SQL databases in Microsoft clustered environments

SQL 2016 Availability Groups is a plus

Experience in Spotlight is a plus

Windows administration PowerShell Visual Studio (SQL Server Data Tools) is a plus

Job duties:

SQL Server performance analysis tuning capacity planning/forecast security and design

Collaborate with DBAs and Developers in troubleshooting database and application errors

Actively monitor the database environment to ensure optimal performance and prevent production issues

Open and followup on Service Request tickets to quickly resolve problems

Perform Production OnCall Support on a rotational basis including offhours and weekends

Skills:

Required / Desired

Demonstrated experience working as a SQL Server administrator

Required: 7 years

Strong understanding of SQL database monitoring and performance tuning

Required: 7 years

Experience in troubleshooting and resolving database problems

Required: 7 years

Experience with Backups restores and High Availability (Always On)

Required: 7 years

Experience with Installation and configuration of SQL Serverand 2019 Standard and Enterprise

Required: 7 years

Configuration of and work experience on SSIS and SSRS to create and deploy packages and reports

Required: 7 years

SQL tuning data conversion/migration supporting enterprise systems

Required: 7 years

Supporting MS SQL databases in Microsoft clustered environments

Required: 7 years

Experience in SQL transactional replication

Required: 7 years

Windows administration PowerShell Visual Studio (SQL Server Data Tools) is a plus

Desired

Experience in Spotlight is a plus

Desired

SQL 2016 Availability Groups is a plus

Desired