Romesh Kumar: DB* DB* ZOS (MAINFRAME)
E-mail:*********@*****.***
[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.