Job ID: NC-748082 (98491004)
Hybrid/Local SQL Server Admin/DBA with HA/clusters, SSIS, SSRS, data conversion/migration, SQL transactional replication, Windows admin, PowerShell, Data Tools, Spotlight and Availability groups experience
Location: Raleigh, NC (NCDHHS-AM)
Duration: 6 Months
Skills:
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
Description:
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:
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.