KARTIK CHERUKUMUDI

Phone #: 201-***-****

Email: abncrf@r.postjobfree.com

Professional Summary

Over 6+ years of IT experience in Database Administration, System

Analyst, Design and Support of MS SQL Server 2008/2005/2000 in

Production, Development Environments, Test, Replication and Cluster

Server Environments.

Installation, Upgrade, Configuration and Administration

. Hands on experience in installing, configuring, managing, upgrading

and migrating, monitoring and troubleshooting SQL Server

2008/2005/2000.

. Experience in upgrading SQL Server software to new versions and

applying service packs and hot fixes and unattended Installation.

. Experience in Installing and Configuring SQL Server Active/Passive

clusters.

. Experience in working with Windows 2000 Data Center Server and Windows

2000 Advanced Server.

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

Capacity Planning.

Backup and Disaster Recovery

. Implemented backup strategy based on the client needs and

requirements.

. Implemented different types of Replication Models such as Transaction,

Snapshot and Merge (Corporate Merge) in SQL Server 2000 and SQL Server

2005 in OLTP Environments.

. Implemented and successfully tested Database Mirroring in SQL Server

2005.

. Implemented and successfully tested Log Shipping in SQL Server 2000

and SQL Server 2005.

. Experience in Database backing using Database Maintenance Plan Wizard

and scheduling it in accordance with the management.

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.

. Help developers find slow running queries, high resource consuming

queries and help developers optimize them.

. Identify and resolve blocking and deadlock scenarios and perform lock-

wait analysis.

. Identify and eliminate index fragmentation and help with index

maintenance.

. Use DMV's to help identify poorly performing queries, index usage and

generate other helpful statistics as required.

. Experience in Configuring and Managing Linked Servers, data transfer

between SQL Server and other heterogeneous relational database such as

Oracle and DB2.

. Worked with popular Monitoring Solutions such as SQL Diagnostic

Manager, Quest Spotlight and Light Speed

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

Server Connectivity, Query Optimization, Database Maintenance Plans

and Database Consistency Check using DBCC commands.

. Created, altered, maintained system roles and permissions to users on

various database objects.

. Strong debugging skills and the ability to solve complex problems.

Server Consolidation

. Experience with SQL Server Virtualization

. Have created and delivered Phase I (Solution Framing/Assessment) and

phase II (Design) approach documents for various clients.

. Helped clients decide with hardware specs and VMware/Hyper-V

selections as well as different licensing solutions.

. Helped clients decide on the best backup strategy for the consolidated

servers.

. Helped clients save resources/licenses through consolidation

projects.

Database Design and Implementation

. Experience in using Data Modeling Tools like Microsoft Visio.

. Experience in Database Capacity Plan

. 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

. Experience in contacting Microsoft PSS and other vendors for product

and technical support

. Experience in providing 24/7 support.

TECHNICAL SKILLS:

Languages C, HTML, SQL, T-SQL, XML, .NET

RDBMS MS SQL Server, MS-Access, Oracle

Operating Systems Windows Server and Desktop Operating Systems

up to Date

Tools SQL Server Management Studio, Enterprise Manager,

SQL Lite

Speed, Profiler, System Monitor, Query Analyzer,

Export & Import (DTS), SQL Server Integration

Services (SSIS), SQL Server Reporting Services(SSRS),

Erwin, SVN Change Control, Idera SQL Audit and Safe

Backup tools.

Education:

Bachelor of Engineering- India

Master of Science- USA

PROFESSIONAL EXPERIENCE:

Xtivia Inc, Colorado Springs, CO Mar 08 -Present

SQL Server & Systems Administrator

SQL Server and Systems Engineer for Xtivia's Virtual DBA(http://www.virtual-

dba.com/). Remotely support, tune, administer, analyze, and architect SQL

Server databases for different clients. Install, configure and maintain SQL

Server 2000, 2005 & 2008 databases in stand-alone and active-passive

cluster environments. Design, configure and troubleshoot various

environments using Replication, log-shipping and mirroring. Deploy

scripts/application for monitoring and maintenance of jobs, processes and

system health. Analyze performance issues using Perfmon, Profiler, Database

Engine Tuning Wizard and scripts to identify and implement solutions to

bottlenecks. Provide 24 hour on-call support for all database-related

issues and problems.

Responsibilities:

. Involved in Migration of SQL Server 2000 to SQL Server 2005

. Database capacity planning and Space forecasting.

. Database troubleshooting and raising Service request s with MS support

and applying patches

. Setup Database Mirroring and log Shipping for different clients.

. Performed Server Consolidation/Virtualization for different clients.

. Advanced Tuning and detail Health Checks for SQL Server.

. Setup replication for different clients based on their needs.

. Helped Development team in Deploying and testing application with SQL

Server 2005 as backend.

. Responsible for change management maintenance.

. Use of hardware configurations, query and index tuning, memory

settings to achieve 10-60% gains in database and query performance.

. Effectively support and maintain VLDBs (very large databases- over 1

terabyte in size ).

. Creating Backup strategies and scheduling them for execution.

. Created Documentation to install SQL server, apply service pack, hot

fix on production, Development, testing environments.

. Security User Management, Privileges, Roles, Auditing, Profiling

Authentication.

. Development of automated daily, weekly and monthly system maintenance

tasks such as Database backups, replication verification, database

integrity verification and indexing updates.

. Daily monitoring of Database performance and SQL Jobs and bottlenecks

of SQL Server including network related issues with SQL Server.

. Performance tuning and optimization of procedured and queries.

. Worked with SQL Server Profiler to generate traces for tuning

analysis.

. Used Diagnostic Manager from Idera solutions for monitoring SQL

Servers

. Had good experience in 24/7 Production support.

Environment: SQL Server 2000/2005 Enterprise Edition, Windows 2000

Advanced Server/Windows 2000 Server, HP Proliant Dl585 server,Idera

Diagnostic Manager, SQL Lite speed.

LEHMAN BROTHERS, NJ

Mar 06- Mar 08

DB-Systems Engineer

Lehman Brothers, an innovator in global finance, serves the financial needs

of corporations, governments and municipalities, institutional clients, and

high net worth individuals worldwide. Founded in 1850, Lehman Brothers

maintains leadership positions in equity and fixed income sales, trading

and research, investment banking, private investment management, asset

management and private equity. Consulted for Lehman Brothers through JSMN

International (Inc 500, http://www.jsmninc.com/) which provides business

solution for clients across the globe. It offers consulting services and

training services for its clients.

Responsibilities:

. Migrated Sql server 2000 databases into Sql Server 2005.

. Daily monitoring of the database performance and network issues.

. Performance tuning, and optimization of procedures and queries.

. Rebuilding indexes on various tables.

. Worked with SQL server Profiler to generate the traces.

. Monitored the database and alerts.

. Setup and Maintenance of Clustering to provide High Availability to

SQL Server.

. Managed databases in clustered environments both Active-Active and

Active-Passive.

. Maintaining both DEV and PRODUCTION servers in sync

. Creating back up strategies and scheduling them for execution.

. Created various reports and scheduled them as daily and monthly

reports.

. Helped Development Team in deploying and testing the application,

which uses SQL Server backend.

. Providing 24*7 supports to SQL application developers in implementing

the applications on production server.

. Redesign of database architecture with help of Microsoft Database

development group and internal staff to increase application

concurrency and performance.

. Monitoring SQL server LOGS, Application logs and analyzing the logs.

. Connecting SQL servers remotely using Terminal services.

. Created custom reports

Environment: MS SQL server 2000/2005, Windows 2000, Clustering, Enterprise

manager, Verities backup solution, DTS, SQL profiler. Crystal Reports,

Erwin

PV Hospitals

Jun 03 - Jul 05

SQL Server DBA III

Padmavati medical hospital dedicated to the diagnosis and treatment of

virtually every type of complex illness. This project dealt with creating

and maintaining patient records for both In-patient and out-patient wards

including the pharmacy records. The client has various applications running

on different servers. Part of the responsibilities included supporting

development server, assisting development team and also support of

production server.

Responsibilities:

. Installation of MS SQL Enterprise servers on test and development boxes.

. Involved in SQL Server 2000 installation and Upgrade in Test,

Development, QA & Production servers

. Administering the MS SQL Server by creating user logins with appropriate

roles, monitoring the user accounts, creation of groups, granting the

privileges to users and groups.

. Performing Backups & Restores on demand

. Responsible for Database Performance tuning and faster response

. Designing Maintenance Plans and other DBA Automation jobs with

o Complete/ Differential / Transactional Backups

o Re-indexing

o Updating Statistics

o Shrink Files

o Stored Procedure Recompiles

o DBCC Update Usage

o Database Consistency Checks etc

. Troubleshooting Performance Issues using various tools like SQL Profiler

and other commands.

. Collecting various Performance Counters that help in Capacity planning

. Managed Servers in Active/Active Clustering Environment

. Monitor NT Event log for system, application errors, available disk

space, Backup registry, keep emergency repair disk as current

. Used NT Performance monitor to monitor CPU & Memory usage and SQL Server

Profiler to monitor and record database activities of particular users,

applications

. Rebooting SQL Servers Services

. Involved in Linked Server setup, which allows access to the distributed,

heterogeneous queries against OLE DB data sources for other SQL Servers,

EXCEL, MS ACCESS, Text files.

. Provide 24 X 7 dedicated support to all Production, QA & Development MS

SQL Server Environments

. Monitor Server Level Blocks/deadlocks & Maintain all the OLTP Servers

with Maximum Database Availability, Reliability & Investigate and resolve

any Database Related issues /performance related issues with Minimal

Downtime & Maximum Reliability

. Review / test / apply all database changes to all environments including

QA, Development and Production Servers. Monitor SQL Error Logs

/Schedule Tasks/database activity/eliminate Blocking & deadlocks /user

counts and connections/locks etc.

. Perform Capacity Monitoring and short and long-term capacity planning in

collaboration with development resources, System Administrators and

System Architects.

Environment: Windows2003, MS SQL Server 2000, TSQL, SQL Lite Speed, Visual

SourceSafe6.0 etc

Contact this candidate