What are the responsibilities and job description for the SQL Administrator position at Sunrise Systems?
Experience in troubleshooting and resolving database problems; Experience with following :
o Backups restores and High Availability (Always on),
o Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise
o Configuration of SSIS and SSRS,
o Work experience on SSIS and SSRS to create and deploys packages and Reports
o Database upgrade, Patching & Refresh
o SQL tuning, Data conversion / Migration, Supporting Enterprise Systems
o Database maintenance, Database backup and recovery
o Setup and constantly improve maintenance, operational and monitoring processes
o Export / Import Replication, maintaining back up jobs, Creating Linked Server Objects
o Experience in Database Mirroring, log shipping and DR procedures
o Experience in SQL transactional Replication
o Supporting MS SQL databases in Microsoft clustered environments
o SQL 2016 Availability groups is a plus
o Experience in Spotlight is plus
o Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plus
Job duties :
o SQL Server performance analysis, tuning, capacity planning / forecast, security, and design
o Collaborate with DBAs and Developers in troubleshooting database and application errors
o Actively monitor the database environment to ensure optimal performance and to prevent production issues.
o Open and Follow-up on Service Request tickets to quickly resolve problems.
o Perform Production On-Call Support on rotational basis - including Off-Hours and Weekend
