Prasad Yanigandla abnul5@r.postjobfree.com

Gaithersburg, MD 301-***-**** Mobile

______________________________________________________________________________________

Summary: Over 15 years of IT experience (6+ years of SQL DBA) in Database Administration,

System Analyst, Design, Development and Support of MS SQL Server 2005/2000/7.0 in

Production, Development, Test Environments. Experienced in production support 24X7.

Technical Summary:

Installation, Upgrade, Configuration and Administration

Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and

troubleshooting SQL Server 2005/2000 on Windows 2000/2003 and VMWare.

Experience in Upgrading SQL Server 2000 to SQL Server 2005 (in place/side by side & side

individual databases upgrade)

Experience in setting/configuring SQL Mail/Database Mail// smtp mail.

Worked on SAN for SQL Server Databases and good understanding in Capacity Planning.

Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and

other heterogeneous relational database such as Oracle and DB2.

Creating Logins/Users and granting/revoking permissions and maintained system roles and

permissions to users on various database objects.

Backup and Disaster Recovery

Design and implement different types of Replication Models such as Transaction, Snapshot and

Merge in SQL Server 2000 and SQL Server 2005 in OLTP Environments.

Successfully set up and tested Database Mirroring in SQL Server 2005.

Successfully set up and tested Log Shipping in SQL Server 2000 and SQL Server 2005.

Experience in Database backup using Database Maintenance Plan Wizard/RedGate (Third party

backup tool).

Auto databases refresh from production server to develop/test servers using t-sql script.

SQL Server 2000/2005 Services (DTS/SSIS)

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat File, Bulk load,

Oracle to MS SQL Server by using BCP utility, DTS/ SSIS Services and linked servers.

Performance Monitoring and Tuning

Monitor the production server using tools like SQL Profiler, Windows Perform, Performance

Counters and SQL server logs for Monitoring and Tuning SQL Server.

Worked with popular Monitoring Solutions such as SQL Diagnostic Manager (Idera – third party sql

server monitoring tool), setting up alerts and Performance Monitor etc.

Experience in MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity,

Query Optimization, Database Maintenance Plans and Database Consistency Check using DBCC

commands.

Strong debugging/trouble-shooting skills and the ability to solve complex problems.

Stored Procedure, Functions, Views and Cursors

Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views,

User defined data types, Cursors and Indexes using T-SQL.

Experience in reviewing Stored Procedure/Triggers for performance fine tuning.

Database Design and Implementation

Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity

by using Triggers and Primary and Foreign Keys.

Implemented complex business logic into database design and maintained the referential integrity

via triggers and constraints.

Good knowledge of System Development Life Cycle (SDLC).

Good in implementing SQL Server Security and Process Control.

Experience in Creating Roles and Assigning Permissions to the users.

Experience working on Production Server including Weekends and change control support over

nights

Technical Skills:

Microsoft SQL Server 2000 & 2005, Sybase 12.x, 11.9.2, 11.5, 11.0.2,

RDBMS

System 10, Sybase 12.0,11.5, Oracle 8.x, Oracle 7.x

SAN, Sun E10K, Hp9K, IBM SP/2 Nodes, IBM Compatibility PC-ATs,

Languages/Packages

Intel 80x86, Pentium

RedGate SQL Backup tool, Idera Diagnostic Manager, MOM

Tools

(Microsoft Operating Manger) tool, TestTrack, VSS, Erwin Case

Tools, DBArtisan, Sybase Central, SQL Advantage, FoxPro,

PowerBuilder, VB, MS Office, Visual SourceSafe, FileMon, ExamDiff

Pro, Remedy VSS, TestTrackPro etc.

Windows 2000 & 2003, Windows NT, Windows XP Pro, Sun Solaris

O/S

2.6 & 2.8, HP UNIX, AIX, Novel Netware 3.12, Ms Dos.

SAN, Sun E10K, Hp9K, IBM SP/2 Nodes, IBM Compatibility PC-ATs,

Hardware

Intel 80x86, Pentium

Diploma courses:

Diploma in RDBMS concepts

Diploma in Programming Applications

Professional Experience:

Celerity

Company:

Date: Feb’2009 to Present

Title/Role: Sr. SQL Server Database Administrator

Project (short term) at Freddie Mac,VA :

I am currently working as SQL Server DBA supporting/developing a data-warehousing project. I

was involved in a full lifecycle design process of a data quality rules engines. Given the high-

volume of data, I contributed to the design from a DBA’s perpective on system scalability,

performance and maintenance. In addition, I assisted the development team to get up to speed

on their SQL Server knowledge and proficiencies.

Responsibilities:

SQL Server 2000/2005 Install/upgrades w/ patches

Database Architecting - Physical & Logical Database Design

Technical support with development team

Writing Scripts (T-SQL) /Stored Procedures/User Defined Functions

Optimizing/ Performance Fine Tuning the Query/Scripts/Stored Procedures

Data import from DB2/SAS using SSIS packages

Import/export Excel/Text files into SQL Server Tables

Ensure & trouble-shoot all scheduled jobs like Scheduled Backups/maintenance and SSIS

packages etc.

Database Architecting - Backup & Restore

Strong troubleshooting/diagnosing/analyzing skills in SQL Server

H/W & S/W: Windows 2003,, Microsoft SQL Server 2005,SSIS packages, T-SQL, Profiler

Company: SRA International Inc.

Date: Apr’2008 to Feb’2009

Title/Role: Sr. SQL Server Database Administrator (Production Support)

Project At NIH (National Institute of Health), Bethesda, MD

I was working as Sr SQL Server DBA and supporting production/development/test servers 24/7

on call support. I am responsible for application support, Server/Databases, monitoring, tuning

and maintaining all database servers, Backup & Recovery, Performance Tuning of Query &

database in a production environment on call rotation by carrying Blackberry.

Responsibilities:

SQL Server 2000/2005 Install/upgrades w/ patches

Review/tuning Stored Procedures/Triggers

Technical support with development team

Database Architecting - Backup & Restore using RedGate

Trouble-shoot all scheduled jobs like backups, maintenance, user jobs etc.

24/7 Support of multiple production/development/test SQL Server 2000/2005 database

servers Configuring SQL Mail/DB Mail

Monitoring the performance of all the servers using Idera Diagnostic Manager & MOM

(Microsoft Operating Manager) tools.

Database Architecting - Physical & Logical Database Design

Transactional, Merge and Snapshot Replication

DBA - Performance Tuning (Query & Database)

Automate the databases daily refresh from Production Server to Development/Test

Servers with Scripts.

H/W & S/W: Windows 2000 & 2003,, Microsoft SQL Server 2000 & 2005, DTS/SSIS packages,

T-SQL, Profiler, RedGate SQ Backup tool, Idera Diagnostic Manager, Microsoft Access, ISQL,

Remedy, VSS, TestTrackpro etc

Northrop Grumman Information Technology

Company:

Date: Jun’ 2006 to Apr’2008

Title/Role: Sr. SQL Server Database Administrator (Production Support)

Project At NIH (National Institute of Health), Bethesda, MD

I was supporting/Managing about 60 Production/Development/test SQL 2000 & 2005 Servers

including about 70 production/development databases on shared servers. I was responsible for

building, monitoring, tuning and maintaining all database servers, Backup & Recovery,

Performance Tuning of Query & database in a production environment of 24x7 on call rotation by

carrying Blackberry.

I upgraded (in place & side by side) SQL 2000 to SQL 2005 on Windows 2003 and migrated

about 70 SQL databases from SQL 2000 to SQL 2005 on shared servers (on both Development

& Production Servers) by transferring/syncing login accounts with SQL 2005 configuration

settings.

Responsibilities:

SQL Server 2000/2005 Install/configuration with patches

Upgrade SQL 2000 to SQL 2005

SQL Server 2000/2005 – Server/Databases Performance Tuning.

24/7 Support of multiple production/development/test SQL Server 2000/2005 database

servers

Ensure & trouble-shoot all scheduled jobs like Scheduled Backups and Combo Backups,

maintenance, user jobs etc.

Creating/copying/moving/refreshing databases from one server to another and

creating/synching users and roles

Mirroring/Log Shipping on SQL Server 2005 (on Sharepoint Servers)

Configuring SQL Mail/DB Mail

Monitoring the performance of all the server using Idera Diagnostic Manager & MOM

(Microsoft Operating Manager) tools.

Strong troubleshooting/diagnosing/analyzing skills in SQL Server

SQL Server database security

Physical & Logical Database Design

Backup & Restore using RedGate tool/native tool

Creating database users and roles and monitoring

Creating & maintaining DTS/SSIS Packages

Transactional, Merge and Snapshot Replication

DBA - Performance Tuning (Query & Database)

Review Stored Procedures/Triggers

Technical support with development team

H/W & S/W: Windows 2000 & 2003,, Microsoft SQL Server 2000 & 2005, DTS/SSIS packages,

T-SQL, Profiler, RedGate SQ Backup tool, Idera Diagnostic Manager, MOM (Microsoft Operating

Manager) tool, Microsoft Access, ISQL, Remedy etc

Company: CTG Inc.

Jan 2006 Jun 2006

Date:

Title/Role: Sr. SQL Server Database Administrator (Production Support)

Assigned to 6 month Project at NISH, Vienna, VA

I was responsible in maintaining the SQL Server databases, databases administration,

database trouble-shooting, database backup and recovery, performance tuning of query and

database, database and table design. I was closely working with the development team in helping

them in optimizing the query, arranging the required data available on development, testing, and

prototyping servers from production databases. I was responsible supporting the databases 24/7

by carrying the pager and also working on weekends and after hours during change management

deployment whenever required.

Duties included as follows: -

Monitoring the event log and Server error log for all the instances.

Ensure all scheduled jobs like backups, optimization etc.

Monitoring Databases and disk space

Writing scripts to automate DBA tasks

Check the current activity to look for hung transactions from the previous day.

Database Architecting - Physical and Logical Database Design

Database Architecting - Stored Procedures and Triggers

Database Architecting - Backup and Recovery

DBA - Performance Tuning (Query and Database)

General Maintenance and Troubleshooting

Creating and maintaining DTS Packages

H/W and S/W: Pentium, Windows 2000, Micro Soft Access, Micro Soft SQL Server 2000, DTS

packages, VB .NET, ADO.NET, T-SQL, Profiler, ISQL, BCP, ExamDiff Pro, FileMon, Visual

SourceSafe, Remedy etc

Northrop Grumman Information Technology

Company:

Date: Sep’ 2002 to Jan’2006

Title/Role: Sr. SQL Server Database Administrator

Project At CDC (Center for Disease Control and Prevention), Hyattsville, MD

I was supporting Production/Development/test SQL 2000 Servers in the administration of a

multi-database environment in a 24x7 environment and also handled the Data

Conversion projects of ICD9CM, ICD10CM, UMLS word documents to SQL Server Database

Tables using T-SQL, VB.NET, DTS, Access database etc.

Responsibilities:

SQL Server Installation/configuration

Monitoring event & server log and disk space

Physical & Logical Database Design

Trouble shooting Databases

Database Performance Fine Tuning - Query/Server Optimization

Writing scripts to automate DBA tasks

Day to day maintenance of applications

Backup & Recovery of databases

Database space monitoring and ensuring backups

Writing/Reviewing/Testing/Tuning Stored Procedures & Triggers

H/W & S/W: Pentium, Windows 2000, Micro Soft Access, Micro Soft SQL Server 2000, DTS

packages, VB.NET, ADO.NET, T-SQL, ISQL, BCP, XML etc

Cambridge Systems, Sterling, VA

Company:

Date: Mar’2000 to Sep’2002:

Title/Role: DBA/Developer

Project at FedEx, Memphis, TN, USA

As a Sybase/SQL Server DBA, responsible for maintaining the Development/Test database

Servers. I was also responsible day-to-day database maintenance, Server / Application

Performance-Tuning and trouble-shooting, Backup & Recovery, Database Optimization,

logical/physical design etc.

Responsibilities:

Database Architecting - Physical & Logical Database Design

Database Architecting - Performance Planning

Database Architecting - Stored Procedures & Triggers

DBA - Performance Tuning (Query, Server & Database)

DBA - Regular Database Maintenance, Housekeeping & Database Optimization

Database management

General Maintenance and Troubleshooting

All the mentioned backup strategies were automated & scheduled using Sybase utilities

& Unix shell scripts (korn).

H/W & S/W: Pentium, Windows NT, SYBASE ASE 11.9.2 & 12.x, Oracle 8.1.6, SQL Server

2000, and UNIX Sun Solaris 2.8, and Sybase Central, Unix Shell Script, DTS,T-SQL, ISQL, bcp,

SQL*Loader, PL/SQL etc

Transworld Information Systems, Iselin, NJ

Company:

Date: Jan’1998 to Mar’2000:

Title/Role: DBA/Developer

Project at EXCEL Communications, Dallas, TX, USA

Worked in a team in design, development, and implementation of Online Payment System. Developed most

of the back-end Sybase code T-SQL, Stored Procedures/Triggers, UNIX shell scripts, ensuring fulfillment of

customer needs and business objectives, focusing on automation, reusability, and portability of the scripts.

I was also responsible for the day-to-day maintenance and support of Sybase/SQL Server

Production/Development/test Database and worked closely with development team to resolve

their query/server performance issues.

Responsibilities:

Writing/Reviewing/Testing/Tuning Stored Procedures & Triggers

Writing UNIX shell scripts for automating scheduled DBA tasks.

Performance Fine Tuning - Query/Server Optimization

Physical & Logical Database Design

Granting access to the Server

Server monitoring and preventive maintenance

Error Log monitoring

H/W & S/W: Pentium, Windows NT, SYBASE 11.9.2,11.5, Sybase Replication 11.5.x, UNIX Sun

Solaris 2.6, HP UNIX, AIX, DbArtisan, Sybase Central, SQL Server 7, Unix Shell Scripting, & C.

Maxworth Orchards (India) Ltd., Madras, India

Company:

Date: Jul'1994 to Nov'1997

Title/Role: Project Lead/DBA

In this project, I worked as a Project Lead and subsequently as a Sybase DBA. As a SYBASE

DBA I was responsible for the overall system performance, back-end development, total

Database management and reliability of Sybase Server.

Responsibilities:

Designing and creating the initial database

Physical & Logical Database Design

Granting access to the Server

Writing stored procedure & triggers

Database management

System configuration settings

Server monitoring and preventive maintenance

Server startup and shutdown

Ensuring database backup

User and group maintenance

H/W & S/W: Pentium, Novell Netware 3.12, Windows for workgroups, FoxPro for Windows,

Visual Basic, SYBASE System 10, and Erwin Case Tools.

Kabsons Group Of Companies, Hyderabad, India

Company:

Date: Jun'1993 to Jul'1994

Title/Role: EDP In-charge/Analyst

I was maintaining the existing commercial applications in the beginning by modifying the reports as per the

needs of the users and also used to create the management information system reports.

Later on redesigned the commercial applications of Financial Accounting System & Material Management

System for the entire group of the companies according to the present requirement and maintained them

with the changes/modifications as required by the users and the management. I was totally responsible and

in-charge of the entire EDP department.

H/W & S/W: Pentium, Novell Netware 3.12, Windows for workgroups, and FoxPro

Contact this candidate