• Over 5+ years of experience as a SQL Server DBA in a Production Environment
• Experience on installing the SQL Server 2008, 2008R2, 2012and 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/Working/Troubleshooting of log shipping in prod environment.
• Working on Mirroring, Replication, Always ON.
• 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.