SQL Server Admin

Experience Backups, restores and High Availability (Always on) Installation and configuration of SQL Server 2014, 2016 and 2019 Standard and Enterprise Configuration of SSIS and SSRS Work experience on SSIS and SSRS to create and deploy packages and reports Database upgrade, patching & refresh SQL tuning, data conversion / migration, supporting enterprise systems Database maintenance, backup and recovery Setup and constant improvement of maintenance, operational and monitoring processes Export/Import replication, maintaining backup 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 (plus) Experience in Spotlight (plus) Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) (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 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 weekends J-18808-Ljbffr