Company:
Crescens Inc.
Location: Raleigh
Closing Date: 02/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Job title: SQL Server Administrator
Location: Raleigh, NC (Hybrid)
Duration: 6 months (can be extendable)
Note:
Onsite work will be required at the client's discretion.
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.
Skills:
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
Skills:
Demonstrated experience working as a SQL Server administrator.
Strong understanding of SQL database monitoring and performance tuning.
Experience in troubleshooting andresolving database problems.
Experience with Backups restores and High Availability (Always on).
Experience with Backups restores and High Availability (Always on), 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
Location: Raleigh, NC (Hybrid)
Duration: 6 months (can be extendable)
Note:
Onsite work will be required at the client's discretion.
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.
Skills:
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
Skills:
Demonstrated experience working as a SQL Server administrator.
Strong understanding of SQL database monitoring and performance tuning.
Experience in troubleshooting andresolving database problems.
Experience with Backups restores and High Availability (Always on).
Experience with Backups restores and High Availability (Always on), 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
Share this job
Useful Links