Sql Server Project

MEHABOOB BASHA SHAIK

Mobile: +91-949******* ~ E-mail: **********@*****.***

Over 3.9 years of experience in databases predominantly in the field of Microsoft SQL server

Administration on production databases with experience in Design, Development, Implementation, tuning

and troubleshooting.

PROFESSIONAL SUMMARY

Working as a MS SQL Server DBA with DBA Support Team that provides 24x7 production

supports.

To handle process user requests through telephone and emails.

Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005 and from MS SQL Server

2005 to MS SQL Server 2008 using any suitable approach (in place or side-by-side).

Maintaining database security by creating groups, users and by granting permissions to them.

Ensuring that all databases are backed up on a regular basis by monitoring full, differential,

transaction log backups.

Planning and implementing disaster recovery procedures to ensure minimal downtime and data

loss.

Creation of database maintenance plans, Creation of TSQL scripts for full, differential,

transaction log backups, optimizations, integrity checks on some instances that has special

requirements beyond maintenance plans.

Running of performance monitor, SQL Profiler or querying server to identify performance

problems on servers experiencing bottlenecks.

Planning, administration and implementing replication between the servers.

Configured log-shipping between the servers.

Strong aptitude towards learning new technologies

Excellent interpersonal and communication skills.

Able to adapt quickly to the environment.

ACADEMIA

MCA (Master of Computer Applications) from Osmania University, Hyderabad

BSc Computers (Bachelor of Science) from Acharya Nagarjuna University, Vijayawada.

COMPUTER PROFICIENCY

Database : MS Sql Server 2000, 2005 and 2008

Languages : SQL, T-SQL.

Etl Tool : Data stage (Data warehousing)

Operating Systems : Windows XP/ Windows 2000/2003/2008 Server

2

WORK EXPERIENCE

May 09 – till date NCMSL Database Administrator

PROJECT#

Project Title : Production Database Administrator

Duration : May 2010 to Present

Position : Database Administrator

Organization : NCMSL.

Environment : MS SQL Server 2000/2005/2008

Software : Windows 2000/2003/2008 Server

Role:

SQL Server Installation, administration, System Monitoring, Backup, Recovery and Performance

tuning, Query optimization.

Migration from SQL Server 2000 to 2005 and 2008.

Managing and monitoring Database server, Monitoring and auditing users.

Planning, implementation and administration of Log Shipping and DB Mirroring with MS SQL

Server 2005.

Monitoring the Disk spaces on all the servers, Creating Maintenance plans and jobs for

automation of the repetitive tasks.

Involved in Troubleshooting the Database server instances.

Creation and monitoring the maintenance plans of Databases on server.

Database administration activities like Monitoring the Server instances, Log spaces, Disc Spaces,

Shrink Files, job scheduling.

Design/implement database solutions, System backup/recovery, System monitoring and

Installations.

PROJECT#

Project Title : CWIG (Crop and Weather Intelligence Group)

Duration : March 2009 to April 2010

Position : Database Administrator

Organization : NCMSL.

Environment : MS SQL Server 2005/2008.

Software : Windows 2000/2003 Server

This project involves gathering of climate and weather data through remote devices installed across the

country and dump the raw data into our servers. The purpose of this project is to provide data services to

external institutions like banks, commodity corporations etc.

Role:

Installing, Configuring and Administering SQL server 2005

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

As a part of the DBA team providing 24/7 production support level-2 to the clients.

Monitoring the Scheduled jobs.

Ensuring high availability of the database exploiting the concepts of replication, Log shipping

etc.

Monitoring the Disk spaces on all the servers.

Checking the general Health of the servers for identifying Bottlenecks.

Analysing, Identifying and Resolving performance issues of the server.

PERSONAL VITAE

Father’s Name : Khasim Saheb

Date of Birth : 28th Sep 1982

Marital Status : Single

Religion : Indian

Languages Known : English, Hindi and Telugu

Present Address : H. No. 6-3-1147/A/B/2,

BS Maktha,

Somajiguda,

Hyderabad,

A.P, India

(MEHABOOB BASHA

SHAIK)

Contact this candidate