Name: Utkarsh Kumar
E-mail: utkarshkumarsrv101990@gmail.com
Mobile: 08210773122
Summary:
Almost 6.8 years of experience as Microsoft SQL Server Database Administrator
a strong work ethic combined with a commitment to excellence in all projects
undertaken. A team player, working effectively with management, developers
and users. A broad range of experience in all aspects of Database
Administration.
Professional summary:
6 years of experience in Database Administration for very large and complex
databases in SQL Server 2017, SQL Server 20016, 2014, 2012,.
Having Experience on Data center servers and handling 5TB databases.
Installed and administered Four-Node cluster Active/Passive on Microsoft
Windows Server 2012 Enterprise Edition.
Large-scale database Migration and Upgradation from SQL server 2012, 2014
and 2016.
Involved in assisting SQL Server prime customers with Configuration,
Administration, Implementation and Trouble-shooting for Business work flow
with Log Shipping mechanism
Performed Database Refresh tasks from production to Development and
Staging Servers
Database Performance Tuning with the help of Performance dashboard.
Rebuilding / monitoring the indexes at regular intervals for better performance.
Recovering the databases from backup in disasters. Implementing Point-In-Time
Recovery solutions.
Involved in trouble shooting and fine-tuning of databases for its performance
and concurrency.
Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine
Tuning Advisor (DTA).
Expertise in work on Failover cluster to minimize business downtime if any
issue occurs critically.
Experience of Using DMVs, Performance dashboard, Mirroring, database
snapshots and tracking Performance Counters.
Knowledge in Always-On Availability Groups (AAG) and HA/DR Setup and
Configuration
Responsible for monitoring and making recommendations for performance
improvement in hosted databases.
Index modification, file group modifications, and adding scheduled jobs to re-
index and update statistics in databases.
Hands-on experience managing MySQL 5.7/8.0 databases in production and
development environments.
Configured and maintained MySQL Master-Slave Replication for high availability and
read scalability.
Performed backup and restore operations using mysqldump, and binary logs for
disaster recovery.
Enabled and monitored slow query logs to identify and optimize long-running queries.
Implemented MySQL connection pooling to improve application performance and
reduce overhead.
Monitored database health, performance tuning, and resource optimization using
MySQL Workbench and custom scripts.
Migrated databases from on-premises servers to GCP Cloud SQL for MySQL, including
schema and data.
Managed user privileges, roles, and applied security best practices across
environments.
Worked on PostgreSQL 12/13 for managing OLTP and reporting workloads.
Performed database administration using tools like pgAdmin, psql, and configuration
files.
Experience with PostgreSQL backup and restore using pg_dump, pg_restore, and
continuous archiving.
Tuned PostgreSQL queries using EXPLAIN ANALYZE and customized memory and auto
vacuum settings.
Managed roles, privileges, and monitored logs for auditing and performance issues.
Migrated SQL Server workloads to PostgreSQL using tools like pgLoader and AWS DMS.
24 X 7 Production Database on Call Support.
Career Highlights:
Worked as a DBA for ECIFM Solution Private Limited
Worked as a Technical Skills:
Microsoft SQL Server 2017/2016/2014/2012/Enterprise, Standard and Express
Editions, Clustering, Always On, Mirroring, Replication, SSMS, SQL profiler,
Performance Monitor.
Academic credentials:
Bachelor of Engineering in Computer technology from Nagpur University,
Nagpur.
Work Experience Details:
Jan 9th 2023 to till now Senior SQL DBA at MYND INTEGRATED SOLUTION PRIVATE
LIMITED
October 22nd, 2021, to 14th march as Senior SQL DBA at ECIFM Solution India Limited.
August 2018 to 21st 2021 Oct as SQL DBA Future Focus InfoTech Private limited.
July 2017 to August 2018 as a SQL Database Administrator for VPS (Value Point
System) Ltd, Chennai
February 2017 – June 2017 date for Collabra as a Network Engineer.
Project Experience:
Company: ECIFM solution Limited
Headquarter: San Ramon, California
Place: Gurugram Date: Oct 22nd 2021 to 14th
March
Role: Senior Database Administrator
.
Monitoring data activities like database status, logs, space utilization, locks and long
transactions.
Created automation of the day-to-day operations, critical SQL server alerts and
repetitive tasks.
Setup and maintained Log Shipping between various environments.
Responsible for installing, configuring and maintaining SQL failover clustering for
production environments.
Migrated SQL server 2012, 2014, 2016 in Microsoft Windows Server 2018 R2 and
2012 Enterprise Edition.
Large-scale database Migration and Upgradation from SQL server 2014 and 2016.
Database Performance Tuning with the help of Performance dashboard.
Rebuilding / monitoring the indexes at regular intervals for better performance.
Recovering the databases from backup in disasters. Implementing Point-In-Time
Recovery solutions.
Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine
Tuning Advisor (DTA).
Client: Aditya Birla Fashion and Retails Pvt Ltd. Place:
Bangalore
Role : Database Administrator Duration:Feb 2017 to Oct 21st
2021
As a production L2 support, responsible for resolving incident tickets escalated from
L1 support and handling critical incidents (Sev1, Sev2 high).
Responsible to provide 24x7 DBA & Production support for over 1400 SQL Server
databases including retail shop marketing along with Datacenter servers which are
users by company applications
Responsible for disaster recovery and high availability solutions.
Monitoring data activities like database status, logs, space utilization, locks and long
transactions.
Created automation of the day-to-day operations, critical SQL server alerts and
repetitive tasks.
Setup and maintained Log Shipping between various environments.
Deciding whether clustering, log shipping, mirroring, Replication etc. are the right fit
to solve the business problem
On call troubleshooting for SQL server services outage.
