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
Requirements
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