SQL Server Administrator

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 troubleing and resolving database problems;

Experience with following:

• Backups restores and High Availability (Always on)
• Installation and configuration of SQLand 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 PowerS Visual Studio (SQL Server Data Tools) is a plus

Job duties:

• SQL Server performance ysis tuning capacity planning/forecast security and design
• Collaborate with DBAs and Developers in troubleing database and application errors
• Actively monitor the database environment to ensure optimal performance and to prevent production issues.
• Open and Followup on Service Request tickets to quickly resolve problems.
• Perform Production OnCall Support on rotational basis including OffHours and Weekend