Sql Server Maintenance,sql administration,sql dba

Haritha

Mobile: +91-950*******,

*******.*****@*****.***

Professional Summary:

* **** ** ********** ** IT industry having strong skills in SQL Server

Administration.

Experience in Administrating SQL Server in the following versions

(2000,2005,2008)

Responding to the alerts which comes in the form of E-mails

Process User requests that come in the form of tickets.

Handled around 85 Database servers including Prod and Non prod and handling

around 400+ databases with an maximum size of 800GB.

Creation and maintenance of Databases by pushing all the maintenance jobs

on the database.

Creating and implementing Disaster Recovery Plan

Designing an Successful Backup Strategy for the databases, based on the

User Requirement

Experience in Database administration activities likeInstallation,

Configuration,

Backup & Recovery, Database Security, Data Transformation Services and T-

SQL

Providing the security by creating Logins and assigning the Privileges by

using Roles

Migration of Databases from server to the server instance for faster

performance

Up grading the environment from SQL SERVER 2000 to SQL SERVER2005

Hands of Experience in Setting up Log shipping, DB Mirroring and

Replication.

Knowledge on clustering.

Good experience in resolving blocking and Deadlock Issues by using SQL

commands.

Proactive and organized at work, adaptable to any situation and flexible to

work in shifts

Core Responsibilities:

Managing and monitoring Database servers.

Monitoring the servers by accessing remotely

Experience in handling Production Servers having an average 5 user

Databases in each server spread across various locations

Installation, configuration and maintenance of MS SQL Server

Checking the status of Backup troubleshooting the failed backups and

Restoration of databases.

Ensuring data consistency in the database through DBCC commands

Adding users in the database and granting permissions

Scheduling jobs in SQL Server.

Academic Profile:

COURSE DISCIPLINE INSTITUITION BOARD/UNIVERSITY YEAR AGGREGATE

OF

PASS

B.Tech Computer Rajamahendri

Science and Institute of J.N.T.U 2013 59.4%

Engineering Engg.& Tech. kakinada

Intermedia Maths, Physics, Sri narayana Board of

te Chemistry. Junior Intermediate 2009 68.2%

college Education, A.P

S.S.C. General Sri gowthami Board Of

public Secondary 2007 77%

school Education, A.P

Professional Experience:

Working as Productions support DBA in Global ERP Solutions. From APRIL 2013

to Till date.

Project Profile :

Client : SERCO (U.K)

Team size : 9

Role : Team member-DBA.

Environment: Windows 2003/2000 Server, SQL Server.2005

Responsibility: Data Base Administrator

Installing, Configuring and Administering SQL server 2005 & 2008

As a part of the DBA team providing 24/7 production support to the clients

Monitoring the Scheduled jobs

Ensuring high availability of the database exploiting the concepts of

clustering, replication, Log shipping etc.

Monitoring the Disk spaces on all the servers.

Checking the general Health of the servers for identifying Bottlenecks

Analyzing, Identifying and Resolving performance issues of the server

Creating login/user and grant/revoke various permissions.

Regular backups and recovery of database in SQL Server 2000

Making database level changes like creating & altering, adding & resize

data files.

Troubleshooting of common SQL codes and error messages.

Writing the SQL queries and T-SQL scripts.

Technical Skills:

Specialization : Databases

Database Operating : MS-SQL 2000,2005,2008 MS-Access

System MS DOS, Windows 95 / 98 / 2000

Server / Unix

Packages : VB, MS-Office

Languages : C, C++, Java

Software / Tools : Transact SQL

Personal Profile:

Nationality : India

Marital Status : Single

Languages : English, Telugu and Hindi

Date:

Place:Hyderabad

Contact this candidate