Rakesh Mandapuri

WORK HISTORY

EDUCATION

ABOUT RAKESH MANDAPURI

Extensive experience in installing, configuring, monitoring, and troubleshooting SQL Server. · Providing 24/7 on-call support in the domain, production and pre-production instances of SQL Server 2008R2, 2012, 2014, 2016, 2017, and 2019 as standalone, clustered, with log shipping, mirroring, replication, and Always On. · Attending calls with client and change management on daily basis. · Performed Daily Health checks and troubleshoot it. · Worked on Change activities and script executing tasks. · Worked on SSIS package job creation and if job fails investigate find the root cause · Worked on SSRS reports. · Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of user support. · Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes. · Resolving the Disk space issues and finding the root cause and permanent fixes. · Scheduled and maintained routine jobs, tasks, alerts and maintenance Plans. · Using Performance Monitor/Profiler to solve long running queries. · Hands-on experience with high availability solutions always on. · Configuring and maintaining all types of Database Backups and Recovery operations. · Configuring and monitoring SQL Jobs and doing Job Failure Analysis · Have good exposure in SQL Server Failover Clustering. · Providing 24/7 technical database support for SQL database production systems. · Experience in supporting and managing multiple Production, UAT, Staging & Development servers. · Identifying and resolving blocking and deadlock issues by using system stored procedures, DBCC, Activity Monitor, and Profiler. · Identifying and resolving fragmentation and performance issues. · Weekly Refreshing Database from Production to Test Environment. · Installing and configuring the SSRS and working with Security in SSRS. · Good Experience in Ticketing tools like Service-now.