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 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)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).

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 Confidential application development. Both on DB2 and Oracle.

Confidential - Minneapolis, MN

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.

Confidential- Baltimore, Maryland

DB2 DBA Consultant

Responsibilities:

• Automated Image copy jobs using CDB Super Utilities.
• Automated recovery jobs.
• Automated Reorg and Runstat jobs.
• DB2 performance monitoring.
• Application Performance tuning.
• Setting up Image Copy, Runstat and Reorg procedures for all new applications.
• Reviewing Data Models for all new development.
• Setup and administering UDB V5 on an NT server.
• Transforming Logical Data Models to Physical databases for new development.

Confidential - Washington, DC

DB2 DBA Consultant

Responsibilities:

• Developed and published DB2 standards and Procedures.
• Performance Monitoring
• Application Performance tuning.
• Setting up Image Copy and Reorg procedure for all new applications
• Reviewed Data Models for all new development.
• Transforming the Logical Models to Physical Databases for all new development
• Developed and implemented procedures for administering PR/MVS Repository.
• Populated Meta data into PR/MVS Repository for a number of applications.

Confidential - Crystal City, Virginia

DB2 DBA Consultant

Responsibilities:

• Data Modeling
• Performance Monitoring.
• Implemented LU 6.2 messaging
• Converted the application from ADABASE to DB2
• Implemented Image Copy, Reorg and Runstat
• Implemented DB2 packages.

Confidential - Washington, DC

DB2 DBA Consultant

Responsibilities:

• Developed the Logical Model for Retirement and Employee Benefit system.
• Transformed the Logical Model into Physical databases.
• Created the database using DB2 - MVS, DB2/2 and DB2 - 6000.

Confidential - Baltimore, Maryland

DB2 DBA Consultant

Responsibilities:

• Developing the Logical Data Model
• Transforming the Logical Data Model into Physical database.
• Application Performance tuning
• Implemented Image Copy, Reorg and Runstat jobs.

Confidential - Washington, DC

DB2 DBA Consultant

Responsibilities:

• Developing a Logical Data Model
• Transforming the Logical Data Model to a Physical Data Model
• Implementing the Physical data model in DB2
• Monitored application performance
• Implemented Image Copies, Reorg and Runstat jobs
• DBA review of all programs

Confidential Maryland

DB2 DBA Consultant

Responsibilities:

• Worked on setting up Revenue Information Reporting System. This project involved writing programs to extract data from different sources and populating DB2 tables. Developing queries using FOCUS to access the database.

Confidential - Baltimore, Maryland

DB2 DBA Consultant

Responsibilities:

• Converted from a DOS/VSE environment to a MVS/XA environment. Task involved changing/compilation of DOS job streams to MVS job streams, changing Applications to meet MVS/XA requirements. Converted all CICS applications from DOS to MVS and testing them. Provided production recovery support for 2 months, and was In-Charge of system, which edited and accepted data, transmitted from the branches.
• Designed, coded and maintained CICS command level/Macro level programs for getting credit reports from Dun & Bradstreet database.
• Served on the Special Reports group doing time critical reports and projects for the company. These request involved user contact ranging from Department heads to clerical staff, to do the analysis for the user needs. Used 4GL Report writer and Utility QuickWrite/QuickJob.