SQL Server Administrator

JOB: SQL Server Administrator

Location : Raleigh NC Onsite

Duration: 12 Months

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

Due to the growth of SQL Server usage in ITD NC DHHS is in need of a SQL Server Administrator to provide support for over 300 SQL Databases across 3 Data Centers and 2 Cloud Providers. This role requires 7 years demonstrated experience working as a SQL Server administrator; Strong understanding of SQL database monitoring and performance tuning; Experience in troubleshooting and resolving database problems; Experience with following:

o Backups restores and High Availability (Always on)

o Installation and configuration of SQLand 2019 Standard and Enterprise

o Configuration of SSIS and SSRS

o Work experience on SSIS and SSRS to create and deploys packages and Reports

o Database upgrade Patching & Refresh

o SQL tuning Data conversion / Migration Supporting Enterprise Systems

o Database maintenance Database backup and recovery

o Setup and constantly improve maintenance operational and monitoring processes

o Export/Import Replication maintaining back up jobs Creating Linked Server Objects

o Experience in Database Mirroring log shipping and DR procedures

o Experience in SQL transactional Replication

o Supporting MS SQL databases in Microsoft clustered environments

o SQL 2016 Availability groups is a plus

o Experience in Spotlight is plus

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

Job duties:

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

o Collaborate with DBAs and Developers in troubleshooting database and application errors

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

o Open and Followup on Service Request tickets to quickly resolve problems.

o Perform Production OnCall Support on rotational basis including OffHours and Weekend

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 SQLand 2019 Standard and Enterprise

Required

7

Years

Configuration of and work experience on SSIS and SSRS to create and deploys 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 plus

Desired

SQL 2016 Availability groups is a plus

Desired