Bagish Jha Email & Phone Number

•8 Years of experience in MS SQL Server Database Administration and Support Skills:• Installation, Configuration and patching service packs and cumulative updates of MS SQL Server• Supporting SQL Server versions 2008 - 2019 in Production and non-production environments • Design HADR solution with Clustering, Log-Shipping, Database Mirroring and Always On• Design Reporting solution by setting up SQL Server Transactional Reporting• Actively involved in Conception of Application and Database Design.• Creating Database maintenance plans. • Backing up master & system databases and restoring them when necessary supporting production environment.• Run DBCC consistency checks, Rebuild Indexes, Update statistics and Recompile SPs for databases on regular basis.• Planned the Complete Backing up and Restoring plan of the Production Databases.• Creating and managing SSIS packages. • CreatingSQL agent jobs and monitoring them regularly.• Configured Server for sending automatic mails to the respective people when a job is failed or succeed. • Backing up master & system databases and restoring them when necessary supporting production environment.• Run DBCC consistency checks, Rebuild Indexes, Update statistics and Recompile SPs for databases on regular basis.• Writing complex and efficient queries using SQL server joins.• Creating and managing database objects such as tables, views, Indexes, Stored, Procedures, functions and triggers. • Troubleshooting DB performance issue with analysis of Query Execution Plan, Profiler and DMVs