Sql Server Project

Nagaraj Narra

Mobile: +91-812*******

E-Mail: ****.********@*****.***

SYNOPSIS:

Over 4.2 years of experience in Information Technology. To be

associated with a progressive organization that gives me scope to Update my

knowledge and skills in accordance with latest trends and be a part of team

that dynamically works towards the growth of the organization and gains

satisfaction.

EXPERIENCE SUMMARY:

Has over 4 years of experience in MS SQL Server DBA

. Installation of SQL Server, Applying Service Packs and Security

patches for the servers.

. Developing the successful backup strategies based on Recovery

models.

. Implementation of Database Maintenance Plans/Sub-Plans for

automation of SQL Server.

. Performing the daily checklist.

. Implementation of SQL Logins, Roles and Authentication modes as a

part of security.

. Experience in Upgradation/Migration from MS SQL Server 2000 to MS

SQL Server 2005.

. Fixing orphaned users through stored procedures.

. Ensuring uptime of all database servers through monitoring tools

. High Availability such as Replication, Database mirroring, Log-

Shipping, Good knowledge in Clustering concepts and installation etc.

. Moving databases from one location to another.

. Recovery of database at the time of instance/database crash.

. Implement and maintain database security (creating Logins/Users and

also maintaining Roles/Securable(s)).

. Maintaining and troubleshooting Log-Shipping, mirroring.

. Good knowledge about Windows and Sql Clustering and trouble

shooting.

. Handling the database suspect modes.

. Knowledge about DBCC commands and using the important commands

regularly

. Good Knowledge on DMV's.

. Team player, positive attitude, strong work ethic with good

interpersonal skills.

Education

. Master of Computer Application (MCA) from Anna University, Chennai.

Work Experience

. Hexaware Technologies Ltd. Sep 2010 to Till

Date

. S.C Info systems Ltd. June

2009 to Sep 2010

. Working with Hexaware Technologies Ltd. From September 2010 - Till

date

PROJECT EXPERIENCE

Project Name : LSRPL.

Client : PAYBACK India

Role : Team Member

Environment : SQL Server 2005,2008 & 2012

Duration : Sept 2011 to Till Date.

Tools Used : SSMS & SQL Server Profiler, Scotty ticketing

and ICINGA

Description:

PAYBACK Inc. is the company behind India's largest loyalty program

called PAYBACK. The loyalty program Payback presents many advantages over

traditional, stand-alone customer loyalty schemes restricted to one brand

or company only. The power of PAYBACK stems from pooling loyalty benefits

from many attractive partners: Using one single card, members earn loyalty

points when they shop at a wide range of different merchants and brands -

offline and online.

Roles and Responsibilities:

. Involved in Installing SQL Server and its Service packs and also

installations as required.

. Supported 24 X 7 production environments.

. Monitoring free space of database.

. Creating, scheduling and executing jobs

. Maintaining the jobs Scheduled during the night for the Backup of

Databases.

. Design, recommend and implement Backup Strategy

. Understanding the client requirements by studying functional

document.

. Performance monitoring & trouble shooting.

. Scheduled Alerts and Jobs Using SQL Server Agent.

. Object level recovery using Lite Speed Tool.

. Configure Sql Clustering and trouble shooting.

. Interacting with the people and resolving the issues.

. Day to day maintenance Activities

. Attended weekly status meetings and provide detailed status report

to the client.

PROJECT EXPERIENCE

Project Name : MFC_BI.

Client : Manulife

Role : Team Member

Environment : SQL Server 2005 & 2008

Duration : Nov 2010 to Aug 2011

Tools Used : SSMS, Upgrade advisor 2008.

Description:

The customer is a leading Canadian-based financial services group

serving millions of clients in 22 countries and territories worldwide for

more than 120 years. As part of this project, multiple SQL instances are

being upgraded from SQL Server 2000/2005 to SQL Server 2008.

Roles and Responsibilities:

. Responsible for installation and configuration of SQL server 2005

database on Servers.

. Implementation of SQL Logins, Roles and Authentication Modes as a part

of Security Policies for various categories of users.

. Attending weekly status meetings and provide detailed status report to

the client/onsite

co-ordinator.

. Upgrading databases from SQL 2000/2005 to SQL 2008.

. Running Upgrade Advisor 2008 and fix the issues.

. Rebuilding indexes and update statistics for better performance.

. Trobleshooting and fixing the performance related issues on post

upgradation.

. Preparing documets with all issues and fixes.

. Post upgradation support for all upgraded DBs.

. Responsible for backups/restores, monitoring SQL uptime

. SQL server monitoring: Monitoring disk space usage, Monitoring memory

usage, Monitoring CPU usage and Monitoring Network usage.

PREVIOUS WORK EXPERIENCE:

. Worked as a SQLServer DBA in S.C Info systems from Jan 2009 to

Sep 2010.

Project : Financial Management System (FMS)

Software : SQLServer 2000,2005

Role : Team Member

Duration : August 2009 to Sep 2010

Description:

Main objective is to providing services to the entire needs of any

educational institutions management. Authenticated user entry with

distributed roles and security provided by administrator. Main modules are

student, employee, organization expenditure, board exam details and report.

Build the financial, time schedules for students and employee modules.

Generating xml files and replicates to central server with windows

services. Windows services working based on scheduled timings. Sending SMS

to parent every information about student.

Role and Responsibilities:

. Involved in Installing SQL Server and its service packs, and also client

installations as required.

. Creation of user databases and ensuring file group creations and also

ideally placing files in appropriate locations.

. Ensure that every user is connected to the Database Server and

troubleshoot whenever there is any problem in the connectivity.

. Creating logins and assigning proper permissions to the created logins,

mapping logins to the database and granting appropriate permissions.

. Verifying all instances are up and running.

. Monitoring free space of database.

. Checking the status of backup, and restoration of databases.

. Implementation of SQL Logins, Roles and Authentication modes as a part of

Security Policies for various categories of User Support.

. Managed the migration of SQL Server 2000 databases to SQL Server 2005.

. Fixing orphaned users through stored procedures.

. Monitoring/Maintaining HA options being used in servers Log Shipping.

Contact this candidate