• Experience on installing the SQL Server 2008, 2008R2, 2012, 2014 and 2016 instances standalone.
• Experience in upgrading/migration of SQL Server DB instances with latest service packs.
• Creation of logins, users and managing privileges as a part of security policies.
• Analyzing the SQL job failures and providing solution.
• Experience on moving system and user database files from one drive to another drives.
• Having experience on handling suspect database issues.
• Daily checking and resolving the tickets depends on priority levels.
• Configuration of log shipping, Mirroring, Replication, Always ON in prod environment.
• Maintaining documentation for the complete environment.
• Troubleshooting & resolving blocking/locking and dead lock issues and taking action as per approval.
• Performing Database refreshed from Prod to Test and Dev servers.
• Maintaining the Security of the Database and giving permission to the Users on req.
• Configuring linked server.
• Creation of SQL Server Agent Jobs for full backup, Differential Backup & Transactional Backup.(Along with cleaning old backups)
• Preparing monthly data viz., Sql_Password_Policy_Exception, Version Management Dashboard, Software Asset Management Dashboard, Risk Register.
• Troubleshooting and providing the fix for transaction logs and Tempdb full issues.
• Experience on moving system and user database files from one drive to another drives.
• Performing rebuild/reorganize of indexes as per fragmentation percentage