We provide IT Staff Augmentation Services!

Db2 Dba Consultant Resume

Santa Fe, NM

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 BASE:

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)

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.

Responsibilities:

  • As a lead DBA coordinated different tasks for the 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 the install CLIST.
  • Set up the jobs to migrate to DB2 V10 Conversion mode.
  • Upgraded 6 DB2 sub systems to V10.
  • Extracted data for conversion to SQL Server. Loaded the data in SQL Server.
  • Supported three environments in SQL Server.
  • Cleansed the 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 that need to be completed.
  • Upgraded the DB2 sub system to DB2 V11.
  • Executed the 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 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. 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 the 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 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.
  • 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 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.
  • Provided DBA support to Blue Cross Blue Shield application development. Both on DB2 and Oracle.

Confidential, Minneapolis, MN .

DB2 DBA Consultant

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

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.

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 the architecture for WVS.
  • Lead the development team for the project.
  • Assigned tasks to developers and tracked their progress.
  • 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.

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

Confidential, Santa Fe, NM

DB2 DBA Consultant

Responsibilities:

  • As the lead DBA for DB2 upgrade assigned and coordinated tasks to other team members and application DBA’s.
  • Using SMP/E installed/upgraded DB2 to V8 on z/OS.
  • Implemented JDBC & ODBC support for DB2.
  • Implemented WLM environments for DB2 Stored Procedure usage.
  • Environment was TSO, ISPF, JCL, JAVA (JVM), QMF.

Confidential - Woodland Hills, CA

DB2 DBA Consultant

Responsibilities:

  • Supported DB2 on z/OS.
  • As the lead DBA assigned tasks to different team members and tracked the status of each task.
  • 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.
  • Supported application development on DB2, DB2 LUW and oracle.
  • Environment was TSO, ISPF, JCL, JAVA (JVM), QMF, Oracle, Oracle Transparent Gateway and UDB on AIX, CTG (CICS Transaction Gateway).

Confidential - Santa Ana, CA

DB2 DBA Consultant

Responsibilities:

  • Supported DB2 on z/OS.
  • 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.

Confidential - Montrey Park, CA

DB2 Systems DBA Consultant

Responsibilities:

  • Using SMP/E installed/upgraded DB2 V8 to put 0705.

Confidential, Arlington, VA

DB2 DBA Consultant

Responsibilities:

  • Using SMP/E installed/upgraded DB2 to V8 Compat Mode on z/OS.
  • 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.

Confidential, Woodland hills, CA

DB2 DBA Consultant

Responsibilities:

  • As the lead DBA assigned tasks to different team members and tracked the status of each task.
  • Developed the project plan to migrate DB2 z/OS from V7 to V8 on z/OS.
  • Using SMP/E migrated the test DB2 sub system to V8.
  • Using SMP/E applied fixes to DB2 V7.
  • Using SMP/E Installed and customized CA/RC DB2 products. Responsible for applying the necessary PTF’s and upgrade.
  • Applied PTF’s to Peoplesoft.
  • Worked with Application developers in tuning SQL from PeopleSoft.
  • Installed Neon Software Impact Analyzer to evaluate the effect of Bind on packages being promoted for any negative impact to access path. Incorporated this in the Migration procedure. This identified several application modules which could be remediate and prevent adverse effect on the system.
  • Implemented IBM’s Performance Expert.
  • Worked with developers to tune ETL process i.e. Datastage.
  • Provided full life cycle support to application teams for both OLTP and Data Warehouse.
  • Monitored performance and tuned SQL resulting in saving of CPU and reduction of the load on the system and resulting decrease in response time.
  • Developed and Implemented database backup strategy and automated the generation of recovery jobs.
  • Developed and implemented procedure to clone a DB2 sub system.
  • Maintained and supported the Performance testing environment. Tuned SQL
  • Provided DBA support to the application and testing teams.
  • Monitored SQL and advised changes to the application team. Maintained test, system test databases for application and acceptance testing.
  • Created scripts to refresh data in different environments as required by the application and acceptance teams.
  • Created scripts for loading the data in tables.
  • Worked with end users to identify sensitive data for SOX compliance. Developed procedures to set up RACF groups for SOX compliance. Created views to limit access to sensitive data.
  • Backup and recovery of UDB on AIX using TSM.
  • Monitored system performance using snapshot and event monitor and Performance Expert.

Confidential - Mclean, Virginia

DB2 DBA Consultant

Responsibilities:

  • As the lead DBA for the project assigned tasks to a team of 4 data modelers and provided guidance to them.
  • Responsible for the Data Warehouse residing on UDB EEE V7.2. With data structures being partitioned.
  • Worked with the Data Architects in converting Logical Models to physical models both for OLTP datastore and Data Warehouse on DB2 z/OS and UDB on AIX.
  • Responsible for maintaining replication and transformation for IBM’s Data Propagator.
  • Using SMP/E applied APAR’s to DB2 V7 & CA/RC products.
  • Responsible for monitoring the replication process.
  • Tuned application SQL resulting in considerable performance gains.
  • Maintained and supported the Performance testing environment. Tuned SQL
  • Provided DBA support to the application and testing teams.
  • Provided full life cycle support to application teams for both OLTP and Data Warehouse.
  • Monitored SQL and advised changes to the application team. Maintained test, system test databases for application and acceptance testing.
  • Created scripts to refresh data in different environments as required by the application and acceptance teams.
  • Created scripts for loading the data in tables.
  • Supported Data Warehouse on UDB EEE.
  • Performed regular maintenance of tables and indexes i.e. REORGS.
  • Backup and recovery of UDB on AIX using TSM.
  • Montiored system performance using snapshots, event monitor and Query Patroller.

Confidential - Pasadena, California

DB2 DBA Consultant

Responsibilities:

  • Responsible for maintaining replication and transformation for BMC’s Change Data Move.
  • Responsible for monitoring the replication for the Foundation system, and implementing changes to Oracle data structure.
  • Monitored the health of the replication processes and resolved errors by working with BMC/Striva.
  • Automated the process of applying Code drop to different environments.
  • Provided DBA support to the testing teams.
  • Converted DME system from DB2 V7 on OS/390 to UDB EE V7 on AIX.
  • Monitored SQL and advised changes to the application team. Maintained test, system test databases for application and acceptance testing.
  • Refreshed data in different environments as required by the application and acceptance teams. Created scripts for loading the data in tables.
  • Supported replication of data using BMC’s Change Data Move from DB2 V7 to Oracle. Created required objects in Oracle.

Confidential - Orange, California

DB2 DBA Consultant

Responsibilities:

  • Responsible for Upgrading DB2 from V5 to V6.
  • Using SMP/E installed and customized QMF V610.
  • Using SMP/E installed and customized CA/Platinum’s utilities for DB2.
  • Using RC/Detector tuned SQL.
  • Automated Disaster recovery and successfully recovered without a DBA’s involvement.
  • Automated Reorg and Runstat jobs using REXX.
  • Performance monitoring and application performance tuning.
  • Implemented the use of Stored Procedures and Triggers.
  • Created data models for the data warehouse.
  • Supported the corporate Data Warehouse on RS/6000.
  • Maintained separate test and acceptance test environments for the data warehouse/acceptance test teams.
  • Performed regular maintenance of tables and indexes i.e. REORGS.
  • Backup and recovery of UDB on AIX using TSM.

Confidential - Long Beach, California

DB2 DBA Consultant

Responsibilities:

  • Automation of Image Copy jobs using REXX and CDB Super Utilities.
  • Evaluated different recovery tools for the client.
  • Implemented IBM’s Data Propagator for replication of data between two DB2 sub systems.
  • Using SMP/E applied APAR’s to DB2 and other DB2 related products.
  • Using SMP/E installed and customized Platinum’s utilities for DB2.
  • Implemented Platinum’s Recovery Analyzer for automating Disaster recovery.
  • Automated Reorg and Runstat jobs using REXX.
  • Reversed Engineered the application database into Erwin.
  • Administered Sapiens knowledge base.
  • Performance monitoring and application performance tuning.

Hire Now