SQL Server Administrator

Profile

NC DHHS is seeking an experienced SQL Server Administrator to provide support for 300 SQL databases across 3 Data Caters and 2 Cloud Providers.
Complete Description:
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 SQL 2014, 2016 and 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 Follow-up on Service Request tickets to quickly resolve problems. o Perform Production On-Call Support on rotational basis - including Off-Hours and Weekend
Required/Desired Skills
Skill
Required /Desired
Amount
of Experience
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 2014, 2016 and 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
****
Local:
518-218-1700
Map
& visit our office
Corporate - Albany NY
435 New Karner Rd, Ste 202
Albany NY 12205
Chicago
63E Lake Street, Ste 201
Chicago, IL 60601
Florida
17258 SE 121st Ave
Summerfield, FL 34491
© 2018 MVP Consulting Plus. All Rights Reserved.

Company info

Sign Up Now - WashingtondcCrossing.com