Database Management

Harshil Patoliya

Database Engineer
Database Administrator
Database Specialist
Microsoft SQL Server
MySQL
SQL
eClinicalWorks
Tena Care

-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.

Partner With Harshil
View Services

More Projects by Harshil