Harshil Patoliya Email & Phone Number

Ahmedabad, Gujarat, India

I have a bachelor's degree in information technology from Marwadi University, and I use my skills and knowledge to craft compelling narratives that resonate with the target audience and drive engagement. I also help clients optimize their online presence, improve their reputation, and increase their visibility. I deliver solutions that enhance the brand identity and image of my clients. I work with clients across various industries and sectors, from startups to established corporations. I enjoy collaborating with them to understand their goals, challenges, and opportunities. I always strive to exceed their expectations and deliver results that make a difference. If you are looking for somebody who can help you stand out from the crowd and grow your business, please feel free to contact me. I would love to hear from you and discuss how we can work together.

Ahmedabad, Gujarat, India

I am an SQL Server expert with extensive experience in testing, optimizing, migrating, patching, and maintaining complex databases. I use advanced tools and techniques to ensure high performance, availability, and integrity of the data. I work closely with client IT/DBA teams and application developers to provide them with the best solutions and support. I also automate and monitor various database tasks to improve efficiency and reliability.

Ahmedabad, Gujarat, India

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

Ahmedabad Area, India

This profile was related to improving performance of the application from all the possible aspects impecting user experience.Most commonly analyzing database queries and tuning performance of the system. Working on indexes and suggesting best maintenance plans to clients hosting their servers. I used to work with End Users/IT/DBA providing them the best solution to improve application experience from front end and back end. This involved working with small to large databases hosted on single to multiple servers.Improve performance in real-time with implementing indexes and maintenance plans and reporting queries to developers after testing it on local system.

Ahmedabad Area, India

Handling listed data on Amazon.uk as well as on eBay.co.uk + Handling customer queries regarding products.

Bachelor’S Degree, Information Technology, 7.36

Activities and Societies: Seminar on Social Media Services, Project on Online Examination System Visit Planner of Industrial Visit.

Education record