­­

SUMMARY:

Seasoned DB2 database administrator with extensive experience supporting application development, performance monitoring & tuning, resolving DB2 issues, monitoring data security and integrity as well as assessing data models to ensure technical accuracy. Diligent and detail - oriented; able to manage projects, direct personnel and design implement and analyze systems. Effective communicator capable of working productively with multilevel personnel and management. Possesses a strong background supporting business applications development on various platforms.

TECHNICAL KNOWLEDGE:

Host Environment: z/OS V13, IBM 370/390, OS/390, MVS/ESA, JES, JCL, TSO/ISPF/PDF, CICS/VS, IOF, SDSF, WSF2, Assembler, COBOL 68/74/II/LE, SMS, HSM, VSAM, TMS, CLIST, REXX, FTP, AIX, UNIX, TSM, Tivoli System Automation.

PC Environment: Windows (3x, 9x, NT, 2000, XP), OS2, 3270 Emulation, MS Word, MS Excel, MS PowerPoint, MS Access, MS Schedule+, MS Project, PMW, Micro Focus COBOL, XDB.

DBMS Software: DB2 V2.3 thru DB2 V10, QMF, DPROP, CICS, IDMS, IMS, TOTAL, DB2 UDB V5 thru 8, Oracle, Informix, SQL Server, Sybase, Natural for DB2

Support Software: IBM DB2 Utilities (Copy, Check, Load, Modify, Rebuild, Recover, Reorg, Repair, Runstats, DSN1COPY, etc), BMC Change Manager, BMC Catalog Manager, BMC Utilities (Load Plus, Unload Plus, Apptune, SQL Explorer, Log Master, Recovery Manager, DASD manager, Quickstart), CA/Platinum Utilities and Tools (Data Base, Plan, Recovery, and Log Analyzers, RC/Query, RC/Migrator, RC/Update, Detector, and Utilities)CDB Utilities (RW-COPY, RW-REORG, Automation)Changeman, ErWin, Excelerator, File Aid, File Aid for DB2, File Aid RDX for DB2, Omegamon for DB2, TMON for DB2, Bachman DA/DBA/Extractor, ER-Studio, DB2 Connect, Data Propogator, Informatica, Oracle Transparent Gateway, Peoplesoft Financial 8.4 & Peoplesoft HR 8.3 PeopleTools 8.4

PROFESSIONAL EXPERIENCE:

Confidential, Santa Fe, NM

DB2 DBA Consultant

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, CA-Unicenter DB2 Utilities.

Responsibilities:

• Converted PLANS’s using DBRM to use packages.
• Bound packages to use DRDA communication protocol.
• Provided DBA support to Confidential application development.
• Using SMP/E received and applied PTF for DB2 V9 fallback support.
• Prepared to receive DB2 V10 libraries.
• Received and applied SMP/E datasets for DB2 V10.
• Set up the jobs to migrate to DB2 V10 Conversion mode.
• Upgraded three (3) DB2 subsystems to V10 NFM.
• Extracted data for conversion to SQL Server.
• Cleansed the data as there were many orphan rows.
• Purged old data.
• Converted simple tablespaces to PBG in preparation for DB2 V10.
• Managed DASD volumes allocated for DB2.
• Used DB2 and CA utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, West Norriton, PA

DB2 DBA Consultant

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, CA-Unicenter DB2 Utilities.

Responsibilities:

• Using SMP/E received and applied DB2 V10 libraries.
• Executed the install CLIST.
• Customized job generated by the clist.
• Communicated the pre requisites to Application Team.
• Converted PLANS’s using DBRM to use packages.
• Bound packages to use DRDA communication protocol.
• Provided DBA support to Confidential application development.
• Maaged DASD volumes allocated for DB2.
• Used DB2 and CA utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Santa Fe, NM

DB2 DBA Consultant

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, CA-Unicenter DB2 Utilities.

Responsibilities:

• Using SMP/E received and applied DB2 V9 libraries.
• Executed the installation clist DSNTINST.
• Customized migration jobs created by the clist.
• Executed the migration jobs for the different DB2 sub systems.
• Executed the IVP’s to verify the functionality of DB2 sub system.
• Supported the application development teams for their verification of DB2V9.
• Migrated DB2 to V9 NFM.
• Managed DASD volumes allocated for DB2.
• Used DB2 and CA utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Durham, NC

DB2 DBA Consultant

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, DB2 on AIX, CA-Unicenter DB2 Utilities.

Responsibilities:

• Prepared the DB2 systems for upgrade to DB2V10.
• Bound DBRM’s into packages and altered the plans to use collections.
• Bound packages bound with DEGREE(ANY).
• Upgraded several servers from UDB V9.5 to V9.7.
• Managed DASD volumes allocated for DB2.
• Used DB2 and CA utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Minneapolis, MN

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, CA-Unicenter DB2 Utilities.

Responsibilities:

• Tuned Queries using IBM’s Data Studio, CA’s Detector, Subsystem Analyzer and Insight.

Confidential, Topeka, KS

DB2 DBA Consultant

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, BMC DB2 Utilities.

Responsibilities:

• Installed Omegamon for DB2 suing SMP/E.
• Applied PTF’s to DB2.
• Environment was TSO, ISPF, JCL, JAVA (JVM), QMF.
• Upgraded DB2 to V9 NFM.
• Tuned Queries for DSS group.
• Managed DASD volumes allocated for DB2.
• Used DB2 and CA utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Springfield, IL

DB2 DBA Consultant

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, BMC Utilities, Erwin.

Responsibilities:

• Designed the architecture for WVS.
• Developed the Logical/Physical data models using Erwin.
• Created the physical database.
• Created the SQL queries for the Adobe Forms, both for populating and updating the database.
• Tuned/Optimized SQL queries for developers.
• Used DB2 and CA utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Minneapolis, MN

DB2 DBA Consultant

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, Transparent Gateway for Oracle, BMC DB2 Utilities.

Responsibilities:

• Upgraded to DB2 V8 NFM.
• Upgraded BMC suite of products to V9.3.
• Optimized and tuned SQL resulting in better performance.
• Developed custom reports using BMC’s Log Analyzer/REXX for compliance with SOX requirements.
• Backup and Recovery of DB2 z/OS.
• Used DB2 utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Santa Fe, NM

DB2 DBA Consultant

Responsibilities:

• Using SMP/E installed/upgraded DB2 to V8.
• Implemented JDBC & ODBC support for DB2.
• Implemented WLM environments for DB2 Stored Procedure usage.
• Environment was TSO, ISPF, JCL, JAVA (JVM), QMF.
• Used DB2 utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Woodland Hills, CA

DB2 DBA Consultant

Responsibilities:

• Using SMP/E installed/upgraded CA/RC Products to V11.5 SP1.
• Installed and configured Neon software products.
• Developed recovery procedures to minimize data loss.
• Worked with the application to develop process to control access to sensitive customer data. Data access was controlled by the security department and Data Stewards.
• Supported Oracle Transparent Gateway, for data conversion from DB2 on z/OS to Oracle.
• Developed procedure to monitor DBA’s access.
• Provided full life cycle support to application teams for both OLTP and Data Warehouse.
• Monitored performance reports and worked with applications to tune their SQL.
• Backup and Recovery of DB2 z/OS.
• Worked with application group to convert transactions to use DB2 type IV connect to avoid the usage of Oracle Transparent Gateway.
• Backup and recovery of UDB LUW using TSM.
• Environment was TSO, ISPF, JCL, JAVA (JVM), QMF, Oracle, Oracle Transparent Gateway and UDB on AIX, CTG (CICS Transaction Gateway).
• Used DB2 and CA utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Santa Ana, CA

DB2 DBA Consultant

Responsibilities:

• Using SMP/E installed/upgraded DB2 to V8 New Function Mode.
• Installed and configured Tivoli Systems Automation to provide seamless fail over for instances of UDB V8.3.
• Supported application teams in full life cycle of application development. The application was using Natural for DB2 to access DB2 data.
• Used DB2 utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.

Confidential, Montrey Park, CA

DB2 Systems DBA Consultant

Responsibilities:

• Using SMP/E installed/upgraded DB2 V8 to put 0705.
• Using SMP/E installed/upgraded DB2 to V8 Compat Mode.
• Using SMP/E installed/upgraded and customized BMC tools/Utilities V8.3.
• Using SMP/E installed/upgraded and customized Mainview for DB2 v8.3.
• Using SMP/E Installed and customized CA/RC DB2 products. Responsible for applying the necessary PTF’s and upgrade.
• Using SMP/E applied PTF’s & zaps to PeopleSoft V8.4.
• Conducted Peoplesoft Health check and recommended changes to Peoplesoft application servers and the process schedule resulting in savings 40 MIPS.
• Worked with Application developers to Tune SQL queries coming from PeopleSoft Financials.
• Changed several process in Peoplesoft Financials to DB2 loads. Saving overhead incurred in delete and insert processing.
• Worked with application DBA’s to implement SOX compliance.
• Backup and recovery of DB2 z/OS.
• Used DB2 utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.
• Used DB2 and CA, BMC utilities for maintaining data, i.e. REORG, IMAGECOPY, UNLOAD, LOAD etc.