SANJAY RAJ

• Around 6.4 Years of experience as a SQL Server DBA and have good knowledge in administration in Microsoft SQL server 2008R2 and 2012/2014/2017/2019 ,Azure SQL managed instance, SQL VM ,Azure Arc SQL managed instance and MongoDB. • Provided 24/7 Support for Production, Development & Test Servers of MSSQL Servers. • Installing and configuring SQL Server 2008R2/2012/2014/2017/2019 and applying service packs. • Deploying the SQL servers in Cloud, I'm somewhat good at networking and connectivity in azure. • I have been working with only Azure cloud for the last 4 years. • Migrating the SQL Server databases and instances from lower version to higher version. • Troubleshooting the backup failures and recovering databases from the point of crash. • Performing Database refresh tasks from Dev-Staging/Pre-prod to Dev/UAT to Pre-prod servers. • Moving the System and user databases from one location to another location. • Creating logins and assigning privileges like Roles/Securable to the users on databases and fixing the orphan users and allow the users to access the databases. • Creating and configuring the jobs and automating them through the SQL Agent schedules. • Creating and maintaining the indexes on the tables and performing Re-build/Re-organizing indexing to improve performance. • Troubleshooting blockings, deadlocks, disk space issues and fixing them by adding permanent fixes. • Running the maintenance activities like update-statistics and DBCC CHECKDB. • Configuring Log shipping between two servers and troubleshooting at the time of synchronization issues. Performing role swapping and failover depending on the situation. • Configuring Database Mirroring between two partners in any of the three modes (High Availability, High Safety and High Performance) and ensuring the synchronization between partners. • Configuring and implementing SQL Server Clustering and troubleshooting at the time of failover issues. • Configuring HADR (Always-ON) in SQL Server and configuring Listeners to Handcrafting Multiple Availability groups and Listeners and troubleshooting when any synchronization issues Troubleshooting slow running queries. • Having Knowledge in SSIS