Harshil Patoliya
-Conducted tests with complex workloads and data shapes to expose potential bottlenecks and failure points.
-Creating indexes, execution plans, query store to analyse and improve SQL performance.
-Implementing standard index maintenance plan.
-Working with SQL Sentry to monitor System performance.
-Memory pressure counters checks such as PLE/Memory Grants/IO Reads/Compilations and Recompilations
-Working with client IT/DBA to configure daily log shipping using Azure Blob containers and monitoring it everyday to ensure stability on secondary system.
-Configured around 400+ Log Shipping Clients and daily system monitoring.
-Installing and configuring SQL Server 2017 on Azure and local cloud systems with industry level standards.
-Configuring cluster as well as Always on Functionality.
-Migration of SQL 2012 to 2017 and 2017 to 2019 with as low as 2 hours of downtime of 100+ clients within provided time line. This includes databases with size 2 GB to 4 TB.
-Planning, testing and execution of latest windows patches deployment on 200+ Servers including Active/Passive and Primary/Secondary/DR Database Servers.
-Execution of patching plan within 1 month on 200+ Database servers consisting around 15000+ databases/clients.
-Configuring disaster recovery database servers and it's maintenance. Implemented DR for 150+ Database Servers.
-Creating best possible backup plan for different clients and following industry level standard backup plan for high availabilty of systems with 0 data loss in case of failures/corruption.
-Recovering all databases on daily basis and running DBCC to validate data integrity, without interrupting production databases.
-Working with Application Development/Application Installation/Application Migration Team to help them access required databases with require user administration and security roles.
-Working on automating Database creation/backup/restore/upgrade within timely manner and setting up required alerts to monitor health.