SQL Server Administrator- Hybrid Role

Company: ARK Solutions, Inc.
Location: Raleigh
Posted on: March 20, 2023

Job Description:

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, Client 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:
oBackups restores and High Availability (Always on),
oInstallation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise
oConfiguration of SSIS and SSRS,
oWork experience on SSIS and SSRS to create and deploys packages and Reports
oDatabase upgrade, Patching & Refresh
oSQL tuning, Data conversion / Migration, Supporting Enterprise Systems
oDatabase maintenance, Database backup and recovery
oSetup and constantly improve maintenance, operational and monitoring processes
oExport/Import Replication, maintaining back up jobs, Creating Linked Server Objects
oExperience in Database Mirroring, log shipping and DR procedures
oExperience in SQL transactional Replication
oSupporting MS SQL databases in Microsoft clustered environments
oSQL 2016 Availability groups is a plus
oExperience in Spotlight is plus
oWindows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plus

Job duties:
oSQL Server performance analysis, tuning, capacity planning/forecast, security, and design
oCollaborate with DBAs and Developers in troubleshooting database and application errors
oActively monitor the database environment to ensure optimal performance and to prevent production issues.
oOpen and Follow-up on Service Request tickets to quickly resolve problems.
oPerform Production On-Call Support on rotational basis - including Off-Hours and Weekend

Keywords: ARK Solutions, Inc., Raleigh , SQL Server Administrator- Hybrid Role, IT / Software / Systems , Raleigh, North Carolina