RAHEEM.SHAIK

E-mail:actgo1@r.postjobfree.com

Mobile: +91-829*******

Professional Summary

Having 4.4 years of experience as a SQL Server DBA in a Production Environment as a DBA and supporting L2 and L3 Support and currently working with HITACHI CONSULTING, Pune as a DBA. Primarily working with SQL Server 2012 and 2008R2, 2008 and 2005 versions. Having hands on Experience in administering SQL Server activities like Installation, Patching and Up gradation and Migration, Backup and Recovery and Replication and Log shipping and DB Mirroring and Performance tuning and Cluster activities.

Key Responsibilities

Involved in Installation and configuration of MS SQL Server 2005, 2008 and 2008 R2 and 2012 in Windows environment.

Patching installations for standalone and cluster servers.

Basic knowledge on creating the SSIS packages and deploying them.

Closing the tickets with in the SLA time and Monitoring the SLA.

Good experience on Installing and configuring the SSRS.

Configuring and maintaining all types of Database Backups and Recovery operations.

Performing Database Maintenance Activities like rebuilding/reorganizing indexes and update statistics, checking database integrity and clean up history on regular intervals.

Executing the scripts in prod environment.

Identifying and Resolving Blocking and Deadlock issues by using System Stored Procedures, DBCC, Activity Monitor and Profiler.

Identifying and Resolving fragmentation and performance issues.

Weekly Refreshing Database from Production to Test Environment.

Enrolling users, controlling and monitoring User Access to the database, and maintaining system security.

Good experience on Upgradation and Migration of SQL Server.

Hands-on experience on high availability solutions like Replication and Database Mirroring and Log Shipping and Cluster activities.

Configuring, monitoring and troubleshooting the Transaction Replication and DR activities.

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

Performing the Failover and Failback operations in the cluster environment and adding the new Disks 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.

Professional Experience:

Currently working with HITACHI CONSULTING, Pune from May-2013 to till date.

Previously worked with ZENSAR, Bengaluru from June-2011 to Apr- 2013.

Educational Qualification:

Completed Masters (M.C.A) from Acharya Nagarjuna University, Andhra Pradesh in 2011 aggregated with 70%

Technical Skills:

Operating Systems : Windows Family (XP/2000/2003/2008)

Languages : T-SQL

RDBMS : MS SQL Server 2005 and 2008/2008R2, 2012.

SQL Server Tools : Enterprise Manager, Query Analyzer, SSMS, Profiler, DTA, Server Side Trace.

3rd party Tools : Remedy, Service Now, and Lite Speed.

Project summary:

Project#1:

NAME : WELLCARE HEALTH.

Duration : June – 2011 to Apr-2013.

Environment : MS SQL 2005, 2008, 2008 R2, 2012, Windows 2008

Description: Well Care Health Plans, Inc. began operations in 1985 and is based in Tampa, Florida. Well Care provides Medicare and Medicaid managed health plans for 2.2 million members, partners with over 91,000 physicians, and employs over 3,500 associates. Well care Health Plans, Inc. is the holding company for several subsidiaries, including Well Care, Stay well, Health Ease, Harmony, and 'Ohana. Regional offices are located in Miami, Florida; Manhattan, New York;

Responsibilities:

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

Migrating databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.

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 and replication and mirroring and clustering.

Restoring databases from prod to test environment.

Identifying and Resolving fragmentation and performance issues.

Weekly Refreshing Database from Production to Test Environment.

Enrolling users, controlling and monitoring User Access to the database, and maintaining system security.

Implemented Database Mirroring with High Availability Mode in SQL 2005

Ensure and maintain sound backup and recovery policies and procedures.

Updating Service packs and Security patches for the Servers.

Trouble shooting blocking, space issues.

Executing the scripts in Production environment.

Ensuring Data consistency in the database through DBCC commands.

Project#2:

Name : Prudential Financial services, USA.

Role : Database Administrators

Environment : SQL Server 2000, 2008/2008R2 and Windows 2000/2003/2008

Duration : Sep-2013 to Till Date.

Team size : 8

Description: Prudential Financial, Inc., also known by its primary subsidiary The Prudential Insurance Company of America, is a Fortune Global 500 and Fortune 500 company whose subsidiaries provide insurance, investment management, and other financial products and services to both retail and institutional customers throughout the United States and in over 30 other countries.

Responsibilities:

Supporting Different versions of SQL Server like 2005 and 2008R2 and 2012.

Configuring and maintaining Database Backups and other maintenance activities.

Good experience in installing and configuring the SQL Server 2008R2 and 2012.

Good experience in applying the service packs and in standalone in cluster servers.

Daily checking and resolving the tickets depends on the priority levels.

Responsible for performing Database Maintenance activities like rebuilding/reorganizing indexes update statistics, checking database integrity and clean up history on regular intervals.

Daily monitoring the Database Space Management parameters, allocating the required space to databases and suitably managing database growth.

Enrolling users, controlling and monitoring User Access to the database, and maintaining system security.

Doing Weekly Refresh of Database from Production to Test Environment.

Executing scripts in prod environment.

Configuring the Transaction replication in production environment.

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

Personal Details:

Sex : Male

D.O.B : 05-June-1987

Pan card : BZWPR1078K

Passport No : Z3357693

Declaration:

I hereby declare that the information furnished above is true to my knowledge and belief.

(RAHEEM SHAIK)

Contact this candidate