Sql Server Database Administration

Resume

Suresh. Gotika Contact No. : +91-966*******

Email : ******.******@*****.***

CAREER OBJECTIVE

To obtain a position in an organization which best utilizes my knowledge for the benefit of the organization and helps in my growth and development as well. I seek to gain an experience that would go a long way with me and contribute to the benefit of my organization.

PROFESSIONAL SUMMARY

• Around 4.8 years of technical experience as a Database Administration in MS SQL Server

• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services and T-SQL

• Successfully resolving SQL Server problems which involve in-depth knowledge of SQL Server architecture, connectivity, DTS, backup/restore, database corruption, security etc.

Working on change management, incident management and problem management as well

using Remedy tool.

• Creation and maintenance of Databases, creating Roles and managing user permissions.

• Refreshing, migrating and upgrading databases.

• Experience in setting up, troubleshooting and maintaining SQL Server Databases.

• Experience in implementing Log shipping and mirroring and replication.

• Experience in cluster environment.

WORK EXPERIENCE

Organization From Date To Date Designation

Kadevi Industries Ltd

Hyderabad March’ 2012 Currently Working Database Administration

Zensoft Services Pvt, Ltd

Pune

Nov' 2009 March’ 2012 Database Administration

Project Experience Summary

Kadevi industries LTD

Kadevi industries,LTD

Hyderabad SQL Server 2005/2008,VS2005 DBA 3 Running

Wells Fargo, India

Zensoft Services Pvt, Ltd

Pune

SQL Server 2005/2008, Asp.Net DBA 5 2.4 Yrs

Project Name : Humana-Aaron Optimization March 2012 – Till Date

Kadevi industries LTD

Role & Responsibilities:

• Installing and Configuring SQL Server2000/05/08/R2, including service pack deployments.

• Refreshing, migrating and upgrading databases.

• using Remedy tool.

• Backup & Recovery, Security Management, server Patching, monitoring & fixing issues.

• Role also involves setting Log shipping, Mirroring and Replication troubleshooting any issues if occur.

• Database Consistency checks for checking the indexes and allocating Pages. Maintaining data integrity and security, managing users, privileges, roles, profiles and database resources.

• Fixing Orphaned users.

• Implementing disaster recovery plans.

• Managing Security (Creating users, logins and roles, granting permissions)

• Performance Monitoring and tuning.

• Ensuring Data consistency in the database through DBCC commands.

• Adding users in the Database and granting permissions.

• Working on Log shipping, mirroring and Replication Scheduling jobs in Sql server

Project Name: WDAI Nov 2009 – March 2011

Client: : Wells Fargo, India

Role & Responsibilities:

• My role involves managing multi terabyte Databases of SQL Server2000, 2005 & 2008 R2 over Cluster Servers. We are managing more than 800 sql instances.

• Installing and Configuring SQL Server2000/05/08/R2, including service pack deployments

• Refreshing, migrating and upgrading databases.

• Task involves to resolve and performance and blocking issues by running and analyzing SQL traces as well as windows counters.

• Working on change management, incident management and problem management as well using Remedy tool.

• Task also involves 24X7 uptime of database, maintenance of database, performance tuning,

• Backup, Recovery & Security Management, server Patching, monitoring & fixing issues.

• Role also involves setting Log shipping, Mirroring Replication and troubleshooting any issues if occur.

TECHNICAL PROFILE

Base Primary Skills

Web Technologies ASP.Net, ADO.Net, HTML

Programming Langages C, C++, C#, VB

Development Tools Visual Studio.Net 2005/2008/2010

Databases SQL Server 2000/2005/2008/R2

Tools/Utility SSMS, VS 2005/2008/2010

Operating System Window XP/7, Window 2003/2008 Server

EDUCATIONAL PROFILE

Qualification University/Board Year

M.SC(cs) MDU University,Rohtak 2006

PGD-MISCA OU University, Hyderabad 2003

PGD-PMIR K.U Warangal 2001

B.COM K.U Warangal 1998

PERSONAL DETAILS

Date of Birth Gender Nationality Marital Status Languages Known

16th Feb 1977 Male Indian Married English,Hindi, Telugu

Email ID ******.******@*****.***

Contact No. +91 – 966-***-****

Address Hyderabad

DECLARATION

I hereby declared that the details provided above are true to the best of my knowledge.

Date:

Place: (Suresh. G)

Contact this candidate