Logo
MSys Inc

SQL Server Administrator -Hybrid

MSys Inc, Raleigh, North Carolina, United States, 27601


Job summary: Title: SQL Server Administrator -Hybrid Location: Raleigh, NC, United States Length and terms: Long term - W2 or C2C Position created on 09/30/2024 06:08 pm Job description: Interview Type Webcam Interview Very long term project initial PO for 1 year, expect to go for 4 years Hybrid SQL Server Administrator to provide support for 300 SQL databases across 3 Data Caters and 2 Cloud Providers. Job Description: Due to the growth of SQL Server usage in ITD, 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 Required Skills: Demonstrated experience working as a SQL Server administrator 7 Years Strong understanding of SQL database monitoring and performance tuning 7 Years Experience in troubleshooting and resolving database problems 7 Years Experience with Backups restores and High Availability (Always on), 7 Years Experience with Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise 7 Years Configuration of and work experience on SSIS and SSRS to create and deploys packages and Reports 7 Years SQL tuning, Data conversion Migration, Supporting Enterprise Systems 7 Years Supporting MS SQL databases in Microsoft clustered environments 7 Years Experience in SQL transactional Replication 7 Years Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plus Experience in Spotlight is plus SQL 2016 Availability groups is a plus Contact the recruiter working on this position: The recruiter working on this position is Sandeep(Shaji Team) Maraganti His/her contact number is His/her contact email is sandeep.maragantimsysinc.com Our recruiters will be more than happy to help you to get this contract.