Database Management
Contact for pricing
About this service
Summary
-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.
What's included
Database Management
-Conducted tests with complex workloads and data shapes to expose potential bottlenecks and failure points. -Creating indexes, execution plans, and query stores to analyze 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 every day to ensure stability on the 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 the provided timeline. This includes databases with sizes 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 of around 15000+ databases/clients. -Configuring disaster recovery database servers and their maintenance. Implemented DR for 150+ Database Servers. -Creating the best possible backup plan for different clients and following industry-level standard backup plans for high availability of systems with 0 data loss in case of failures/corruption. -Recovering all databases on a daily basis and running DBCC to validate data integrity, without interrupting production databases. -Working with the Application Development/Application Installation/Application Migration Team to help them access required databases with required user administration and security roles. -Working on automating Database creation/backup/restore/upgrade within a timely manner and setting up required alerts to monitor health.
Recommendations
(5.0)
Client • Mar 3, 2024
Recommended
Harshi's extensive grasp of the business proved instrumental in creating a highly effective brand for my wife's business. His keen attention to detail is commendable, and he successfully completed the project on schedule through effective communication and prompt responses. Highly Recommended.
Client • Mar 2, 2024
Recommended
I wanted to express my sincere gratitude for Harshil’s exceptional assistance in designing the logo for our cricket team. His creativity and attention to detail truly brought our vision to life, capturing the essence of our team.
Skills and tools
Work with me