Krunal Patel
Ahmedabad,GJ
Summary
A seasoned Sr. Database Administrator with a proven track record of 10+ years, I excel in leading database administration teams and optimizing large-scale databases for high availability and disaster recovery. Skilled in PowerShell scripting and team management, I've successfully migrated databases to Azure/AWS, enhancing system efficiency and reliability.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Sr. Database Administrator
Advantmed India LLP
01.2023 - Current
- Leading team of Database Administrators
- Administering databases of 23+TB size
- Maintain KPIs & KRAs
- Install, Configure & Troubleshoot MSSQL Server
- Optimize TSQL & Stored Procedures
- Configure, Monitor & Troubleshoot High Availability & Disaster Recovery Solutions to achieve maximum RTO & RPO
- Conduct quarterly training with Development team for writing effective TSQLs
- Provides 24 X 7 Support
- Actively participating in defining database team's policy for release automation
- Write powershell script to automize alerts, backup & reporting for monitoring purposes
- Familiar with RedGate & SQL Diagnostics monitor for monitoring the SQL Server databases
- SQL Server Patching
- Migrating SQL Server databases from OnPremise to Azure/AWS
- Set up and controlled user access levels across databases to protect important data.
- Document incidents & Root Cause Analysis
Deputy Technical Specialist
Hexaware Technologies Limited
01.2022 - 01.2023
- Involved in MSSQL transition from another vendor to Hexaware
- Leading MSSQL track and present weekly activities to client
- Taking initiative to improve the security parameters for client
- Leading team of three jr. MSSQL DBA
- Providing 24 x 7 support Daily operation support
Database Administrator
Advantmed India LLP
10.2020 - 01.2022
- Manage SQL Server databases
- Configure and maintain database servers and processes
- Monitor system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide 24x7 support for critical production
Database Administrator
Stridely Solutions
04.2020 - 10.2020
- Provide 24 x 7 support
- Decision making for Database Design & Data Modeling
- Manage extensive support for Production, Development & User Acceptance Server for MSSQL as well as Oracle Database Administration.
- Proactively monitor resource utilization and act accordingly to avoid unwanted catastrophe.
- Configured Always-On High Availability & Disaster Recovery solution for MSSQL.
- Actively monitor Oracle & MSSQL Database performance reports using OEM & Solar Wind DPA.
- Design & Implement Data Warehouse in Oracle Autonomous Database.
- Design Backup Policy for high volume database. Troubleshoot regular issues with MSSQL & Oracle server.
Database Administrator
Etech Global Services
10.2018 - 09.2019
- Physical and Logical database design.
- Provides production support for 24 X 7.
- Setting up alerts for several workloads and poor performing queries
- Overall Database, Index and Query Optimization
- Configure, Maintain and Troubleshooting for Windows Failover Clustering
- Configure and troubleshoot Database Mirroring, Log Shipping and Transactional Replication.
- Configuration, Monitoring and troubleshoot obstacles with SQL Server High Availability and Disaster Recovery(HADR).
- Setting up traces for historical user queries for finding root cause analysis.
- SQL Server Reporting Services configuration and deployment
Database Administrator
Excellence Infocom
06.2017 - 09.2018
- Providing Production 24 x 7 Support.
- Configuration, Installation & Administration of SQL Servers.
- Configuration SQL Server HADR solution (Always-On) with 1 Primary & 3 Secondary Nodes.
- Monitor Always On health & Production SQL Server Databases.
- Configuration, Monitoring & Troubleshooting of SQL Server Database Mirroring, Log Shipping & Replication.
- Experience in maintaining up to 5 TB of Databases.
- Monitoring SQL Server using Data Dog, Microsoft Azure Insight & Network Monitoring using PRTG.
- Participate in internal SQL Development for DevOps team, to create a internal monitoring tool.
- Developing Internal SSIS Packages for SQL Server Performance Counters capture.
- Taking initiatives in Performance Tuning. 2017-06 - 2018-09
- Root Cause Analysis of any alert, error with SQL.
- Monitor Services Broker Queues & Troubleshooting it.
- Query Optimization & Index Optimization.
- Execute scripts on production server provided by developers.
- Creating Roles in Production Environment & Assigning it to Appropriate users according to the requirements.
Jr. Database Administrator
OmniISM Technologies Private Limited
10.2015 - 06.2017
- Installation, Configuration & Administration of SQL Server
- Installation & Configuration of SSRS and SSIS
- Configuration, Monitoring & Troubleshooting of SQL Server Database Mirroring,Log Shipping and Replication.
- Actively involved in Production Support for Application and Database.
- SQL Server Database Optimization, Query Tuning, Setup SQL Jobs for Daily and Weekly Database Maintenance for Standard & Enterprise Editions, and by using Windows Task Scheduler for Express Edition.
- Experience in supporting very large and Highly Transactional Database & Troubleshooting various performance bottlenecks on different environments (Production, DEV, UAT, Sandbox).
- Overall SQL Server Performance Tuning.
- Provided Support for 28 production SQL Servers including Enterprise, Standard and Express editions.
- Setup performance log capture using windows task scheduler & perf. Logs.
- Monitoring Servers using SQL Server Activity Monitor, Windows Performance Monitor, Resource Monitor and PRTG for Network Monitoring.
- SSRS Report development & Optimization.
- Developed many SSIS packages for large data 2015-10 - 2017-06 transformation.
- T-SQL Development for Application including Stored Procedures, and Triggers.
- Configure SQL Server alerts using WMI events, performance counters and monitored it pro-actively.
- Developing SQL Script & Data Analysis for Data Migration.
- Capturing SQL Server statistics using DMVs.
- Actively Participated in Architecting a Backup Policy & Capacity Planning for Database Servers.
- Involved in Overall all the Database & BI Activities.
Jr. Data Analyst
Kraff Software Private Limited
01.2015 - 10.2015
- Writing scripts to download data from MLS servers in Java Programming Language.
- Writing scripts to process downloaded data and store them into MySQL database.
- MySQL Database installation & configuration
- Monitor Database backups on regular basis
- Setup Cron Jobs to automate the data import & cleansing process.
Education
Bachelors of Engineering - Computer Engineering
Government Engineering College
Modasa07-2014
H.S.C - Science
Asarawa Vidhyalaya
Ahmedabad03-2010
S.S.C -
R.S.P.M. Sarva Vidhyalaya
Kadi, Mahesana03-2008
Skills
- Database Administration
- High Availability
- Disaster Recovery Solution
- Performance Tuning
- Powershell Scripting
- Team Management
- Azure/AWS database Administration/Migration
- SSIS
- SSRS
- SQL Server Monitoring
- Troubleshooting
Certification
Oracle Certified Professional - Oracle Database 1og Administration Oracle University
Oracle Certified Associate - Oracle Database 1og Administration Oracle University
Oracle Certified SQL Professional Oracle University
Certification in .NET C-DEC
Certification in Core-Java C-DEC
Certification in C++ C-DEC
Certification in C C-DEC
Oracle Cloud Infrastructure Foundations 2021 Certified Associate Oracle
Languages
English
Advanced (C1)
Hindi
Advanced (C1)
Gujarati
Advanced (C1)
Timeline
Sr. Database Administrator
Advantmed India LLP
01.2023 - Current
Deputy Technical Specialist
Hexaware Technologies Limited
01.2022 - 01.2023
Database Administrator
Advantmed India LLP
10.2020 - 01.2022
Database Administrator
Stridely Solutions
04.2020 - 10.2020
Database Administrator
Etech Global Services
10.2018 - 09.2019
Database Administrator
Excellence Infocom
06.2017 - 09.2018
Jr. Database Administrator
OmniISM Technologies Private Limited
10.2015 - 06.2017
Jr. Data Analyst
Kraff Software Private Limited
01.2015 - 10.2015
Bachelors of Engineering - Computer Engineering
Government Engineering College
H.S.C - Science
Asarawa Vidhyalaya
S.S.C -
R.S.P.M. Sarva Vidhyalaya
Similar Profiles
Jitendra J. SondarvaJitendra J. Sondarva
Technical Lead/ Technical PM/ Technical Architect at Advantmed India LLPTechnical Lead/ Technical PM/ Technical Architect at Advantmed India LLP
Piyush NayakPiyush Nayak
Process Associate at Advantmed India LLPProcess Associate at Advantmed India LLP
Sandeep DeySandeep Dey
Senior HR Business Partner at Advantmed India LLPSenior HR Business Partner at Advantmed India LLP
RAJAT VIMALRAJAT VIMAL
Management Trainee at Adani Wilmar LtdManagement Trainee at Adani Wilmar Ltd
Prasenjeet DasPrasenjeet Das
Territory Head at Eureka Forbes LTD.Territory Head at Eureka Forbes LTD.