Sql Server Database Administrator

MURALI MOHAN

Email:mohanb.sqldba @gmail.com Mobile: +91-888*******

Profile Summary

Overall 7.1 years of experience as a Database Administrator in production environments.

Managing around 180 servers and 2500 databases with sizes up to 2 TB.

Work experience in 24x7 Production support for SQL Server 2005/2008/2008R2/2012

Installing and Configuring the SQL Server 2005 and 2008 and 2008R2 and 2012.

Applying SQL Server patches and hot fixes.

Verifying and resolving the SQL Server Blocking issues and Finding and fixing the root cause.

Resolving the Disk space issues and finding the root cause and permanent fixes.

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

Restoring the Databases from Production to test environment and vice versa.

Experience in User Management activities like adding the user and managing the permissions.

Experience in Creating and scheduling the jobs and troubleshooting the failed jobs.

Good Experience in Performance tuning activities like verifying the slow running queries and identifying missing indexes and also usage of statistics.

Experience in usage of DBCC commands and DMV’s for troubleshooting.

Executing the deploying the scripts in prod environment.

Configuring, monitoring and troubleshooting the REPLICATION and DR activities.

Good experience in Cluster installation and adding the nodes in the respective servers in SQL Server 2005, 2008R2.

Performing the Failover and Failback operations in the cluster environment and troubleshooting activities.

Configuring and Maintaining and troubleshooting the Database mirroring and also experience in Mirroring DR activities.

Configuring and Maintaining and troubleshooting the Database Log Shipping and also experience in Mirroring DR activities.

Perform Server level tuning, performance monitoring, Index Tuning, Query Tuning.

Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run the databases efficiently.

Experience in migration and upgrade process from SQL 2005 to 2008 and from 2008R2 to 2012.

Basic knowledge on creation of basic SSIS packages and deploying in MSDB or File System.

Installing and configuring the SSRS. and working with Security in SSRS.

Education Qualification

Completed M.C.A from Bangalore University, Andhra Pradesh in 2008.

Technical Skill Set

Operating Systems:

WINDOWS SERVER 2003 and 2008

Programming languages:

T-SQL

Database Technologies:

MS SQL Server 2012, 2008, 2008 R2, 2005

Tools:

Remedy, Service Now and Hyperbac,BMC Gross

Hardware

IBM compatible PCs/Servers

Professional Experience

Organization

Designation

Duration

POLARIS, Pune

STEELWEDGE Technologies

Hyderabad

Lead Database Administrator

Senior Cloud DBA

May 2016 to till Date

May 2014 to May 2016

WIPRO, Hyderabad

VALUE LABS,Hyderabad

Database Administrator

Database Administrator

Sep 2011 to Dec 2013

June 2009 to Sep 2011

Project Details

Organization : POLARIS, Pune

Client : United Continental Holdings.

Duration : May 2016 to Till Date

Role : SQL DBA

Team Size : 12

Skills : SQL Server 2005/2008R2 and 2012, Windows 2003 server, Remedy

Description :- United Continental Holdings, Inc. (formerly UAL Corporation) is a publicly traded airline holding company headquartered in the Willis Tower in Chicago. UCH owns and operates United Airlines, Inc. The company is the successor of UAL Corporation, which agreed to change its name to United Continental Holdings in May 2010, when a merger agreement was reached between United and Continental Airlines.

Responsibilities:

Installation and configuration of MS SQL Server 2005 and 2008R2 and 2012.

Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking

Implement and maintain database security as per business rules and requirements

Configuring and troubleshooting high availability scenarios like Log Shipping.

Implemented Database Mirroring with synchronous mode.

Maintained & Monitored Alert/Schedule to make smooth replication process.

Ensure and maintain sound backup and recovery policies and procedures.

Updating Service packs and Security patches for the Servers.

Creating and reviewing Security features for all the servers.

Configuring and monitoring the Database Mirroring and Log Shipping.

Trouble shooting blocking, space issues.

Ensuring Data consistency in the database through DBCC commands.

Installing and configuring the failover cluster.

Configuring and maintaining the always on.

Project :-2

Organization : STEELWEDGE, Hyderabad

Client : SM INVESTMENTS.

Duration : May 2014 – May 2016

Role : SQL DBA

Team Size : 10

Skills : SQL Server 2005/2008R2, Windows 2003 server and Remedy

Description :-

SM Investments Corporation, SM Investments, or SMIC, is a holding company with interests in shopping mall development and management, retail, real estate development, banking, and tourism, founded by Henry Sy, Sr. It has become one of the largest conglomerates in the Philippines, being the country's most dominant player in retail with 208 stores nationwide. Of these, 47 are SM Department Stores; 38 are SM Supermarkets, 37 are SM Hypermarkets and 86 are SaveMore branches.

Responsibilities:

Installation & Configuration of SQL Server 2005/2008/2008R2 on Local Systems

Maintaining of over 100+ servers.

Continuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and restore procedure for database.

Maintenance work on different databases.

Having experience on database backup and restorations.

Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.

Identifying/resolving fragmentation resulting in improved performance.

Hands on experience in High Availability such as Log-Shipping,Database Mirroring, Replication and Clustering

Monitoring SQL Server agent jobs/maintenance plans

Provided 7 x 24 Production support for the database and application issues.

Good experience on migration and up gradation of databases.

Executing scripts in production environment.

Project :-3

Organization : WIPRO, Hyderabad

Client : ECIT, India

Duration : Sep 2011 – Dec 2013

Role : SQL DBA

Team Size : 10

Skills : SQL Server 2005/2008R2, Windows 2003 server and Remedy

Description :- Electronics Corporation of India (ECIL), established in the year 1967, a Govt. of India enterprise under the Department of Atomic Energy, pioneered the electronics revolution in the country. Information technology is one of the core areas where ECIL has the distinction of manufacturing the first digital computers in the country. ECIL has supplied over 50K systems for various real time and embedded Systems application.

Responsibilities:

Analyzing, trouble shooting, working with application connectivity and SQL Server issues.

New SQL Server Installations of SQL Server 2005, 2008, 2012.

Experienced in backups & restore.

Applying Service packs and patches on regular intervals.

Providing the SQL Server Security to the clients and end users.

Experience on High availability and Disaster recovery concepts.

Implementing Clustering and log shipping and mirroring.

Executing the scripts in prod environment.

Run profiler, trouble shoot and work with external partners.

Cluster failover and failback activities.

Performance Troubleshooting

Working on blocking and disk space related issues.

Creating logins and providing the required permissions.

Project:-4

Organization : VALUE LABS, Hyderabad

Client : X5 Retail group, USA

Duration : Jun 2009 – Sep 2011

Role : SQL DBA

Team Size : 10

Skills : SQL Server 2005/2008R2, Windows 2003 server and Remedy

Description :- X5 Retail Group is the second largest retailer in Russia. As of 2012, the Moscow-based company had 2,545 stores and 109,000 employees. The company was created in May 2006 after the merger of the Pyatyorochka and Perekrestok food retail chains. It was the country's largest retailer in terms of sales before being overtaken by Magnit in April 2013. A rival grocer, Kopeyka, was acquired by X5 for $1.12 bln in 2010. X5 also operates the Karusel hypermarket chain.

Responsibilities:-

Installation & Configuration of SQL Server 2005/2008/2008R2 on Local Systems

Maintaining of over 100+ servers.

Continuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and restore procedure for database.

Having experience on database backup and restorations.

Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.

Identifying/resolving fragmentation resulting in improved performance.

Hands on experience in High Availability such as Log-Shipping,Database Mirroring, Replication and Clustering

Monitoring SQL Server agent jobs/maintenance plans

Provided 7 x 24 Production support for the database and application issues.

Good experience in migration activities.

Deploying the scripts in production environment.

deploying the SSIS packages in file system and MSDB.

Personal Information

Date of Birth : 20-JAN-1985

Sex : Male

Passport Number : Will be provided on demand

Declaration

The above statements are true and correct for the best of my knowledge and belief.

Date:

(MURALI)

Contact this candidate