Vamsidhar. M Mobile No: +91-814*******

E-Mail: t9m7hb@r.postjobfree.com

Professional Summary

Having 2.6 years of professional experience in MS SQL Server Administration.

Working as a MS SQL Server DBA with DBA Support Team that provides 24x7 production support for the US client's mission critical database environments.

To handle process user requests received through telephone and emails

Service pack installation and hot fix application strategies.

Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005 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, rebuild/defrag indexes, integrity checks. 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

Hands on experience in configuring Database Mirroring and Ensuring High Availability to the databases by testing the failover

Strong aptitude towards learning new technologies.

Excellent interpersonal and communication skills.

Able to adapt quickly to the environment and willing to work in shifts.

Experience

Presently working as a SQL Server DBA with GLOBAL ERP SOLUTIONS, Hyderabad (October-2009 to Till date)

Educational Qualifications

B.TECH from JNTU

Skill Sets

Tools and Packages : Ms-Office 2003/2007

Database : MS SQL Server 2005, 2008

Operating Systems : Windows Server 2000/2003, Windows XP, Vista

Languages : C, C++, Transact-SQL (T-SQL).

Project Summary

Organization : GLOBAL ERP SOLUTIONS

Client : Centex online

Team size : 14

Role : Team member-DBA

Environment : Windows 2003/2000 Server, SQL Server 2005

Responsibility : Data Base Administrator

Responsibilities

Installation, configurations & Administration of SQL server 2005.

Creating and configuring the Databases.

¬Performing Security Administration Tasks like Creating users and Delegating appropriate permissions to the users as required.

Performing backups of client databases by setting up backup schedules at regular intervals and also restoring databases

Creating and Monitoring the Maintenance plans – scheduling tasks to run daily and/or on weekends (tasks like rebuilding indexes, defragmenting Databases, Shrink Database, and Database complete backup.

Administering Large Databases from capacity planning to database design and maintenance

Performing Database integrity checks at regular intervals to check Database consistency.

Ensuring high availability of the database exploiting the concepts of DB mirroring, Log Shipping and Configuring Replication between servers.

Personal Details

Father’s Name : Krishna M

Date of Birth : 29th, September 1987

Martial Status : Single

Nationality : Indian

Languages Known : English, Telugu and Hindi.

Declaration

I hereby declare that all the above information furnished by me is true to the best of my knowledge.

(Vamsidhar.M)

Contact this candidate