SQL Server Administrator - HighCloud Solutions

NC DHHS 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:

• Backups restores and High Availability (Always on),
• Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise
• Configuration of SSIS and SSRS,
• Work experience on SSIS and SSRS to create and deploys packages and Reports
• Database upgrade, Patching & Refresh
• SQL tuning, Data conversion / Migration, Supporting Enterprise Systems
• Database maintenance, Database backup and recovery
• Setup and constantly improve maintenance, operational and monitoring processes
• Export/Import Replication, maintaining back up jobs, Creating Linked Server Objects
• Experience in Database Mirroring, log shipping and DR 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 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 to prevent production issues.
• Open and Follow-up on Service Request tickets to quickly resolve problems.
• Perform Production On-Call Support on rotational basis - including Off-Hours and Weekend