Manager Development

SAGAR REDDY

[pic]

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

Mobile: 908-***-****

CAREER OBJECTIVE

. Seeking a challenging position in a professional, growth-oriented

company, for an opportunity to utilize database design, modeling,

administration, Warehouse, performance tuning/monitoring and application

development skills.

SUMMARY

. Over 15 years of experience in Software Analysis, Data modeling, design,

development, testing and implementation, Specializing in developing

Application Software using IBM Mainframes, RDBMS and Client /Server

environment.

. Over 9 years of IT experience in Database Administration with about 7

years as DB2 UDB DBA (EE / EEE/ESE) and 2 years as DB2 DBA on OS/390

. IBM Certified DB2 UDB 9/8.1 DBA (LUW)

. Extensive experience in installation, database development,

implementation and maintenance of large-scale production/development

databases

. Expertise in Creating databases, table spaces, tables, indexes and

configuring database partitions

. Database maintenance, backup, recovery, performance monitoring, tuning,

maintenance of logs, problem identification and resolution, security and

disaster recovery planning.

. Strong in performance monitoring and fine-tuning of database for optimal

performance of SQL queries using Visual Explain.

. Extensive experience in REORG, RUNSTATS, RECOVER/RESTORE, LOAD, QUIESCE,

IMPORT, EXPORT, DB2ADVIS,DB2LOOK, and DB2MOVE.

. Extensive experience in migrating databases.

. Extensive experience in Logical modeling and physical modeling

. Developed complex mappings and work flows using Informatica

. Extensive knowledge in shell scripting on AIX and Sun

. Extensive experience in DB2 on OS/390 using JCL,SPUFI, Platinum tools,

BMC software on OS/390

. Extensive knowledge in High Availability Cluster Multi-processing (HACMP)

for Unix AIX for DB2 UDB.

. Strong in SQL PL stored procedure development.

. Have strong communication skills, well-organized, and able to work

individual or in a group.

. Provide 24X7 production support, problem resolution and recovery

processes during an outage resolution

HARDWARE/PLATFORMS

. RS 6000 SP & P series, SUN Solaris, Tru64 Digital Unix, SunSparc

1210/1000, IBM 3090,ES 9000

SOFTWARE /LANGUAGES

. COBOL,JCL,VSAM,CICS, Java, XML, SQL, Unix Shell Scripting, Erwin

3.5.x/4.x, Quest TOAD 8.x, DB2 Connect 9.x/8.x/7.x,, ODBC, JDBC, DB2

CLI, Informatica (ETL), Datastage, WSAD, Apache 1.3.x Office 2000, BMC

Patrol, DBArtisan, DB2 Replication, DB2 Connect EE v9/v8/v7,SPUFI,QMF,DB2

File-Aid, Omegmon and CA-7.

DATABASES/OPERATING SYSTEMS

. DB2 UDB EE/EEE/ESE V9.x/8.x/9.x, SQL Server 7.x/2000, DB2 On OS/390, MS

DOS, WINDOWS XP/98/NT/2000, AIX 4.3.3/5.1, HP UX 11.0, Solaris and

MVS/ESA

PROFESSIONAL EXPERIENCE:

HSBC Bridgewater, NJ July 05 to till

date

DB2 UDB DBA

HSBC is one of the large banks in US and globally. This group has OLTP and

Data Ware house databases sizes ranging from 16 GB to 4 TB. All the

databases are on DB2 UDB ESE V9.1.

Responsibilities:

. Physical Designing of DB2 instances and databases.

. Involved in database file system designing and space estimation.

. Creation of databases, table spaces and tables

. Maintain the log shipping for standby server for disaster recovery

. Scheduled jobs for backup, database maintenance utilities.

. Migrating databases from older version to newer version.

. Configuration parameters are tuned to optimum level.

. Upgraded the DB2 UDB from v8.1.2 to 9.1 (fix pack 4).

. Migrating objects from Development to Test, and Test to QA and QA to

Production environments.

. Copying data from Production to Test Environment for Developers to

test their applications.

. Development of Stored Procedures.

. Development of shell scripts

. 24x7 production support for OLTP and Warehouse databases.

Environment: AIX,Sun Solaris OS, Sun Sparc Servers, BMC SmartDBA, DB2 UDB

V 8.x/9.x, SQL PL, Veritas cluster service

Wells Fargo Bank, MN Aug 2004 - June 2005

DB2 UDB DBA

Wells Fargo bank is the third largest bank in USA. WFSC is the mortgage

services company of the bank. This group has very large data warehouse and

data marts of the size of 4 TB, which is loaded on daily basis. This is 12

partition database having 4 logical nodes on each of 3 physical nodes.

Responsibilities:

. Provided 24x7 production support for the multiple multi-partition

databases.

. Designed and implemented disaster recovery strategy for database.

. Resolved the backup and restore issues for the production database.

. Flash copy is used at the SHARK (ESS) level to mirror the complete

database on to the other set of servers for users to query the

database.

. Restored successfully the multi partition production database of the

size of 4 TB.

. Implementing incremental backup and restore procedure for the multi

partition database.

. Designing and implementing the database object changes to the data

warehouse database.

. SQL queries and database performance tuning.

. Worked on improving the performance of loading the data using the DB2

LOAD utility.

. Upgraded the DB2 UDB from v8.1.2 to v8.1.4 (fix pack 4).

. Used utilities like db2governor to set the limits for the query result

sets.

. Day to day monitoring database memory usage and performance.

. Developed scripts and procedures to monitor production databases.

. Implementation of deadlock and lock event monitors.

. Implementation and configuration of the Query Patroller.

. Implementation and configuration of the Health Monitor.

Environment: IBM P670 Server, AIX 5.1(64 bit), Tivoli storage Manager, DB2

UDB V8.1.4, SQL PL Stored Procedures.

GUIDE ONE INSURANCE GROUP Desmoines, Iowa Feb 02 to

July 04

DB2 UDB DBA

. Involved in Creating instances, configuring Database Manager and

Database.

. Involved in Database design and Creation (Development and test),

Configuring database client and server by using CCA utility.

. Scheduled jobs for REORG, RUNSTATS and Rebind utilities.

. Prepared Full backup, incremental backup and restore scripts.

. Scheduled jobs for Backup.

. Migrating objects from Development to Test, and Test to QA and QA to

Production environments.

. Copying data from Production to Test Environment for Developers to

test their applications.

. Tuning Database Manager, Instance, Database Monitoring, Lock

contention, I/O contention, Table Spaces, Buffer pools, and tables by

using Event Monitor and Snapshot Monitor.

. Tuning of SQL's using Visual Explain and created indexes using

DB2ADVIS.

. Responsible for administering development and QA databases.

Environment: DB2 UDB7.x /8.x on AIX, SQL PL Stored Procedures, DBArtisan,

Informatica and IBM RS6000 P570

ACE-INA (CIGNA GROUP) Philadelphia, PA Feb 99 to

Jan 02

DB2 DBA

. Data modeling (logical &Physical) Using Erwin

. Estimated the space for Development, Testing and QA databases using

the Workbench.

. Setup the development, testing and QA databases.

. Created Simple table spaces, partitioning table spaces, tables and

indexes.

. Setup weekly REORG, RUNSTAT and REBIND jobs.

. Setup weekly full backup and daily incremental backup jobs.

. Setup and test disaster recovery plan.

. Performance tuning of SQL's, Applications and Databases.

Environment: DB2 on MVS/ESA, QMF, SPUFI, Work Bench (CDB), JCL, Platinum

tools, BMC software and FILE-AID

MCI Telecommunications Cedar Rapids, IA May 97 to

Jan 99

Sr. Programmer Analyst (MEGA Call processing)

. Adopted a new role as a junior DBA responsible for logical and

physical design of databases.

. Creating Table spaces, tables and Indexes.

. Developed the COBOL, DB2, CICS Programs.

. Modified the Existing programs.

. Involved in Bug fixing.

. Prepared JCLs.

. Maintain the existing billing system.

. Involved in unit testing and integration Testing.

Environment: DB2, CICS, COBOL-II, QMF, SPUFI, VSAM, XPEDITOR,MVS/ESA and

FILE-AID

JOHN DEERE Dubuque, IA Dec 96 to Apr 97

Programmer/Analyst (Secure Extended warranty System)

. Developed the COBOL, DB2, IMS-DC Programs.

. Prepare JCL's.

. Involved in Bug Fixing.

. Maintain the system.

. Involved in unit testing and integration Testing.

Environment: DB2, IMS-DC, COBOL-II, JCL, QMF, XPEDITOR,MVS/ESA and FILE-AID

CSX TRANSPORTATION INC Hyderabad, India Aug 95 to Nov

96

Programmer/Analyst (Car Management System (CMS))

. Developed new programs.

. Modified the Existing programs.

. Involved in Bug fixing.

. Prepared JCLs.

. Involved in unit testing and integration Testing.

Environment: DB2, IMS, CICS, COBOL-II, VSAM, JCL, QMF, FOCUS,MVS/ESA and

XPEDITOR

CSX TRANSPORTATION INC Hyderabad, India April 94 to

July 95

Programmer/Analyst (Electronic Data Interchange (EDI))

. Developed new programs.

. Modified the Existing programs.

. Involved in Bug fixing.

. Prepared JCLs.

. Involved in unit testing and integration Testing.

Environment: DB2, IMS, CICS, VSAM, COBOL-II, JCL, QMF, FOCUS,MVS/ESA and

XPEDITOR

CSX TRANSPORTATION INC Hyderabad, India Jan 93 to Mar

94

Programmer/Analyst PURMAT (Purchase of Materials))

. Developed new programs.

. Modified the Existing programs.

. Involved in Bug fixing.

. Prepared JCLs.

. Involved in unit testing and integration Testing.

Environment: DB2, IMS, CICS, COBOL-II, JCLS, QMF, XPEDITOR,MVS/ESA and

FOCUS

EDUCATION:

MS, Production Engineering, India

Nationality:

US Citizen

Contact this candidate