Sql Server Project

RESUME

K.Sumalatha

Mobile: +91-979*******

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

Objective:

SQL Server 2005/08/08R2 Database administrator, Having 3.1 years of

experience, seeking a challenging role in an organization that gives me the

opportunity to share the knowledge thereby contributing to the growth of

the organization and self.

Professional Summary:

. Having 3.2 years of IT experience in installation, configuration,

and administration of MS SQL Server 2005/2008/08R2 in Windows

environment.

. Proficient in Database Backup, Recovery and Disaster Recovery

procedures.

. Familiarity with SQL server 2005/2008/08R2

. Experience in using Performance Monitor/Profiler to resolve Dead Locks

and long running queries.

. Experience in log shipping and Transactional Replication.

. Experience in client/server connectivity, Query Optimization,

Performance Tuning and Database Consistency Checks using DBCC commands

. Experience in creating and executing maintenance plans.

. Knowledge on Database Mirroring.

. Knowledge on Clustering.

. Strong written and verbal communication to work effectively with cross-

functional teams.

. Self-motivated, responsible, confident and have the ability to multi-

task and prioritize under changing and

challenging workloads.

Technical Skills:

SQL Server Tool : SSMS, SQL Profiler, DTA

Languages : C, HTML, C++

Operating Systems : Windows server 2003, Windows 2008

Data Bases : MS-SQL Server 2005/2008/08R2

Educational Qualifications:

> M.C.A in 2010 from S.VUNIVERSITY in First Division.

Professional Experience:

Working as a SQLSERVER Data base Administrator in Net Access(India).Ltd

from May, 2010 to Till Date

Experience Summary

Project#1

Project Name: Treasury Support

Project Details:

The Treasury department is responsible for managing CCE funds and stocks

across all geographical area. Activity takes place on a daily as well as

monthly basis and access to current information is critical. Financial

institutions and vendors can send real time financial transactions which

this system uses to record and report.

Duration: Jun'2010 to Till Date

Role: Jr.. Database Administrator

Tools: MS SQL Server 2005/2008,

Windows 2008

Roles & Responsibilities:

. Installation of SQL Server 2005/ 2008

. Appling service packs for SQL Servers.

. Creating logins, database users and assigning roles.

. Manage the SQL Server user accounts

. Plan and implement backup, recovery strategy.

. Troubleshooting backup failures.

. Backups and Restoration of production databases.

. Perform database maintenance tasks-index rebuild, index reorganize

. Monitoring jobs on a daily basic

. Daily activities include monitoring the database, checking error logs,

checking the log file size and free space in the data drives,

connectivity of the databases.

. Perform weekly activities through maintenance plans.

. Configure Log Shipping & Replication (snapshot & transactional.).

. Perform periodic checking of databases with DBCC command for

maintaining data consistency and integrity.

. Responsible for query optimizing and performance tuning using SQL

profiler.

Date:

(K.SUMALATHA)

Contact this candidate