SQL Server Administrator

HybridAbout The JobDuration: 6+ Months Contract (possibility of extension) Location: Hybrid- Raleigh, NCPay rate: Hourly, depending on experienceJob ID: 748082 Responsibilities: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 WeekendQualifications: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 Centres 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 EnterpriseConfiguration of SSIS and SSRS,Work experience on SSIS and SSRS to create and deploys packages and ReportsDatabase upgrade, Patching & RefreshSQL tuning, Data conversion / Migration, Supporting Enterprise SystemsDatabase maintenance, Database backup and recoverySetup and constantly improve maintenance, operational and monitoring processesExport/Import Replication, maintaining back up jobs, Creating Linked Server ObjectsExperience in Database Mirroring, log shipping and DR proceduresExperience in SQL transactional ReplicationSupporting MS SQL databases in Microsoft clustered environmentsSQL 2016 Availability groups is a plusExperience in Spotlight is plusWindows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plus. About our CompanyDataSoft Technologies is a highly recognized provider of professional IT Consulting services in the US. Founded in 1994, DataSoft Technologies, Inc. provides staff augmentation services for Information Technology and Automotive Services. Our team member benefits include:Paid Holidays/Paid Time Off (PTO)Medical/Dental InsuranceVision InsuranceShort Term/Long Term DisabilityLife Insurance401 (K)