NAME: SARTHAK KUMAR MOHAPATRA

Mobile - +91-760******* / 797-***-****

Email: ad37yj@r.postjobfree.com

Linked In: linkedin.com/in/sarthak220599/

Professional Summary

Have 2.5 years of experience in SQL DBA working on all the aspects of DBA Monitoring, Installation, Configuration, High Availability, Disaster Recovery, Mirroring, Log Shipping, Clustering, Alerts, Operators and Jobs. Working on Security (Create Log ins, Users and Roles). TECHNICAL SKILLS

Database : SQL Server 2008/2008R2/2012/2014/2016/2017/2019 Operating systems : Windows Server 2003/2008/2008R2/2012/2016 Ticketing Tools : BMC Remedy, Service Now

Backup Tools : EMC Networker Tool

Monitoring Tools : SQL Diagnostic Manager, SCOM

Domain/AD Knowledge : Active Directory, DNS

Cloud experience : Azure, AWS and GCP Services, PaaS, laaS Reporting : SSRS (SQL server Reporting Services) – Enterprise Reporting

(OLAP) server : SQL Server Analysis Services (SSAS) Integration (ETL) Tools : SQL SERVER Integration Services (SSIS) DR Configuration : Azure Cloud, Log Shipping, Mirroring, Clustering, Transactional Replication Certification: -

Associate Cloud Engineer (GCP)

CLF-C02: AWS Certified Cloud Practitioner

Experience summary: -

Currently associated with HCL TECHNOLIGIES, BANGLORE from last 2.5 years. PROJECTS SUMMARY

Project #1

Client : UNILEVER

Role : MSSQL DBA

Environment : MS SQL Server 2008/2008R2/2012/2014/2016/2017/2019. Organisation : HCL TECH, Bangalore

Roles & responsibilities

• Installation, configuration and upgrading of SQL Server 2000/2005, Services packs and Hot fixes.

• Upgrading SQL Server 2008 to SQL Server 2014, 2016 etc (Side by side upgrade).

• Providing the On-Call support during business hours.

• Daily checking the tickets assigned and resolve the tickets depends on the Priority levels within the SLA.

• Experience in Installing, Configuring, Monitoring and troubleshooting SQL Server 2005, 2008, 2008 R2

,2012,2014, 2016,2017, 2019.

• Working Experience in Database Backup, Restoration, and Recovery Database Maintenance planning.

• Good experience in moving user database & system database files from one Location to another Location.

• Experience in configuring and maintaining Log-Shipping and troubleshooting the issues.

• Strong experience in configuring and maintaining Mirroring Technology and fail-over.

• Experience in implementing different types of Replication modes like Snapshot and Transactional.

• Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.

• Experience in Migration SQL Server 2008 to 2016/2019, to new versions and applying service packs and hot fixes.

• Monitoring Daily backup jobs and automation of daily restores of development databases.

• Monitoring the Disk Space of all the Servers.

• Configuring and Monitoring log shipping and Database mirroring on Disaster recovery Servers.

• Database snapshot creation for the synchronized databases for Reporting Purposes.

• Capturing the events using SQL profiler for poor performing queries, deadlocks and blocks and studying the execution plans and fine tuning the applications.

• Automating Server-Side Tracing in SQL Server and identifying SQL Server performance issues, by analysing Profiler output.

• Disaster Recovery setup and testing it in regular intervals.

• Reporting and resolving serious SQL Server alerts.

• Implement and Maintain database Security (Create and maintain users and roles, assign privileges)

• Resolving escalated and complex problem within SLAs, Establishing user acceptance performance bottom line.

• Working with workflows for any changes on staging and development environment.

• Involved in the internal and external audits and participating in the business continuity plans of the company.

• Expertise in supporting and implementing Disaster Recovery (DR) strategies for SQL Server databases.

• Proficient in designing, implementing, and maintaining database backup and recovery procedures.

• Skilled in configuring and managing SQL Server Always On Availability Groups and Failover Clustering for high availability and disaster recovery.

• Experienced in setting up and managing database mirroring and log shipping for disaster recovery purposes.

• Knowledgeable in implementing and maintaining database replication for disaster recovery and data distribution.

• Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.

• Database consistency checks using DBCC Utilities.

• Strong experience in Indexes like Clustered and Non-Clustered indexes.

• Experience in Performance Tuning (Server level and Query level) and trouble shooting.

• Good knowledge on cluster architecture and involved in failover activities.

• Automated SQL Dashboard to get the Service health details, CPU & Memory Details, Space check (TempDB, Data and Log files), Blockage & locks, Backup Status – Full backup, Log Backup

• Providing 24x7 technical database support for SQL Database systems.

• Good interpersonal skills, committed team player with team driven skills. Academic: -

Bachelor’s Degree (BTech) from Parala Maharaja Engineering college, Berhampur, Odisha . Personal Details -

Date of Birth - 22-05-1999

Languages Known - English, Hindi and Odia

Contact this candidate