KUSHAL REDDY

DB* UDB ADMINISTRATION

Overview: A self-motivated, goal-oriented team player with demonstrated

records of challenging achievements. An experienced professional

with over 6.1/2+ years of progressive IT experience in Database

Administration and application development on multi platform

environments including UNIX (AIX, Solaris, Linux, HP-UX) &

Windows (NT,2000,XP) applications. As a Database Administrator,

having extensive experience in Data Architect, analysis,

physical and logical database design, installation,

configuration, maintenance, performance monitoring and tuning,

query analysis, backup and recovery, high availability, SQL and

Q replication. Extensive involvement on Data modeling, Design

24X7 databases using Cluster Environments (HACMP, HADR,

Veritas's VVR, GRIDSCALE), Data Warehouse, Fault tolerance,

Security and Disaster recovery planning. Experience in Data

Modeling tools (Erwin, ER Studio, and Rational Data Modeler).

Involved implementing Rational Unified Process for complete

project life cycle. Work extensively with ETL tools like Data

stage, Cognos, Informatica and ETI Extract using VLDB

environments. Excellent work experience in SAP BW/SAP Basis

Administration. Strong technical skills working as a Sybase DBA

and with SQL 2008/2005/2000 and Oracle 7.3/8/8i/9i/10G.

Technical

Skills:

RDBMS: UDB ESE, EEE and EE, DB2 V9.7, DB2 V9.5, DB2 V9.1, DB2 V8.1 &

V8.2 ESE and all Earlier Versions, DB2/6000, DB2MVS/ESA, Oracle,

MS-SQL Server, Sybase Adaptive Server and MS-Access

Languages: COBOL, COBOL II, JCL, SQL, C, Perl, Korn Shell, Bourne Shell,

PL/SQL, C++ and Java

OLTP: CICS/ESA and CICS TS

GUI/Tools: Control Center, DB2 Development Workbench, Application

Development Center, Visual Explain, Health Center, Design

Adviser, Stored Procedure Builder, DPROPR, QMF,DB2 Utilities,

File Aid DB2, Endeavor, IMS/ESA, BMC and PLATINUM Tools, DB2

Connect, MS Office Professional and GRIDSCALE.

BI/Tools: WLM, Query Patroller, Appfluent, DB2 Alphablox, Business

Objects, Cognos and Crystal Reports

App Servers: IBM Web Sphere and Web Logic Web Servers: IIS, Apache and

Apache HTTP Server

OS: z/OS, OS/390, MVS/ESA, UNIX (Solaris (5.8), AIX (3.x, 4.x & 5.x)

Including SP2 and Linux), Windows Servers (NT 4.0, 2000, 2003).

Hardware: IBM RS/6000, IBM P4 P690, P5 Series Servers P595, P575, P570,

SP2, IBM Mainframe ES/9000, IBM 9672, IBM RS/6000 with P-390, 64-

bit Sparcv9, Sun Microsystems sun4u, Sun Spare Station 20,

Compaq Prolaint PL6500R NT Server, IBM X_SERIES_365, PC/AT 486-

586, Pentium Machines.

ERP: SAP R/3, PeopleSoft

Experience

Highlights:

01/10-Present Capital One, VA

Sr. DB2 Database Administrator

Capital One is a fortune 500 company, which is developed into a

good financial service provider in l ess than a decade with

the operation in U.S, Canada and the United Kingdom. . I am

working as a Sr. Database administrator in a team of 4 analysts

and developers. Primary responsibility is to take care of DB2

database with 4.2 TB in SAP R/3 and BW environments on Solaris

9. Primary responsibility also includes maintenance, monitoring,

and problem management reporting on several versions of

Databases and also Database development and support in a BI

production data warehouse/DSS environment (DB2 DWE V8.1) for in

house and client servers.

DBA Tasks and Responsibilities:

. Installed new DB2 subsystems on Solaris SAP based

environments

. Write design specifications, security plans, data migration

plans, and Architecture guidelines

. Performed Overall Database Management and Quality Assurance

. Data Architecture, Data Modeling, getting specifications from

business analysts and Marketing groups

. Setup and modified database manager configuration parameters

and database configuration parameters

. Performed Loading and Unloading of data

. Performed day to day tasks on R/3 and BW environment

(Development/Testing and Production)

. Supported database activities in implementing Dual Landscape

in Production and Development phases

. Performed Database sizing, tablespaces, indexes and log

spaces design & implementation work.

. Maintained Instances, databases, table spaces, in DB2UDB for

developers

. Used db2look, db2move, import/export and load utilities to

move structure and data between different environments

. Installed fixpaks and kept DB2 at most recent level to

overcome application issues and utilize new functionalities

. Supported High Availability in Production and Quality Analyst

Testing Environment through Failover Schemes

. Performed Database restoration from crash recovery using

point-in-time restore roll forward recovery

. Performed Data modeling (logical and physical data modeling

using ERWIN)

. Experimented with Indexes and employed Index Advisor to

improve user report and speed ETL runtime

. Used REORGCHK, REORG and RUNSTATS to optimize system

performance

. Performed backup, restore and migrating data between

different databases/servers

. Migrated databases from V 8.2 to V 9.2 in UNIX environment

. Cleaned up Transaction log as and when needed

. Worked on High Availability Disaster Recovery (HADR) setup on

production servers using Log Shipping mechanism

. Designed/Management of an HACMP cluster for the current

production environment

. Executed shell scripts to perform redundant data base

activities

. Created scripts to monitor table space thresholds deadlocks

lock waits

. Extensively involved in performance tuning of complex SQL

queries for better performance

. Captured Explains for the SQL queries and modified them to

reduce the timerons

. Worked with AUTOSYS teams to establish critical day to day

activities

. Administered user groups to execute certain fenced routines

and functions

. Performed Database sizing, table spaces, indexes and log

spaces design & implementation

. Provided Database security & Audit Design, test &

implementation

. Worked on applications which required Extract, Transform and

Load data from different subsystems into Data Warehouse and

Data Mart

. Used Informatica as an ETL tool to Extract, Transform and

Load data to flat files extracted from the operational

database and exported to the data warehouse setup

. Provided data security solutions with the help of Informatica

Designed, developed and implemented multi-terabyte Data

Warehouse and Data Mart Business Intelligence systems

. Setting up DB2 UDB/Solaris production and development

environments

. Created/modified korn shell scripts for database log pruning

backup/restore of databases and SAP system start/stop

. Used BW accelerator to boost query performance

. Installed SAP application servers for the components CRM5.0

and applied OSS notes support packages

. Setting up all SAP system environments for backup/restore and

log file management using TSM for ERP scheduled via TSM

scheduler

. Upgrading of kernel and applying patches on SAP central

instances

. Provided support to DBG SAP Basis team in performing day to

day database activities

. Creating Stored Procedures, Functions, Packages and Database

Triggers for Database and Application uses

. Used Quest Central for DB2 tools to administer and to modify

the database and database parameters

. Used Cognos 8 BI data integration to provide data merging,

extraction, transformation, and dimensional management

. Improved performance of business queries by generating a

Cognos BI metadata model from a DB2 multi-dimensional model

. Worked with IBM Support to resolve database issues and

communicated with them to resolve database and SQL

performance issues

. Administered Solaris for Database boxes

Environment: DB2 UDB V8.x/V9.1 ESE and V9.5 ESE, SAP R/3, CRM 5.0,

BW, Data warehouse edition,

Quest Central, Solaris and Linux UNIX Shell Scripts (Ksh), Erwin,

Windows, Cognos, Informatica,

BW accelerator, Data stage, Performance Export, Query Patroller, CIM,

DB2 utilities and EMC.

11/08-12/09 JCPenny, Plano, TX

DB2 Database Administrator

JCPenney is one of America's leading retailers and the nation's

largest general merchandise catalog business. JCPenney

offers a wide array of national, private and exclusive brands

which reflects the company's commitment to providing

Customers with style and quality at a smart price. I installed,

configured and maintained DB2 database (500 GB) in

AIX (Unix) platform. I am also responsible to provide support to

development team to develop New Account Opening

and Online Account Opening applications and perform replication

In cross platform (DB2 v9.5 - SQL SERVER 2005

Enterprise Edition) and maintain the database environment in

daily Fashion.

DBA Tasks and Responsibilities:

. Managed OLTP database for development activities to develop

NAO and OAO applications in IBM Websphere 6.0 Platform.

. Designed triggers for Data REPLICATION process from DB2 to

SQL Server to capture delta changes in the database.

. Configured several Client workstations with DB2 UDB ESE and

Express C 9.5 for developers using response files /

unattended installations .

. Configured and maintained Instances, Databases, Tablespaces,

Bufferpools in Windows and Unix environments.

. Configured OLEDB/ODBC driver to support various

authentication types of DB2 and establishing the connection

among databases.

. Migrated DB2 from version 8.2 to version 9.5 in AIX platform.

. Performed Pre and Post migration tasks by configuring

database and instance management files.

. Configured Linked Server for pulling up the data from IBM DB2

v 9.5 to SQL SERVER using SERVER_ENCRYPT mechanism.

. Performed Redirected Restore of the database to support

tablespace container resizing.

. Monitored hit ratios for bufferpools, package cache, catalog

cache using DB ARTISAN on a daily basis.

. Wrote Stored Procedures to support Application development

activities.

. Configured LBAC security policies and security labels to give

access to row and column specific sensitive data to users.

. Used IBM Rational Architect suite to create and modify

database domain models including tablespaces and bufferpools

and database partition groups.

. Resolved deadlocks by configuring DLCHKTIME, LOCKTIMEOUT,

LOCKLIST, MAXLOCKS parameters.

. Configured the database monitor switches for DB

(SYSADM,SYSMON) group to run the regular snapshots.

. Took daily Snapshots at regular intervals on applications,

tablespaces, bufferpools, dynamic SQL statements.

. Managed instance profile securities and user access to

several database environments like Integration, Pre-

Production and Production.

. Configured the DB2GOV configuration file to make it work with

the DB2 Query Patroller.

. Created Table Event Deadlock Monitors for monitoring and

resolving deadlocks in databases.

. Configured WAS Server to support various ISOLATION levels in

Application to minimise deadlocks(CURSOR STABILITY in

PARTICULAR).

. Shell scripting to automate the various phases of build

deployment procedure for NAO/OAO application development.

. Wrote BATCH Scripts for WINDOWS environment to automate

database deployment for application development.

. Scheduled AIX CRON jobs for REORGCHK, REORG and RUNSTATS,

Online/Offline BACKUP and DATA ARCHIVING.

. Performed Full Offline and Incremental backup of

database/tablespace using Veritas Backup Exec.

. Configured database diagnostic logs, error logs, active and

archived log space.

. Commissioned DB2 environment and registry variables to avoid

Stale Connection Problems.

. Responsible for performing online and offline backup, restore

and migrating data between different databases/servers.

. Used DB2 Visual Explain utility to create/analyze access

plans and tweaked the DML's accordingly.

. Performed Database sizing, tablespaces, indexing and log

spaces design & implementation work.

. Prepared and deployed the DDL and DML scripts-build at

regular basis to support NAO/OAO development activities.

. Configured DB2 Connect to integrate data from client server

including Workgroup and LAN based architecture with mainframe

across Sovereign.

. Created the Partition by Range tables for Audit Logging

Activities/Fraud Logging Activities.

. Performed Disaster Recovery Planning for the database using

HADR methodology.

. Commissioned Production Database for Beta release of NAO and

OAO applications.

. Managed diagnostic logs, error logs, active and archived log

space requirements.

. Designed Indexes and employed Index Advisor to improve user

report and speed ETL runtime.

. Worked on XML Query/XQUERY for Audit logging and Development

activities.

. Performed Reverse Engineering of the Database Model from

database schema using Rational Data Architect.

. Management of multiple schemas in Integration/Preprod/Prod

environments.

. Monitoring the applications connected to the database to

evaluate the workload.

. Used DB2LOOK Utility to generate DDL for several database

objects in a specific schema.

. Used DB2PD for database and instance level monitoring and

tuned the database accordingly.

. Used IMPORT, EXPORT, LOAD utility to populate staging and

production tables.

. Used ASNTDIFF utility to compare source and target tables for

sanity check.

. Used DB2CFEXP utility to export instance profile to several

workstations.

. Configured DB2GOV daemon property file to govern application

loads at instance and database level.

. Administered AIX for Database maintenance activities.

. Used DB2 Query patroller to intercept queries and bench

marked the results with the DB2 Governor.

. Created and altered DMS table spaces and added/modified

containers.

. Used DB2GOV utility using NICE to set the priority of the

applications at database level.

. Configured DB2GOV utility rule to set the maximum number of

rows selected and idle time and locks held for applications

connected to the database for specific authorization ids.

. Used DB Visualizer 6.0 for database monitoring activities and

provide support to development teams to use it.

Environment: AIX 5.2, DB2 UDB 8.x/9.x ESE/Express C 9.5,

Rational Data Architect, UNIX Shell Scripts (Ksh), Windows, DB

Visualizer 6.0, IBM Data Studio, WAS 6.0, Veritas backup Exec

9.1, DB Artisan.

03/07-10/08 UHC (United Health Care) of Minnesota, MN

DB2 Database Administrator

UHC of Minnesota, a major insurance farm in state of MN.

Enterprise Analytic Environment's (EAE) also known as EAW is the

major UDB data warehouse for UHC of Minnesota's business,

existing data warehouse needs to upgrade to new Hardware with

IBM's new BCU (Balanced Configuration Unit) and BPU (Balanced

Partition Unit) architecture to accomplish the growth and

demand. I was responsible for installing, configuring and

providing support to both production and development.

Responsibilities included developing and maintaining production

staging test and development DB2 UDB databases on AIX and Linux.

I was also responsible for replicating data across various sites

using DPropR Tool.

DBA Tasks and Responsibilities:

. Involved in providing performance tuning and monitoring

support, providing recommendations for a conversion of a

formerly Sybase-hosted data mart to DB2 UDB for AIX.

. Developed scripts to give the development team more robust

text-based access to snapshots and event monitors, iostats,

top and similar statistics.

. Involved in preparing space reports, bufferpool analysis,

full explains on SQL with index recommendations, database

level and instance level configuration

. Maintained and executed IBM DB2 utility jobs

. Changed the database instance and database configuration

parameters for concurrency, authentication and performance

and allowing remote clients accessing server.

. Used Health Monitor to monitor health of a database and

configured EMAIL notification to send email about scheduled

job and database problems

. Used the database maintenance utilities like REORGCHK, REORG,

and RUNSTATS to ensure optimal performance of the replicated

database.

. Involved in creating new disaster recovery strategies

depending on the sensitivity of the data held by respective

databases.

. Involved in granting various authorizations and privileges to

different users

. Created DDL scripts for database objects and schema

modifications

. Converted DB2 to use ssh instead of rah using public key-

based authentication and RSA encryption.

. Involved in benchmark testing in the new HW environments and

compare that with existing old environment before switching

to new.

. Involved redesign the replicated tables moving to proper

redesign partition group considering equal data distribution.

. Involved database Backup/Recovery/Roll Forward as part of DBA

task. Restore a table from offline backup using DB2.

Environment: DB2 UDB V8.2 ESE with DPF and EE, Sybase, Windows

2000, DB2 Connect Enterprise, DB2 HPU & DB2 utilities Korn

shell, BMC Patrol, AIX 5.3.

5/06-02/7 Morgan Stanley, IIG, Data Services & Database Engineering

(DBE), NY

DB2 Database Administrator

Morgan Stanley is one of the leading Security Banking, Financial

Investment & Brokerage Firm in Wall Street. Individual

Investment Group (IIG) is responsible for Individual Investments

and supporting Financial Advisers (FA). Firm has braches all

over the nation and world wide. IIG main objective is to support

all the investment products and also provide appropriate

information to Financial Advisers to support their clients.

DBA Tasks and Responsibilities:

. Very Large & Multiple Data Warehouse environments for

Development, Fail over Production environment (aka QA) and

Production environment. Mixed UDB ESE V8.x & UDB V7.x

environments.

. One of the tasks to migrate Production, QA and Development

server to V8.x from V7.x. During migration we had experienced

many challenges. RAW devices used for DMS tablespaces.

. Many Data Marts are EE databases in Windows environments.

Brio is used for reporting purposes.

. Support many Informatica UDB repositories in UNIX and windows

environments.

. One of the most important business requirements is to provide

and maintain SLA of each project, which is one of the

challenges for DBAs. Many projects get developed, moved to QA

and finally to production using Informatica, Java Stored

Procedures and Brio Reporting.

. Most reporting happen on Data Mart side and DWH is used for

business ETL processing.

. More than 100 cron jobs triggered by different time in

different requirements. Automated the scripts to send email,

page when any failure occurs.

. Participated evaluation of TeraData for the new redesigned

DWH to overcome the challenges facing because of out dated HW

and DB2 for this very drastic data growth for IIG department.

. One of the major challenges to tune the OLAP & DSS support

SQL's to perform faster using partitioned and non-partitioned

tables.

. Interacting with the users, developers and troubleshoot the

problems involved with the development team. Many Scripting

done for different applications requirement to extract data.

. Participated on tuning many Java stored procedures and also

moved stored procedures from development environments to QA,

PROD and other different environments.

. Worked with Autoloader extensively on EEE -DW Environment.

Involved conversion of autoloader scripts to load scripts for

V8.x. Used load query command to check the status of load

while loading very large tables.

. Solaris OS commands, OS error log file, TOP and SUDO access

to all Database server.

Environment: Solaris 5.x, AIX 4.x and 5.x, Windows 2003 Advanced

Servers, DB2 UDB V7.2 EEE and EE, UDB V8 ESE with DPF,

Informatica, Windows 2000, DB2 Connect Enterprise, DB2

utilities.

11/04-04/06 Navistar Technology & Engineering Center, India

DB2 Database Administrator

Navistar is the market leader for Engine manufacturing and

produce custom built trucks and school buses. Multiplexed

Electronic System (MES) is to automate the signals in the new

generation vehicle (NGV). This system is to program a ROM to

hold the information about the customized vehicle and its

complete signal system.

DBA Tasks and Responsibilities:

. Design and implement new database Schema on different

database servers.

. Physical database design, creation, implementation &

maintenance operations (file system mount points & storage

parameters) and logical database mapping to physical database

(storage calculations, file systems, tablespaces, rollbacks,

indexes, control files & data files).

. Actively involved in Data modeling using Rational Data

modeler and Erwin.

. Actively involved in designing and implementation of Data

Warehouse objects.

. UDB DB2 installation on AIX and Windows NT. Scripted

different DB2 Utilities such as reorgchk, reorg, and runstat

periodically.

. Creation of database, table-spaces, index-spaces, and

database objects

. Using snapshot monitor on databases for table spaces, tables

etc. Calculated the buffer pool hit ratios for various buffer

pools assigned for different table spaces.

. Users and User group creation and privileges assigned in

database level.

Environment: IBM RS/6000, AIX, DB2 OS/390, DB2 UDB V6.x EEE, SQL

Server, Windows NT and BMC and Platinum Tools

Education: Bachelor of Engineering in Computer Science & Technology from

Osmania University, India

Reference: Available on request

Contact this candidate