Cynet Systems
SQL Server Administrator
Cynet Systems, Raleigh, North Carolina, United States, 27601
Job Description:
Duties:
SQL Server performance analysis, tuning, capacity planning/forecast, security, and design.Collaborate with DBAs and Developers in troubleshooting database and application errors.ctively 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 a rotational basis - including Off-Hours and Weekend.Backup 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 ReportsDatabase upgrade, Patching & Refresh.SQL tuning, Data conversion / Migration, Supporting Enterprise Systems.Database maintenance, Database backup, and recoverySetup and constantly improve maintenance, operational, and monitoring processesExport/Import Replication, maintaining backup jobs, Creating Linked Server ObjectsExperience 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 are a plus.Experience in Spotlight is plus.Windows administration, PowerShell, and Visual Studio (SQL Server Data Tools) is a plus .
Duties:
SQL Server performance analysis, tuning, capacity planning/forecast, security, and design.Collaborate with DBAs and Developers in troubleshooting database and application errors.ctively 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 a rotational basis - including Off-Hours and Weekend.Backup 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 ReportsDatabase upgrade, Patching & Refresh.SQL tuning, Data conversion / Migration, Supporting Enterprise Systems.Database maintenance, Database backup, and recoverySetup and constantly improve maintenance, operational, and monitoring processesExport/Import Replication, maintaining backup jobs, Creating Linked Server ObjectsExperience 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 are a plus.Experience in Spotlight is plus.Windows administration, PowerShell, and Visual Studio (SQL Server Data Tools) is a plus .