SUMMARY

• Seasoned DB2 database administrator wif 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 wif multilevel personnel and management.
• Possesses a strong background supporting business applications development on various platforms.

TECHNICAL SKILLS

Host Environment: z/OS V11, 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, Oracle.

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 V11, 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)

PROFESSIONAL EXPERIENCE

Confidential - Santa Fe, NM

DB2 DBA Consultant

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

Responsibilities:

• As a lead DBA coordinated different tasks for teh upgrade of DB2 to other team members and application DBA’s.
• Converted PLANS’s using DBRM to use packages.
• Bound packages to use DRDA communication protocol.
• Provided DB2 on z/OS DBA support to TRD application development.
• Using SMP/E received and applied PTF for DB2 V9 fallback support.
• Upgraded CA/Platinum Tools to V15.
• Prepared to receive DB2 V10 libraries.
• Received and applied SMP/E datasets for DB2 V10.
• Executed teh install CLIST.
• Set up teh jobs to migrate to DB2 V10 Conversion mode.
• Upgraded 6 DB2 sub systems to V10.
• Extracted data for conversion to SQL Server. Loaded teh data in SQL Server.
• Supported three environments in SQL Server.
• Cleansed teh data as there were many orphan rows.
• Purged old data.
• Converted simple tablespaces to PBG in preparation for DB2 V10.
• Received and applied SMP/E datasets for DB2 V11.
• Executed DSNTIJPM job to identify pre migration activities dat need to be completed.
• Upgraded teh DB2 sub system to DB2 V11.
• Executed teh IVP to test DB2.

Confidential - West Norriton, PA

DB2 DBA Consultant

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

Responsibilities:

• Supported DB2 on z/OS.
• Using SMP/E received and applied DB2 V10 libraries.
• Executed teh install CLIST.
• Customized job generated by teh clist.
• Communicated teh 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 Diagnostics application development. Both on DB2 and Oracle.

Confidential - Santa Fe, NM

DB2 DBA Consultant

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

Responsibilities:

• Supported DB2 on z/OS.
• As teh lead DBA for DB2 upgrade assigned and coordinated tasks to other team members and application DBA’s.
• Using SMP/E received and applied DB2 V9 libraries.
• Executed teh installation clist DSNTINST.
• Customized migration jobs created by teh clist.
• Executed teh migration jobs for teh different DB2 sub systems.
• Executed teh IVP’s to verify teh functionality of DB2 sub system.
• Supported teh application development teams for their verification of DB2V9.
• Migrated DB2 to V9 NFM.
• Environment was TSO, ISPF, JCL, JAVA (JVM), QMF.

Confidential - Durham, NC

DB2 DBA Consultant

Environment: TSO, ISPF, JCL, JAVA (JVM), QMF, DB2 on AIX.

Responsibilities:

• Prepared teh DB2 systems for upgrade to DB2V10.
• Bound DBRM’s into packages and altered teh plans to use collections.
• Bound packages bound wif DEGREE(ANY).
• Upgraded several servers from UDB V9.5 to V9.7.
• Provided DBA support to Blue Cross Blue Shield application development. Both on DB2 and Oracle.

Confidential - Topeka, KS

DB2 DBA Consultant

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

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.

Confidential - Springfield, IL

DB2 DBA Consultant

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

Responsibilities:

• Designed teh architecture for WVS.
• Lead teh development team for teh project.
• Assigned tasks to developers and tracked their progress.
• Developed teh Logical/Physical data models using Erwin.
• Created teh physical database.
• Created teh SQL queries for teh Adobe Forms, both for populating and updating teh database.
• Tuned/Optimized SQL queries for developers.

Confidential - Minneapolis, MN

DB2 DBA Consultant

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

Responsibilities:

• Supported DB2 on z/OS.
• 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 wif SOX requirements.
• Backup and Recovery of DB2 z/OS.