We provide IT Staff Augmentation Services!

Db2 Dba Consultant Resume

2.00 Rating

Santa Fe, NM

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.

We'd love your feedback!