Job highlights
Identified by Google from the original job post
Qualifications
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:
Configuration of SSIS and SSRS,
Experience in SQL transactional Replication
Supporting MS SQL databases in Microsoft clustered environments
Experience in Spotlight is plus
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
Supporting MS SQL databases in Microsoft clustered environments
Experience in SQL transactional Replication
Experience in Spotlight is plus
Responsibilities
Backups restores and High Availability (Always on),
Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise
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
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
SQL tuning, Data conversion / Migration, Supporting Enterprise Systems
Job description
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