Project Data
Resume:
LOKESH RAMAPURAM
SENIOR
DB* DBA
Jersey City,
NJ
*********@*****.***
Profile Summary:
11+ years of IT experience out of which 10 years as a Mainframe/DB2 UDB
DBA.
> Working as a DB2 DBA in US since 5+ years and 1 year in UK for the past
projects. Involved in DB2 DBA activities like DB2 Object manipulations,
DB2 Utility executions and Bug fixing.
> Experience in Performance monitoring and tuning of SQL's.
> Experience in DB2 Objects database design.
> Experience in DB2 Objects recovery.
> Total Team Player with Excellent Learnability, Communication,
Interpersonal skills.
Technical Expertise:
. Having experience in Database designing, object manipulations and
performance tuning etc.
. Experience in Execution of utilities, error fixing, and Production
support.
. Experience in Preparation of DB2 maintenance jobs for smooth running of
production system.
. Having work experience with big US clients like Guardian Life insurance,
YUM Brands, GM insurance, Lehman Brothers, UK clients like Norwich Union
Insurance etc.
Education:
. Bachelors of Engineering (B.E) in Computer science and engineering from
University of Madras, India (Majors computers)
Technical Skill set:
Skill Set Description
Databases DB2 UDB 9.X LUW and DB2 V9.X for Z/OS
Programming Cobol
Languages
Tools / Utilities Aqua Data Studio, IBM change data capture (CDC)
management, TOAD for DB2, DB2 Mon, db2pd, FileZilla,
Quest Central, Quest Spotlight, WINSCP, Vantage,
TSM,TOPAS,HADR, DB2TOP, JCL, SQL, File-AID, CA7, SPUFI,
QMF, TSO/ISPF, Insight tool for DB2, DB2 admin tool,
DBAXpert for DB2, Tmon for DB2, PLATINUM, DB2 Object
compare, Omegamon II for DB2.
Domain/Functional Insurance/Financial securities/Retail & hospitality.
Areas
Certifications & Recognitions:
. IBM certified Database Administrator on DB2 universal database V8.1
for Z/OS.
. IBM certified Database Associate on DB2 Universal Database V8.1
Family.
Experience Profile - Key Projects
Project - 1: Guardian UDB DBA support
Client Guardian Life Insurance, New York, NY, USA
Duration Aug'13 To Till Date
Role DB2 UDB DBA.
Environment/ AIX 6.X, DB2 UDB 9.X LUW, IBM data studio, TSM, DB2TOP,
Skills/Tools/ NMON, Topas, HADR, Foglight, HP Mon, HP BSM, DB2Mon,
Technologies WINSCP, shell scripting etc
Responsibilities As a DB2 UDB DBA, I was involved in:
Apply database object changes, involve in database
design, capacity planning, and data movement.
Performance tuning of DB2 SQL's and assist COGNOS/ETL
teams relating to database issues.
Performing Users change requests and resolve application
team's database related issues.
Production environment monitoring using monitoring tools
DB2TOP, Topas, NMON, foglight, BSM etc.
Database installation, upgrades and on-call production
support etc.
Executing database utilities
Backup/restore/export/import/db2look etc.
In-house created health check scripts, database related
alerts.
Storage monitoring and take preventive actions.
Create in-house maintenance jobs.
Project - 2: e-com DBA support
Client Academy Sports + Outdoors., Katy, TX, USA
Duration Aug'12 To Aug'13
Role DB2 UDB DBA.
Environment/ AIX 5.X/6.X, DB2 UDB 9.X LUW, Quest Spotlight, Aqua data
Skills/Tools/ studio, TSM,TOAD, DB2TOP, NMON, Topas, IBM change data
Technologies capture (CDC) management, WINSCP, Vantage, HADR, DB2Mon
etc
Responsibilities As the Onsite DB2 UDB, I was involved in:
Apply DB object changes; perform database refresh and
data movement.
Monitoring of Production environment using monitoring
tools Quest spotlight, DB2TOP and Topas.
Performance tuning of DB2 SQL's.
Performing Users change requests.
Executing Database utilities Backup/restore/export/import
of data etc.
Co-ordinate with application teams and helps them in
writing SQL's.
Monitoring of storage and perform other heath checks.
Involve in database upgrades, on-call production support
etc.
Create in-house maintenance jobs for alerting and
reporting purposes.
Involve in other application designs which access
database.
Project - 3: YUM DB2 DBA support
Client Yum! Brands, Inc., Louisville, KY, USA
Duration Dec'10 To Jul'12
Role DB2 DBA (both UDB & Z/OS).
Environment/ AIX 6.1,DB2 V9.1, DB2 UDB 9.X LUW, Quest Spotlight, TOAD,
Skills/Tools/ TSM, Z/OS,JCL, IBM DB2 Admin tool, IBM DB2 Log Analysis
Technologies Tool, IBM DB2 Query Monitor, IBM Omegamon XE For DB2 PM,
etc.
Responsibilities As the Onsite DBA, I was involved in:
DB2 Database design and manipulations.
Database refresh from Prod to TEST/QA regions and data
movement.
Monitoring of Production environment using monitoring
tool Omegamon XE for DB2 PM.
Performance tuning of DB2 SQL's.
Performing Users change requests.
Resolving of production job failures/on call support.
Executing Database utilities like Copy/Reorg etc.
Co-ordinate with application teams and fixing of testing
errors.
Monitoring of storage/DB2 Object extents and take action
accordingly.
Performing yearly activities like Data purge/Archival
etc.
Project - 4: GMACI SUSTAIN DBA support
Client General Motors Acceptance Corporation Insurance, St.
Louis, MO, USA
Duration Oct'08 to Dec'10
Role DB2 for Z/OS Onshore DBA.
Environment/ Z/OS, DB2 V8.1, JCL, DBAXpert, TMON for DB2.
Skills/Tools/
Technologies
Responsibilities As the Onsite DB2 DBA, I was involved in:
DB2 objects design and manipulations.
Movement of DB2 object from one environment to others,
Copy of data to test regions etc.
Monitoring of Production environment.
Performance tuning of DB2 SQL's.
Executing Database utilities like Copy reorg etc.
Test environment setup and fixing of testing errors.
Co-ordinate with ADABAS DBA and perform basic DBA tasks
in ADABAS.
Project - 5: DB2 DBA Admin support
Client NORWICH UNION INSURANCE, Norwich, U.K
Duration May'07 to Jun'08
Role DB2 for Z/OS Onshore DBA.
Environment/ DB2 V8.1, JCL and Cobol and PLATINUM.
Skills/Tools/
Technologies
Responsibilities As Onshore DB2 DBA, my roles are :
DB2 object creations and alterations.
Cloning of DB2 objects from Test Environment to User and
Production regions using platinum tools.
Monitoring of Production environment using Insight for
DB2.
Performance tuning of DB2 SQL's using Insight for DB2.
Granting Access to users as per Project standards.
Performing Users change request.
Resolving Daily, Weekly DB2 job failures.
Performing DB2 utilities like Image copy, Reorg, Runstats
etc.,
Fixing of DB2 errors in Application Jobs.
Project - 6: DBA SUPPORT
Client LEHMAN BROTHERS, INDIA
Duration Aug'06 To April'07
Role Offshore DB2 for Z/OS Team Member
Environment/ DB2 V7.1, DB2 Admin tool V7.1, DB2 Object compare, QMF
Skills/Tools/ V6.1 and SPUFI, DB2I, Omegamon II for DB2
Technologies
Responsibilities As a Offshore Team Member, I was involved in:
DB2 object manipulations and Cloning of DB2 objects using
Object compare tools.
Backup and recovery of DB2 objects.
Data movement from Production to Test and Staging using
Unload and Load utilities.
Refreshing of Test and Staging data with production data
using DB2 offline utilities DSN1COPY.
Granting Access to users and revoking.
Creation of DCLGEN and altering tablespaces before it
reaches its Max. Extents.
Preparing Database maintenance jobs, Scheduling,
Monitoring and Restarting.
Resolving DB2 job failures.
Preparation of daily, weekly DB2 job failures report and
Discussions.
Project - 7: Infrastructure support
Client TATA STEEL LTD (TISCO), INDIA
Duration June' 04 To July' 06.
Role DB2 DBA for Z/OS
Environment/ DB2 V5.1 and JCL.
Skills/Tools/
Technologies
Responsibilities As a Mainframe DB2 DBA, I was extensively involved in
Performing DBA tasks like Objects creation & alterations,
Unload and re-load, Backup & recovery, DB2 Utilities and
having knowledge on RACF. Also as a team member involved
in migration of WINDOWS/AIX DB2 from Version 5.2 to DB2
V8.1 at clients location. The installation consists of an
intermediate server (Windows NT) and Main server (AIX
4.2). The migration involves, upgrading of database to
higher versions first i.e. DB2 V8.1 in Both the servers,
then migrate the live data from Old System to New system.
Contact this candidate