Title
SQL Server Administrator
Location
Raleigh NC (Hybrid)
Duration
6 Months
Interview Type
Webcam Interview Only
Job Type
C2CW2
Job 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 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
Required / Desired
Amount
of Experience
Demonstrated experience working as a SQL Server administrator
Required
Years
Strong understanding of SQL database monitoring and performance tuning
Required
Years
Experience in troubleing and resolving database problems
Required
Years
Experience with Backups restores and High Availability (Always on)
Required
Years
Experience with Installation and configuration of SQLand 2019 Standard and Enterprise
Required
Years
Configuration of and work experience on SSIS and SSRS to create and deploys packages and Reports
Required
Years
SQL tuning Data conversion / Migration Supporting Enterprise Systems
Required
Years
Supporting MS SQL databases in Microsoft clustered environments
Required
Years
Experience in SQL transactional Replication
Required
Years
Windows administration PowerS Visual Studio (SQL Server Data Tools) is a plus
Desired
Experience in Spotlight is plus
Desired
SQL 2016 Availability groups is a plus
Desired