Sql Server Engineer

CURRICULUM VITAE

K.V.N SUBBA REDDY

*-*-***/*/*,

Anand Nagar, Email :

ugdvnj@r.postjobfree.com

Erragadda,Hyd-18. Mobile: 789-***-****

OBJECTIVE:

. Looking forward to a challenging and competitive work atmosphere

leading to a professional experience with a dynamic and progressive

organization where my skills, talents and abilities will be utilized

to the fullest for mutual benefit.

Experience Summary:

. Overall 4.7 years of experience in Information Technology.

. Having 3.1 years of experience in MS-SQL Server 2005/2008 Database

Administration.

. Experience in Installation, Configuration and Maintenance of SQL

Server.

. Experience in Database backup and disaster recovery procedures.

. Experience in Scheduling and managing jobs on MS SQL Server.

. Experience in Handling log space issues

. Experience in Creating SQL Logins, Assigning Roles for the requested

users and schema management.

. Experience in query optimization & SQL server performance using SQL

Profiler.

. Extensive Knowledge of SQL Server Log Shipping.

. Extensive Knowledge of SQL Server Database Mirroring.

. Extensive Knowledge of SQL server Replication

. Strong troubleshooting and problem solving skills.

. Good understanding on SQL server Clustering

EDUCATION

. Master of Computer Application (MCA) from Osmania University,

Andhra Pradesh, India in 2007

SKILLS:

1 Database:

MS SQL SERVER 2005/2008

2 Tools:

SQL Server Management Studio, SQL Server Profiler, Citrix GotoAssist, SQL

Monitor

3 Operating Systems:

1 Windows XP & Windows server2000/2003

4 Programming Lang:

1 T-SQL, C++

Experience:

. Working as a Database Administrator in CMC Ltd, Hyderabad from Oct

2009 to till date.

. Worked as a Application Support Engineer in CMC Ltd, Hyderabad from

Mar 2008 to Sep 2009

Award:

. Winner of CMC Special Appreciation Award for excellent performance by

the team.

Project # 2 : Hindustan UniLever Ltd, RSUNIFY, India - Oct 2009 to till

date

Role : SQL Server DBA

Environment : MS SQL Server 2005/2008, Citrix Remote Management Tools,

CA-SPSD

Description: Working on the software application called RS-Unify based on

SQL Server. It is an automation package, which is developed to automate the

core business activities. It is a multi-user package through which each and

every HLL client can interact with main server to upload the data needed

for business transactions. Client while interacting with server sends and

receives the data, which is present in the database.Citrix online server is

used to connect client system remotely. The main purpose of the project was

to Install & Implement RSUnify.system maintenance and Troubleshooting the

Software and guidance

Job Responsibility

. Responsible for providing 24x7 support for production SQL Server

database and maintenance.

. Installation of SQL server software and related Products.

. Automation of maintenance by creating jobs and alerts.

. Creating SQL Logins, Assigning Roles for the requested users.

. Performed daily backups and developed recovery procedures.

. Checking of the database consistency using DBCC commands to minimize

complexity.

. Tuned the SQL queries using performance monitoring tools. & involved

in tuning the database.

. Involved in designing of High Availability using Database Mirroring,Log Shipping and Replication

. Coordinating with onsite DBA's for necessary troubleshooting to

resolve the problem.

. Maintaining the incident dairy in the Incident Management System(CA-

SPSD)

Project # 1 : Hindustan UniLever Ltd, RSUNIFY, India - Mar 2008 to Sep

2009

Role : Application Support Engineer

Environment : Sql server 2005, Apache Tomcat, MS Active sync, CAs SPSD,

Citrix GotoAssist, SQL Monitor

Job Responsibility

. Responsible for installation & configuration of SQL SERVER.

. Creating databases & configuration to the databases.

. User's creations and clients management.

. Implementing and Managing the Remote Management Software.

. Responsible for troubleshooting and problem solving in Databases.

Personal Details

Date of Birth : 10th June 1984

Father's Name : K.Samba Shiva Reddy

Gender : Male

Marital Status : Married

Nationality : Indian

Passport No : K1857874 (Expiry Date: 15/03/2022)

Languages Known : English, Telugu

Contact this candidate