Job Title : SQL Server Administrator
Location : Raleigh, NC
Duration : 6months contract
Job Description :
- 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 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 Weekend