SUMMARY:

Senior Database Consultant with wide - ranging experience in DB2 for Z/OS, in the areas of installation, migration of DB2 and related soft wares, physical implementation and Performance Analysis, BRS planning. I have worked in the following industries Tele-communications, Investment banking, Commercial banking, City and State Governments, Public utilities, Health Insurance.

SKILLS:

Operating Systems: Z/OS, Windows Server

Databases: DB2/for ZOS

UDB L/U/W 9.7: Oracle 10g

ETL and Reporting tools: Info Sphere (Event Publisher, Data Stage, Data Quality), Cognos

SOFT WARES AND TOOLS:

Computer Associates

Database Monitor

RC- Update

Subsystem Analyzer

RC - Query

RC - Migrator

Database Analyzer

Log Analyzer.

I.B.M.

Administration Tool

Table Editor

Automation Tool

Log Analysis

Optim data Growth

File Manager

Query Monitor

QMF

Omegamon for DB2 PE

DB2 Connect

Data Studio

CICS

MQ-Series

HPU

Infosphere Data replication for DB2

EXPERIENCE:

DB2 SYSTEMS DBA

Confidential

Responsibilities:

• Member of the DB2 systems support, performing installations, migrations, and apply maintenance to DB2 on Z/OS and other related IBM products, LOG ANALYSIS, ADMINSTRATION TOOL, QMF, Infosphere Data Replication for DB2, Automation Tool, File Manager, QUERY MONITOR, Object Compare, Bind Manager, High Performance Unload, DUET DB2 Utilities Enhacement. We are currently in the process of migrating to DB2 V11 and migrating all dependent products to their latest release.
• The group supports 19 Data sharing groups and 43 DB2 sub systems in total.
• Perform DSNZPARM maintenance, open and follow up PMRS with IBM support.
• Primary systems DBA for IIDR maintenance, migrations to new versions, and support.
• Off - hours coverage on a rotation basis.

Lead DB2 DBA

Confidential, San Juan, PR

Responsibilities:

• Performed senior Z/OS DB2 DBA systems programming support activity, customized IBM utility suite, and related DB2 product features.
• Install and migrate DB2 for Z/OS to new versions of DB2. Setup and maintain DB2 WLM (workload Manager) policies.
• Implement subsystem DSNZPARM changes when needed.
• Installed and customized QMF, Administraion Tool. Automation Tool, File - Aid for DB2, Log Analysis tool, Table Editor, Query Monitor.
• Used OMEGAMON PE for performance monitoring and tuning of DB2. Maintain sub system and database security, physical database design and maintenance.
• Setup and maintain REORGS, RUNSTATS, IMAGE COPIES, Binds as required. Setup communication between Cognos and DB2 on Z/OS.
• Setup DB2 connect communication between DB2 and open systems programs.
• Develop and test BRS procedures for all of the production db2 sub systems.

DB2 DBA

Confidential

Responsibilities:

• Remote DB2 application support for the City applications and developers.
• Supported the implementation of a new PEOPLESOFT FINANCIALS 9.1 system, application and database tuning was a large effort of this implementation.
• On DB2 for Z/OS.
• Used Computer Associates Subsystem analyzer and database monitor for Db2 monitoring and tuning.
• Setup and maintain REORGS, RUNSTATS, IMAGE COPIES. Performed refreshes of the development database upon request with production data and synchronized the environments as part of the refresh process.
• BRS planning support for the DB2 on Z/OS databases.

Lead DB2 DBA

Confidential, San Juan, PR

Responsibilities:

• Performed senior Z/OS DB2 DBA systems programming support activity, customized IBM utility suite, and related DB2 product features.
• Install and migrate DB2 for Z/OS to new versions of DB2. Setup and maintain DB2 WLM (workload Manager) policies.
• Implement subsystem DSNZPARM changes when needed.
• Installed and customized QMF, Administraion Tool. Automation Tool, File - Aid for DB2, Log Analysis tool, Table Editor, Query Monitor.
• Used OMEGAMON PE for performance monitoring and tuning of DB2. Maintain sub system and database security, physical database design and maintenance.
• Setup and maintain REORGS, RUNSTATS, IMAGE COPIES, Binds as required. Support of PEOPLESOFt HR and FINANCIAL application on DB2 Z/OS.
• DB2onnect communication between DB2 and open systems programs.
• Develop and test BRS procedures for all of the production db2 sub systems.

Lead DB2 DBA

Confidential

Responsibilities:

• Lead DBA responsible for the migrations of DB2 on Z/OS from version 4.1 through version 6.1
• Application developer support for a conversion of all core apps to DB2.
• Responsible for physical database design, establishing backup, maintenance, restore procedures.
• Maintain physical database structures
• Worked with the bank to migrate its datacenter

DB2 DBA

Confidential, NY

Responsibilities:

• DBA support for a global trading application, insure file transfers were completed in a timely manner.
• Application developer support.
• Responsible for backup, maintenance, and physical maintenance of database objects.
• Maintain financial QMF batch reports, support FOXPRO file transfers, work with the onversion to the CONTROL T schedulers with Delaware and Paris, France data centers.

DB2 DBA

Confidential, NYC

Responsibilities:

• Performance tuning of existing applications.
• Involved from user requirements gathering stage through project implementation.
• Monitoring and tuning of process.
• Responsible for physical database design, establishing backup, maintenance, restore procedures.
• Maintain physical database structures

Systems Analyst

Confidential, NYC

Responsibilities:

• DB2 Application developer for a warehouse/inventory application, using Andersen Consulting DESIGN - 1, Method-1.
• Batch and online programs developed using DB2, CICS
• Implemented TPNS an IBM tool used to simulate online activity with robotic software.

Systems Analyst

Confidential, NYC

Responsibilities:

• Application developer for a Financial/Time reporting application. Primary language used was COBOL. Also used were DYLAKOR, SYSNCORT, CLIST, VSAM AND IBM UTILITIES IDCAMS, IEBGENER, etc. .