Vamsidhar. M Mobile No: +91-814*******
E-Mail: ************@*****.***
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)