M PAVAN KUMAR

Azure SQL DBA

Phone: (M) +91-701******* Email: adl0bg@r.postjobfree.com

OBJECTIVE

To achieve a challenging position in design, development maintenance and support of software with state-of-the-art technology where my analytical problem solving, communication, interpersonal technical, managerial skills and application can be utilized to benefit of the organization as well as to increase and enhance my knowledge.

PROFILE SUMMARY

Overall 2 years of experience as Azure SQL & SQL Server Database Administrator.

Administering a SQL Server & Azure SQL Database Infrastructure on Azure

Experience working with production in 24 x 7 environment on ITIL & Agile methodology.

Experience in configuration of Window Cluster, SQL Cluster & Always on for High availability.

Experience in Configuration of Log-Shipping, Mirroring, and Replication across different environment.

Extensive Experience in installation, configuration applying patches and administration of MS SQL Server.

Design & Implemented comprehensive Backup Plan & Disaster Recovery Strategies.

Migrating the SQL Server databases and instances from lower version to higher version.

Troubleshooting the backup failures and recovering databases from the point of crash.

Fixing the orphan users and allow the users to access the databases.

Granting and Revoking Permission to/ from the Users.

Configuring and Maintaining backup according to the strategy and its retention.

Performing Maintenance tasks like rebuilding/reorganizing indexes, update statistics and checking database integrity on regular intervals..

Moving the System and user databases from one location to another location.

Identifying and resolving blocking and deadlocking issues.

Configured Log Shipping, Mirroring and AlwaysOn as a High availability/Disaster Recovery.

Configured Replication (Snapshot, Transactional, Merge & Peer-Peer Replication)

Having experience in installing SQL server 2005, 2008, 200R2/2012 in cluster environment.

Checking fragmentation of indexes (Rebuild/Reorganize) on a weekly basis.

Experience in user databases detach and Attach as per downtime.

Automation and configuration management through PowerShell..

Configuring Database mail and creating operators and alerts for the SQL Agent Job failures.

Creating and maintaining the indexes on the tables and performing Re-build/Re-organizing indexing to improve the performance.

Troubleshooting blockings, deadlocks and fixing them by adding permanent fixes.

Troubleshooting the disk space issues and handling the database file growth settings to make assure the capacity utilization.

Running the maintenance activities like update-statistics and DBCC CHECKDB at the time of performance issues.

Good experience in performing the Log Shipping and Mirroring in Production environment.

Troubleshooting slow running queries.

Having Knowledge in configuring Windows Clustering on VM ware virtual tool.

Knowledge with ITIL Process involved Incident Management, Problem Management and Change Management.

Having Knowledge on MYSQL level 1.

Responsible for providing 24x7 supports for production SQL Server database.

EMPLOYMENT SUMMARY

Working as SQL Server DBA with HCL Technologies, Noida from June 2019 to till date

TECHNICAL SKILLS

RDBMS

MS SQL SERVER 2000/2005/2008/2012/2014/2016/2017/SQL Azure

Operating System

WINDOWS 2000/2003/2008/2008R2/2012

Programming Languages

T-SQL, Powershell

SQL Tools

Profiler, DTA

ETL Tools

SQL Server Integration Services (SSIS),

Reporting Tools

SQL Server Reporting Services (SSRS)

Other Tools

Commvault, Idera, Red gate SQL Monitor, Perfmon, Remedy, Service Now

EDUCATION AND CERTIFICATIONS

Pursued B.SC from SK University in the year of 2019

AZ900 – Azure Fundamentals

ITIL V3

WORK EXPERIENCE

1.Disney, USA (Jun 2019 Till Present )

Database Administrator

Walter Elias Disney was an American entrepreneur, animator, writer, voice actor and film producer. A pioneer of the American animation industry, he introduced several developments in the production of cartoons

Key Responsibilities

Database Administration using MS SQL Server, SQL Azure

Monitoring Disk spaces on all the servers.

General Health of the servers to identify Bottlenecks.

Involved in up-gradation of SQL Server Databases (2005/2008/2008R2)

Installed SQL Server 2008, 2008R2, 2012, 2014, 2016 and 2017.

Performing Database maintenance activities like Backups, Restoring, Re-indexing etc.

Automation of alerts by configuring Database Mail.

DB health checks & proactive measures using DBCC/DMV utilities.

Configured Linked Servers 2008/2008R2/2012

Creating customized jobs to track database growth, blockings & long running queries.

Managing Windows/SQL Cluster environment (Active/Active and Active/Passive).

Involved in transferring the logins between two production servers using transfer login script.

Configuring, maintenance and troubleshooting Database Mirroring.

Configuring, maintenance and troubleshooting Log shipping.

Ensuring high availability of the databases by exploiting the replication.

Configuring and maintaining SSIS Packages.

Analyzing T-SQL queries and its execution plan to identify missing or unused indexes.

Involved in recovery of corrupted database (Suspect DB)

Creating Monthly reports to the customer about the status of the databases.

Worked on Various Issues on SQL Server ranging from Installation\Uninstallation of components, Service Packs, hot fixes, disaster recovery’s, high availabilities & etc.,

Trouble Shooting Service Pack Up gradation Failures

Configuring AlwaysOn and customizations in DB cluster with a standalone DB.

Configured AlwaysOn Groups in Synchronous & Asynchronous Modes.

Incidents are acknowledged and resolved within the time specified.

Recovering the databases from backup in disasters and effective implementation of point in time recovery procedures

Performed regular DBA jobs like Backups, Restores, Point in time Recovery, Database Consistency Check, Index Maintenance and Performance Tuning.

Managing space for data files and log files.

Maintaining the database consistency with DBCC at regular intervals.

Scheduling jobs and alerts using SQL Server Agent to automate the routine tasks.

Monitor the status of maintenance jobs.

Performed Database Backups for Production, Test and Development Servers and Restored Backups onto Test Servers.

Login and user management: Adding logins, roles, and groups to the MS SQL Server and maintaining proper security procedures.

Installation of SQL 2000 and Service packs.

Maintained High Availabilities such as Log Shipping and Replication.

Installing latest service packs and patches on production server.

Supported 24*7 production servers and solved all kinds of issues.

Creating users and giving appropriate permissions.

Monitor the status of maintenance Jobs.

Maintained Database integrity, scan density of index and defrag index and re-build new index for better performance of the servers.

Determine the problems such as dead lock, blocking and fix the problem.

Using profiler and performance tuning to get better performance.

Determine the problems such as dead lock, blocking and fix the problem.

Installing latest patches, cumulative updates service packs and hot fixes on production server.

Configuring and Maintaining High Availabilities such as Log Shipping, Mirroring and Replication.

Installed SQL Server Cluster 2008 on both Active-Passive and Active-Active nodes.

Added Node to the existing SQL Server Cluster 2008 on both Active-Passive and Active-Active nodes.

PowerShell Scripting.

Pavan

Contact this candidate