Name: ARUN SINGH KACHWAHA

Email : adyct8@r.postjobfree.com Mobile : +91-969*******

Career Objective

To be part of an organization where the management structure recognizes and rewards loyalty, honesty, hard work and the ambitious nature of an employee by providing growth opportunities and necessary infrastructure that could contribute to the success of the company.

Profile Summary

SQL DBA roles & responsibilities:

Having 2 years of experience as SQL Server DBA in a Production Environment. Primarily working with SQL Server 2019,2017,2016,2014 and 2012 versions. Specific hands-on experience in administrating SQL server activities like Installation, Patching, Backup & Recovery and High Availability technologies.

Installing and configuring the SQL Server 2012, 2014, 2016, 2017 and 2019.

Apply SQL Server patches in standalone and cluster servers.

Creating and administrating the SQL server Database like Data-log file placements, managing the growth parameters and database options.

Verifying and fixing resolving the SQL server blocking issues.

Resolving the disk space issues.

Monitoring and analysing Database server health check on daily basis.

Executing the scripts which are given by the application team with proper approvals.

Expertise in Database backup, Recovery, Restoration and Disaster Recovery Plans.

Experience in user Management activities like adding and managing the permission of users.

Experience in creating, scheduling and troubleshooting the jobs.

Hands on experience on High Availability solutions like Always On.

Performing failover and failback operations in the cluster environment and troubleshooting activities.

Experience with upgrades from SQL server 2008 to 2012, 2014 and 2016,2017 and 2019.

Expertise in Azure SQL database management and security principal’s

Team player willing to share and develop my knowledge and expertise.

Incident Management – Manage services within incident process.

Change Management – Provide support and participate in the change control board.

Problem Management – Provide RCA (Root cause Analysis) with solution.

Professional Experience:

Working as Analyst HCL Technologies Lucknow from 28 May 2021 to till date.

TECHNICAL SKILLS:

Operating System:

Windows Family (2008/2012/2016/2019/2022)

Languages:

T-SQL, Python, PowerShell Scripts, C, Java, HTML & CSS

RDBMS:

MS SQL Server 2008/R2, 2012,2014,2016,2017, 2019, 2022, Azure SQL database and SQL MI

SQL Server Tools:

SSMS, Profiler

Other Tools:

Cherwell, Rubrik, Commvault and Foglight

PROJECT EXPERIENCE

Project:

SC Johnson & Son, Inc

Team size:

8

Role:

SQL Server DBA

Duration:

May 2021 to till Date

Environment:

SQL Server 2019, 2016, 2014, 2012 and 2008 / Azure IaaS/PaaS SQL servers

Roles and Responsibilities:

User and monitoring ticket management and ensuring team’s adherence to SLA.

Working closely with application development and support team to understand their requirements and provide time solutions, for both current and future projects.

Schedule and attend the weekly status meeting with customer

Define and maintain daily check list and as per the best practices defined.

To reduce threat to the environment identified users having SYSADMIN rights and relegate them to the appropriate rights.

Planned phased implementation of security patches in coordination with application team to minimize downtime to end users.

Installation and configuration of MS SQL Server 2012, 2014, 2016 & 2019.

Resolving tickets which include creating and maintaining databases, monitoring disk space, databases integrity, identifying missing indexes, handling blocking.

Scheduling and maintaining jobs.

Recovering database from suspect mode.

Configuring and troubleshooting high availability scenarios.

Updating service packs and Security patches for the servers.

Performing data refresh activities from production to Dev\Test on need basis.

Deploying Production changes.

Working on Azure Cloud stuffs like: Database creation, Grant permission, On-Prem to Azure SQL DB sync setup and Azure VM’s SQL vulnerabilities remediation.

Educational Details:

STANDARD

BOARD

SCHOOL/COLLEGE

PASSING YEAR

PERCENTAGE

B. TECH

DR. APJ ABDUL KALAM TECHNICAL UNIVERSITY

BABU BANARASI DAS ENGINEERING COLLEGE, LUCKNOW

2019

72.01%

INTERMEDIATE

UP BOARD

SRI AYODHYA SINGH MEMORIAL INTER COLLEGE, LUCKNOW

2015

78.2%

HIGH SCHOOL

UP BOARD

SRI AYODHYA SINGH MEMORIAL INTER COLLEGE, LUCKNOW

2013

83.67%

Certification:

Microsoft Certified: AZ-900: Microsoft Azure Fundamentals.

Microsoft Certified: DP-900 Azure Data Fundamentals.

Microsoft Certified: SC-900 Microsoft Security, Compliance, and Identity Fundamentals

Google Cloud Certified - Associate Cloud Engineer

Personal Details:

Date of Birth :

22-Sep-1998

Address :

631/243 Shankar Puri colony Kamta Chinhat, Lucknow 226028 U.P.

Languages Known :

English & Hindi

Gender :

Male

Marital Status :

Unmarried

Nationality :

Indian

Interest :

Playing cricket, Listening to Music and Video Games

Contact this candidate