What are the responsibilities and job description for the SQL Server Admin position at Cyborgwave?
Please Take Note Of The Following Information
Job ID: 748082
Title: SQL Server Administrator
Client: State of North Carolina - DHHS
Location: Raleigh, NC (Onsite)
Job Description
NC DHHS is seeking an experienced SQL Server Administrator to provide support for 300 SQL databases across 3 Data Centers and 2 Cloud Providers.
Role
This role requires 7 years of demonstrated experience working as a SQL Server administrator; a strong understanding of SQL database monitoring and performance tuning; experience in troubleshooting and resolving database problems; experience with the following:
Required / Desired
Job ID: 748082
Title: SQL Server Administrator
Client: State of North Carolina - DHHS
Location: Raleigh, NC (Onsite)
Job Description
NC DHHS is seeking an experienced SQL Server Administrator to provide support for 300 SQL databases across 3 Data Centers and 2 Cloud Providers.
Role
This role requires 7 years of demonstrated experience working as a SQL Server administrator; a strong understanding of SQL database monitoring and performance tuning; experience in troubleshooting and resolving database problems; experience with the following:
- Backups, restores, and High Availability (Always On)
- Installation and configuration of SQL Server 2012, 2016, and 2019 Standard and Enterprise
- Configuration of SSIS and SSRS
- Work experience on SSIS and SSRS to create and deploy packages and reports
- Database upgrade, patching, and refresh
- SQL tuning, data conversion/migration, supporting enterprise systems
- Database maintenance, backup, and recovery
- Setup and improvement of maintenance, operational, and monitoring processes
- Export/Import, replication, maintaining backup jobs, creating Linked Server Objects
- Experience in Database Mirroring, log shipping, and disaster recovery 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 a plus
- Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plus
- 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 prevent production issues
- Open and follow-up on Service Request tickets to quickly resolve problems
- Perform Production On-Call Support on a rotational basis, including off-hours and weekends
Required / Desired
- 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 Server 2012, 2016, and 2019 Standard and Enterprise
- Required: 7 years
- Configuration of and work experience on SSIS and SSRS to create and deploy 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 a plus
- Desired
- SQL 2016 Availability Groups is a plus
- Desired
Salary : $55 - $60
