Romesh Kumar: DB* DB* ZOS (MAINFRAME)

E-mail:aceusc@r.postjobfree.com

+1-513-***-****

[pic]

[pic]

Professional Synopsis:

> 7 years of strong experience as DB2 DBA database administration of large

DB2 systems on Z/OS (mainframe) and UDB LUW in both Production and non-

production environments

> Extensive experience in Database design, analysis, developing physical

database, production implementation and support of large scale

operational OLTP and analytical database structures.

> Extensive experience in creating new database objects,altering the

existing objects,migration of objects from one system to another as per

the business requirements using the standard change management processes

and guidelines.

> Sound experience in setting up the backup and recovery procedures for

database objects in production and non-production systems

> Sound experience in creating the data migration process from production

to UAT enviroments to help the application teams for pre production

releases.

> Extensive experience in setting up the weekly/monthly

Reorg,Copy,Load,Modify,Quiesce jobs to keeps the database systems in good

health.

> Extensive experience in setting up the Purge/Rotate jobs for large

partition tables to archive the old data and manage the future growth of

the tables.

> Responsible for the creation and testing of Business Continuation

Disaster Recovery Plans

> Extensive experience in setting up the Daily/weekly/Monthly health check

jobs to detect any potential issues in the system in advance.

> Maintained Database security as per the guide lines and standards and

perform audits on regular intervals.

> Extensive experience working in data sharing environment with multiple

LPAR'S.

> Experience in resolving various database issues and bottlenecks by

working directly with DB2 Development team

> Responsibe for closely monitor performance; identify problems and

implement solutions; ensure the database is running at optimum speed and

efficiency.

> Extensive experience in implementing compression on tablespaces

significantly reducing the amount of disk space required to store the

data and to help the bufferpool performance.

> Reviewing and tuning complex SQL queries with Visual Explain,IBM Data

studio and other techniques.

> Provide the sql performance tuning for both OLTP and data warehouse

environments

> Extensive experience in DBA administration tools like IBM DB2

administration,BMC Catalog manager,BMC Alter manager,DASD

manager,Apptune,Omegamon,Spufi,QMF,Query Monitor, Data Studio,Log

analyzer,DB2 PM,SQL analyzer,IBM compare tool,CA tools,

> Providing the production support 24*7 on weekly basis

> Work closely with Systems Programmers to assign and modify DSNZPARM

system parameters as needed.Perform the IVP during migration and

upgradations.

> Working knowledge of System modifcation program extended(SMP/E) on Z/OS.

> Knowledge of administering and tuning distributed applications accessing

mainframe DB2 including experience with DB2 Connect, JDBC and .NET

> Knowledge in providing DB2 Connect configuration access support for

individual users and distributed systems

> Experience working with SQL and Cobol stored procedures and migration of

stored procedures to production environments.

> Create Change Requests, Resolve Service Requests,incidents,problem

tickets as per the change management process adhering to all the ITIL

guidelines..

> Excellent experience in different programming language JCL,Rexx, COBOL,

SAS, and MVS operating system

> Excellent working experience with clients as well as technical IT

partners. Actively participated in end to end delivery of projects which

involves interacting with the client, understanding customer

requirements, designing and delivering the product.

> Work with Management to develop project schedules

> Strong analytical ability and good communication skills

> Possess a strong background of supporting business applications

development on various platforms.

> Sound analytical skills to analyze issues and problems and recommend

suitable solution for resolving the problems effectively within optimum

time.

> Effective communicator capable of working productively with multilevel

personnel and project management

Certifications/Qualification

> Bachelor of Engineering in Computer science

> IBM certified Database Administrator DB2 9 DBA for Z/os, IBM-732 EXAM.

> ITIL V3 Foundation certified

Technical Skill set:

DB2 DBA TOOLS BMC Alter Manager, Change Manager, Catalog

Manager,Dasd manager,

IBM admin tool,IBM compare tool,IBM change

management tool,

CA admin tool and utilities,Omegamon,IBM Query

monitor,File Aid,

Data studio,AQT,TOAD,BMC Apptune,Changeman,BMC log

master,SPUFI,QMF etc,

Mainframe Skills TSO,ISPF,JCL,DFSORT,REXX,ZOS Utilities

Operating Systems MVS, MS Dos, Windows 98/XP, UNIX

Languages SQL,SAS,REXX,C,C++,Cobol,Java,Unix scripting

RDBMS DB2 mainframe V9 and V10,DB2 LUW

Tuning Tools IBM Data Studio,Visual explain,Omegamon,Apptune,Toad

Database Modeling Erwin,Power designer

[pic]

Experience Summary

> Working as onsite lead for DB2 DBA team in Wipro(Cincinnati,OH USA) from

August 2011 to till Date.

> Worked as DB2 DBA mainframe/LUW for John deere Ltd from September 2007 to

Aug 2011

[pic]

Project Summary 1: Database administration for large payment processing

applications Aug 2011 - Till date

Project : Database administration for large payment

processing applications

Role : Onsite lead for DB2 DBA mainframe

Organization : Wipro technologies

Environment : DB2 ZOS V10

Project Description

A U.S.-based payment processing and technology solutions provider

headquartered in the greater Cincinnati, Ohio area.It is the largest PIN

Debit U.S. acquirer and third largest U.S. merchant transaction acquirer

ranked by general purpose transaction.The Company provides payment and

technology services to merchants and financial institutions of all sizes in

the U.S. and processes more than 15.4 billion payment transactions and

approximately $530 billion in volume annually

Roles and Responsibilities

> Working as a DB2 DBA/UDB onsite lead.

> Analysis,design and implementation of database objects for new

applications.

> Migration of objects from one systems to another.

> Implementation and maintenance of very large partitioned objects.

> Migration of data from production to QA environments for UAT and

Application testing.

> Setting up the Backup jobs for production and Non-productions systems.

> Designing the recovery procedures

> Implementation of purge process for large objects using reorg/rotate

process.

> Implementation for daily and weekly health check jobs for database

systems.

> Setup of utility jobs like load,unload,copy,reorg,runstats,check data

etc.

> Analyse,review and implement the production changes as per the change

management process.

> Troubleshooting the application team issues as and when they arise.

> Reviewing database performance issues and reviewing the complex sql's and

tuning them.

> Participated in DB2 v9 to DB2 v10 migration from application DBA

perspective.Designed the implemented the check processes pre and post

migration.

> Communicate and Coordinate with Other Support Teams like various

Application team, Data Architect, Business users & security groups for

problem resolution.

> Support the 24*7 DB2 oncall support on weekly basis.

> Expertise in SQL tuning, DB/DBM parameter tuning, different levels of

memory allocations, various tools like export, import, load, autoloader

and experience with all kinds of database snapshots

> Creating and Monitoring Users, authorities and responsibilities and

password management

> Enhanced application performance by running RUNSTATS, REORGCHK and

REORG utilities

> Monitored and managed disk space, I/O contention

> Setup Replication between Operational Database and Reporting Database

> Designed and implemented backup and restore procedures

> Monitored databases using database monitors, snapshot monitoring and

event monitoring

> Generated reports of database structure using DB2LOOK Utility

> Recovered data to a prior point in time using ROLLFORWARD command

> Implementing capacity planning and partition table/index for very large

and fast growing tables

> Experienced in writing SQL queries, Packages and triggers.

> Coordinating with the development team for coding static SQL stored

procedures. Also coordinated with application team for SQL Optimization,

SQL Analysis and Streamlining. Has experience working and analyzing with

SQL Visual Explains output.

>

> Assigning tasks to team members according to severity and capability as

lead.

> Planning and preparation for major Production/Development tasks in

discussing with Application managers and Onsite counterparts

> Reviewing the results of work done by team members.

> Leading weekly review meetings and process improvement meetings

> Conducting technical as well as process training for DBA team members.

> Helping onsite counterparts in preparation for database as well as

project audits.

> Preparing weekly and Monthly dashboard like MMR,QBR for Database group.

[pic]

Project Summary 2: DB2 DBA mainframe for John deere enterprise applications

Sep 2007 - Aug2011

Project : Database administration for John deere

enterprise applications

Client : John Deere

Role : DB2 DBA mainframe and LUW

Organization : John deere technologies

Environment : DB2 ZOS V8 and DB2 Zos V9

Project Description

Deere & Company, commonly known by its brand name John Deere, is an

American corporation based in Moline, Illinois, and one of the largest

manufacturers of agricultural machinery in the world.

it was listed as 97th in the Fortune 500 America's ranking and 190th in the

Fortune 500 Global ranking.

Deere and Company agricultural products, sold under the John Deere name,

include tractors, combine harvesters, cotton harvesters, balers,

planters/seeders, sprayers, and UTVs. The company is also a manufacturer of

construction equipment and forestry equipment, as well as a supplier of

diesel engines and drivetrains (axles, transmissions, gearboxes) used in

heavy equipment.

Being a part of John deere DBA services,our responsibilities was to

provide solutions to corporate requirement and also provide tier 2 and tier

technical Supports to application development teams for business

continuity. Team supports all Production, Development & Test (QA)

databases.

Handling 27*7 DB2 helpline and on call support for any db2 issues in the

enterprise.

Roles and Responsibilities:

> Managing DB2 MAINFRAME database administration function involving:

> Physical database design & creation. Devise strategy for Backups,

recovery & fine-tuning

> Monitoring space utilizations, sizing, and capacity planning.

> Creation & administration of all database objects, including tables,

indexes, views, sequences, procedures and database replication.

> Database / SQL tuning, performance monitoring and troubleshooting

> Implementation of backups, recovery, monitoring databases and ongoing

support.

> Migration of Databases from one subsystem to another.

> Comparing databases/objects in different environments.

> Managing security of database objects.

> Performing online/offline utilities like

Load,unload,runstats,reorg,copy,recovery etc.

> Performing the Sql tuning for application developments teams and for

monthly high cost queries.

> Performing recovery for users whenever required.

> Refreshing databases from one server to another servers for application

testing purposes

> Performed database consistency checks.

> Resolving escalated and complex problem within SLAs, establishing user

acceptance performance bottom line.

> Handling on call support on 24*7 on weekly rotation.

> Expertise in SQL tuning, DB/DBM parameter tuning, different levels of

memory allocations, various tools like export, import, load, autoloader

and experience with all kinds of database snapshots

> Creating and Monitoring Users, authorities and responsibilities and

password management

> Enhanced application performance by running RUNSTATS, REORGCHK and

REORG utilities

> Monitored and managed disk space, I/O contention

> Setup Replication between Operational Database and Reporting Database

> Designed and implemented backup and restore procedures

> Monitored databases using database monitors, snapshot monitoring and

event monitoring

> Generated reports of database structure using DB2LOOK Utility

> Recovered data to a prior point in time using ROLLFORWARD command

> Implementing capacity planning and partition table/index for very large

and fast growing tables

> Experienced in writing SQL queries, Packages and triggers.

> Coordinating with the development team for coding static SQL stored

procedures. Also coordinated with application team for SQL Optimization,

SQL Analysis and Streamlining. Has experience working and analyzing with

SQL Visual Explains output.

Contact this candidate