Kota Support Engineer
Resume:
Shivam Kumar Sharma
Mob: +91-851*******
E-Mail: ***************@*****.***
Role: Senior SQL Server DBA/Azure SQL Cloud DBA/L3 Support.
Total Experience: 8.5 Years
Career Objective:
Seeking a challenging position which will permit me to use and enhance my professional skills in a progressive and dynamic organization. Ability to improvise, multitask, troubleshoot, take ownership, and juggle multiple complex projects simultaneously.
Professional Synopsis:
Currently associated with Navisite India Pvt. Ltd, Gurgaon
Have around 7+ years of SQL Server DBA related experience.
Well versed with RDBMS concepts in SQL Server.
Having around 2 years of good experience in Azure and MYSQL database.
Knowledge of keeping abreast of new technologies, methods, and techniques to understand how they might be applied to the client's environment.
Working on Service-Now Tool and following the ITIL process for client requests.
MCP (Microsoft Certified Professional) certified (Cleared 70-764 Exam) in 2018
Professional Experience Details:
Navisite India Pvt Ltd, Gurgaon
Period: - Jan 2020 to till Date.
Designation: - Senior Consultant (L3+ support)
Roles and Responsibilities:
Working on 100+ customers simultaneously and providing them L3 and L4 support.
Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008, SQL Server 2012, SQL Server 2016 and SQL Server 2017
Working on Service-Now tool and working on client requests on basis of incidents, Service Requests and Change Requests and following the ITIL process.
Troubleshooting issues related to SSIS and SSRS.
Handling the task of managing database structure, storage allocation, database access, roles, users and privileges on Production and Non-Production database servers.
Daily activities include monitoring Databases, checking error logs, checking the log file size and free space in the data drives, checking Index fragmentation and connectivity of the databases.
Upgrading/Migrating the databases from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 to 2016.
Provide database support such as User permission management, backup/restore activities, Index fragmentation, statistics updates, and database performance related issues on client-server environment.
Creating and Managing clustered indexes and non-clustered indexes to increase the performance of database queries. Knowledge in Performance Monitoring & Optimization of Database objects. Knowledge of execution plans and DMV’s used for Performance Monitoring.
Working knowledge of various Sql Server tools like Sql Server Profiler, Activity Monitor, Sql Server Agent.
Knowledge and understanding of advanced features like Replication, Mirroring, Log Shipping, Clustering and Always ON availability group.
Delivering and implementing the project as per SLA. Holding review meetings to ensure timely completion and delivery of the project to the client
Managing SQL databases on Azure.
Assist team members in troubleshooting issues and on-call responsibilities for Production and Non-Production MS SQL Server database.
HCL Technologies, Noida
Period: - Nov 2016 to till Dec 2019. (3 years, 2 Months)
Designation: - Senior Specialist (Senior SQL Server DBA/Shift Lead)
Roles and Responsibilities:
Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008, SQL Server 2012 and SQL Server 2016
Working on Service-Now tool and working on client requests on basis of incidents, Service Requests and Change Requests and following the ITIL process.
Handling the task of managing database structure, storage allocation, database access, roles, users and privileges on Production and Non-Production database servers.
Daily activities include monitoring Databases, checking error logs, checking the log file size and free space in the data drives, checking Index fragmentation and connectivity of the databases.
Create Jobs, Alerts and Maintenance Plans.
Upgrading/Migrating the databases from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 to 2016.
Provide database support such as User permission management, backup/restore activities, Index fragmentation, statistics updates and database performance related issues on client-server environment.
Creating and Managing clustered indexes and non-clustered indexes to increase the performance of database queries. Knowledge in Performance Monitoring & Optimization of Database objects. Knowledge of execution plans and DMV’s used for Performance Monitoring.
Working knowledge of various Sql Server tools like Sql Server Profiler, Activity Monitor, Sql Server Agent.
Knowledge and understanding of advanced features like Replication, Mirroring, Log Shipping, Clustering and Always ON availability group.
Delivering and implementing the project as per SLA. Holding review meetings to ensure timely completion and delivery of the project to the client
Managing SQL databases on Azure.
Assist team members in troubleshooting issues and on-call responsibilities for Production and Non-Production MS SQL Server database.
Cybage Software Pvt. Ltd., Pune.
Period: - Sept 2015 to Nov 2016. (1 year 2 months)
Designation: - Production Support Engineer (SQL Server DBA)
Roles and Responsibilities:
Handling the task of managing database structure, storage allocation, database access, roles, users and privileges on Production and Non-Production database servers.
Handling DB version release for Production and Non-Production Environment.
Daily activities include monitoring Databases, checking error logs, checking the log file size and free space in the data drives, checking Index fragmentation and connectivity of the databases.
Create Jobs, Alerts and Maintenance Plans.
Upgrading/Migration the databases from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 to 2012.
Provide database support such as User permission management, backup/restore activities, Index fragmentation, statistics updates and database performance related issues on client-server environment.
Creating and Managing clustered indexes and non-clustered indexes to increase the performance of database queries. Knowledge in Performance Monitoring & Optimization of Database objects.
Handle space issues on Production and Non-Production database server.
Setup and configure SMTP for database mail.
Assist team members in troubleshooting issues and on-call responsibilities for Production and Non-Production MS SQL Server database.
EClinicalWorks India Pvt. Ltd. - Ahmedabad. (Electronic Medical Record (EMR) & Practice Management (PM) based Company)
Period: - October 2012 to September 2015 (2 years 11 months)
Designation: - Software Specialist (Database Support Engineer)
Roles and Responsibilities:
Involved in a Shared Services Delivery model, supporting multiple customer with different business requirements and strategies over same technology and managing end to end support for it including Client Management, Patch Management, SQL server Deployment and Troubleshooting.
Excellent Communication and Client Handling.
Strong work ethics, Self-Motivated, passionate to learn and growth Oriented, comfortable with working in teams.
To setup & Configure eClinicalworks software on cloud environment OR Client/Server environment and Locally Hosted Environment.
To move eClinicalworks software from Client/Server to Cloud environment.
Configuration of databases on SQL Server 2008 / 2012, MySQL.
Tomcat Service configuration.
Conversation of MySQL database engine from MyISAM to InnoDB.
Conversation of MySQL to MSSQL database and vice versa.
Mock conversion of database to know the time frame during actual conversion.
Implementation of EMR product on SAAS as well as on client server by using various customized tools and utilities.
Backup Design & Management. Performance tuning on Database/System. Patch/upgrade Management for Database on Server.
Day to Day Troubleshooting with Application. Space/device Management.
Configuring and Managing Production as well as Test database. Creating new databases.
Technical Skills:
Microsoft Office: Microsoft Word, Excel, PowerPoint and Outlook.
Databases Primary: MSSQL server 2008/2008R2, MSSQL server 2012, MSSQL 2016.
Domain Knowledge: US HealthCare.
Tools Knowledge : SQLyog, SSMS, WinSCP, SQL Server Data Tools, Sql Server, Activity Monitor, SQL Profiler.
Scholastics:
2012 B.TECH in Computer Engineering from Rajasthan Technical University, KOTA with 75.01%
2008 Senior Secondary from C.B.S.E., New Delhi with 71.20 %
2006 Secondary from R.B.S.E. Ajmer (Rajasthan) with 77.00 %
Certifications:
MCP certified (Cleared 70-764 Exam)
Personal Details:
Name
Shivam Kumar Sharma
Email id
***************@*****.***
Location
Noida
Mobile
Current Employer
Navisite India Pvt Ltd., Gurgaon
DOB
04-02-1990
Languages Known
English and Hindi.
Declaration:
I do hereby declare that the particulars of information and facts stated here in above are true, correct, and complete to the best of my knowledge and belief.
PLACE: Gurgaon Shivam Kumar Sharma
Contact this candidate