Microsoft SQL Server Administrator II

NOTES FOR RECRUITERS:Interview Process: Webcam Interview OnlyITEMS REQUIRED AT THE TIME OF SUBMITTAL:

Onsite work will be required at the client's discretion. Do you accept this requirement?Job Description:Our client 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 EnterpriseConfiguration of SSIS and SSRS,Work experience on SSIS and SSRS to create and deploys packages and ReportsDatabase upgrade, Patching & RefreshSQL tuning, Data conversion / Migration, Supporting Enterprise SystemsDatabase maintenance, Database backup and recoverySetup and constantly improve maintenance, operational and monitoring processesExport/Import Replication, maintaining back up jobs, Creating Linked Server ObjectsExperience in Database Mirroring, log shipping and DR proceduresExperience in SQL transactional ReplicationSupporting MS SQL databases in Microsoft clustered environmentsSQL 2016 Availability groups is a plusExperience in Spotlight is plusWindows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plusJob duties:

SQL Server performance analysis, tuning, capacity planning/forecast, security, and designCollaborate with DBAs and Developers in troubleshooting database and application errorsActively 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 WeekendRequired Skills:

7 Years - Demonstrated experience working as a SQL Server administrator7 Years - Strong understanding of SQL database monitoring and performance tuning7 Years - Experience in troubleshooting and resolving database problems7 Years - Experience with Backups restores and High Availability (Always on),7 Years - Experience with Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise7 Years - Configuration of and work experience on SSIS and SSRS to create and deploys packages and Reports7 Years - SQL tuning, Data conversion / Migration, Supporting Enterprise Systems7 Years - Supporting MS SQL databases in Microsoft clustered environments7 Years - Experience in SQL transactional ReplicationDesired Skills:

Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plusExperience in Spotlight is plusSQL 2016 Availability groups is a plus

Skills Matrix

Skill

Years Used

Last Used

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 Backups restores and High Availability (Always on),

Experience with Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise

Configuration of and work experience on SSIS and SSRS to create and deploys packages and Reports

SQL tuning, Data conversion / Migration, Supporting Enterprise Systems

Supporting MS SQL databases in Microsoft clustered environments

Experience in SQL transactional Replication

Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plus

Experience in Spotlight is plus

SQL 2016 Availability groups is a plus