SUMMARY

Seasoned DB2 professional with 25 years of DB2 progressive experience in the Information Technology field that spans 35 years. DB2 experience includes 5 years of system programming related experience, 16 years of DBA experience and 9 years of application programming experience.

PROFESSIONAL EXPERIENCE

Confidential

DB2 DBA production environments

RESPONSIBILITIES:

• For a major integrated managed care consortium; provided support for production in nine data sharing environments and six standalone environments.
• Support included implementing critical DB2 objects, the implementation and review of DB2 utility processes.
• Participation in disaster recovery drills, DB2 release upgrades, and oncall rotation (including off hours).
• Problems encountered during oncall rotation included both utility and application problems.
• Introduced team members and client to advanced features of the IBM suite and the BMC suite of tools to increase productivity and performance.

Confidential

DB2 DBA

RESPONSIBILITIES:

• Provided support in preparation for major project effort of converting to new systems that included both DB2 and non - DB2 databases. For the new DB2 subsystem, created new plans, collections, and packages. Created new DB2 objects such as tablespaces and related DB2 objects such as tables, views, indexes, and triggers. Granted respective authorities to various DB2 objects.
• Started to perform pre-migration events in preparation for migration to current release of DB2. Rebound all packages and plans that were not at the current release to bring up to current release level. Identified packages that needed to be converted from private protocol to DRDA. Converted simple tablespaces to segmented tablespaces.
• Software DB2 8.0 BMC Tool Suite

Confidential

Senior DB2 Database Administrator

RESPONSIBILITIES:

• Provided oversight for physical database structures using complex technical skills based on physical design for development, test, and production environments.Responsible for complex database performance tuning, security, database backup/recovery strategy, replication, and implementing monitoring procedures to maximize availability of the database.
• Implemented monitoring procedures to maximize availability and performance of the database, while meeting defined targets.
• Provided oversight to application development teams on DBMS product technical issues, techniques and SQL review.
• Coordinated with system programmers to configure systems for DBMS product installation and complex database creation.
• Configured and maintained DBMS product software on complex database and application system.
• Hardware IBM 3090 Z/OS
• Software DB2 9.0 DB2 10.0 CA DB2 Tool Suite

Confidential

Senior DB2 DBA

Responsibilities:

• Participant in the implementation of database changes for releases of software.
• Promotion of database changes from the development, quality assurance, and production environments.
• Implementation and enhancement of DB2 utilities in the production environment.
• Participated in the migration of releases of DB2 software.
• Hardware IBM 3090 Z/OS, DB2 Linux 9.7.4
• Software DB2 9.0 DB2 10.0, IBM DB Admin Tool, Data Studio, Omegamon XE for DB2 Performance Expert

Confidential

Senior Database Administrator

Responsibilities:

• Participated in migration of releases of DB2 software and intermediate upgrades of current releases.
• Implemented DB2 utilities for the various client databases.
• Reviewed and enhanced where needed data security to meet company objectives.
• Implemented various releases of product software.
• Recommended and implemented features of DB2 that enhanced the company’s product software.
• Introduced pro-active DB2 monitoring techniques.
• Hardware IBM 3090 Z/OS
• Software DB2 9.0 DB2 10.0 IBM DB Admin Tool, Omegamon for DB2

Confidential

Database Administration Advisor

Responsibilities:

• Participated in DBA 24/7 on-call support rotation.
• Determined database requirements for projects, and ensured database design and support activities meet those requirements.
• Translated logical data models into physical database structures optimized for the DBMS.
• Participated in the review of ETL processes and made recommendations regarding DBMS load strategies.
• Supported development and test database environments.
• Managed DBMS software including major upgrades, patches, maintenance releases, incidents, and technical alerts.
• Monitored, analyzed, and managed overall system performance utilizing DBMS tools.
• Monitored, analyzed, and reported on overall system capacity including but not limited to memory, space, I/O, and CPU.
• Implemented and made recommendations regarding new database features as they became available.
• Developed and documented database administrator procedures and service level agreements.
• Established and monitored corporate database standards, including disaster recovery, security, and data retention.
• Coached, mentored, and provided guidance for less-experienced database administrators .
• Hardware IBM 3090 Z/OS
• Software DB2 8.0 DB2 9.0, IBM DB Admin Tool, IBM Application Performance Analyzer, Mainview, IBM SQL Performance Analyzer.

Confidential

Senior DB2 Administrator

Responsibilities:

• Responsible for the implementation of DB2 V8 subsystems, evaluation and recommendations for third party products, and interface to other IBM products. Established both system and application backup and recovery plans. Resolved system and application performance issues. Supported the application development community in table loads and SQL reviews. Performed DB2 object creations and maintenance for both packaged and in-house projects. Scheduled DB2 maintenance via utility development for system and application DB2 objects.
• Skills Utilized:
• DB2 Database Administrator skills in application support, application security, system-wide and database monitoring and tuning, system backup and recovery procedures, utility development, data analysis, object creation, application design and security, application performance monitoring, application database backup and recovery, design reviews, and job scheduling.
• Hardware IBM 3090 Z/OS
• Software DB2 8.0, IMS, BMC Tool Suite (Catalog manager and Change manager), File-Aid for DB2, Mainview for DB2.
• Supported application development team in technical support. Ran utilities for copies, reorganizations, statistics updates, and modify recoveries. Performed table creations and alters, database recovery for disaster drills, index creations and alters. Created new databases and monitored and corrected space (DASD) usage. Performed SQL analysis for the application community with the EXPLAIN function and SQL EXPLORER for DB2. Performed data manipulation and DDL creation with SPUFI, CHANGE MANAGER, File-Aid and various IBM utilities.

Confidential

DB2 DBA

Responsibilities:

• Supported the application development team of Social Security Administration for new and existing databases at the development, integration, and production levels. Performed database administrative tasks for DB2 object creation, database performance monitoring and tuning and application tuning. Performed DB2 application wide performance monitoring and tuning, developed application backup and recovery procedures, enhanced application security. Scheduled jobs to perform DB2 maintenance via utility development.
• Skills Utilized:
• DB2 Database Administrator skills in application support, application security, system-wide and database monitoring and tuning, system backup and recovery procedures, utility development, data analysis, object creation, application design and security, application performance monitoring, application database backup and recovery, design reviews, and job scheduling.
• Hardware IBM 3090 Z/OS
• Software DB2 7.0, CICS, CA-Platinum Tool Suite, Omegamon for DB2, STROBE, COBOL, and Erwin/ModelMart 4.14.
• Performed table creatprogram coding and testing, application design, application performance monitoring, and application turnover.
• Hardware IBM 3090 MVS/XA
• Software IBM DB2 3.2, COBOL, CICS, Platinum tool suite, STROBE, and Omegamon
• Developed andion and alters, database recovery for disaster drill, index creation and alters. Ran utilities for copies, reorganizations, statistics update, and modify recoveries. Monitored DB2 activity and applied corrective actions as required. Created new databases and monitored and corrected space (DASD) usage. Supported application development team in technical support. Performed SQL analysis for the application development community with the EXPLAIN function and PLAN ANALYZER Performed logical and physical database design with Erwin/ModelMart. Performed data manipulation with SPUFI, RC/UPDATE, FILE-AID, and various IBM utilities.

Confidential

Senior Application Development Specialist (DB2 DBA)

Responsibilities:

• Supported the application development team of Perot Systems and their client, Confidential Confidential, in the expansion into additional states for insurance business. Performed database administrative tasks for DB2 object creation, database performance monitoring and tuning and application tuning. Performed DB2 system wide performance monitoring and tuning, developed system backup and recovery procedures, enhanced system and application security. Scheduled jobs to perform DB2 maintenance via utility development.
• Skills Utilized:
• DB2 Database Administrator skills in system support, system and application security, system-wide and database monitoring and tuning, system backup and recovery procedures, hardware and capacity planning, utility development, data analysis, object creation, application design and security, application performance monitoring, application database backup and recovery, design reviews, and job scheduling.
• Hardware IBM 3090 OS/390
• Software DB2 6.0/7.0, CICS, CA-Platinum Tool Suite IBM DB2 Tool Suite, Omegamon for DB2 and CICS.
• Performed table creation and alters, database recovery for disaster drill, index creation and alters. Issued grants and revokes and ran utilities for copies, reorganizations, statistics update, and modify recoveries. Monitored DB2 activity and applied corrective actions as required. Created new databases and monitored and corrected space (DASD) usage. Supported application development team in technical support. Provided off-hours call support for production efforts. Performed data manipulation with SPUFI and various IBM utilities. Assisted application development community with SQL analysis using the EXPLAIN function.

Confidential

Consultant

Responsibilities:

• program coding and testing, application design, application performance monitoring, and application turnover.
• Hardware IBM 3090 MVS/XA
• Software IBM DB2 3.2, COBOL, CICS, Platinum tool suite, STROBE, and Omegamon
• Supported IBM Global Services and their client, Confidential in their development efforts. Participated in the data center consolidation effort provided by IBM for the various agencies of Confidential . Performed database administrative tasks for DB2 subsystem installations and upgrades, system support and security, system-wide performance monitoring and tuning. System backup and recovery procedures, utility development, and capacity planning.
• Skills utilized:
• DB2 Database Administrator skills in DB2 installations and upgrades, system support and security, system-wide performance monitoring and tuning, system backup and recovery procedures, capacity planning, and utility development.
• Hardware IBM 3090 OS/390
• Software IBM DB 2 5.0/6.0/7.0, Platinum Tool Suite, BMC Tool Suite, CICS, IMS/DC, Omegamon for CICS and DB2, COBOL, DB2 PM
• Performed DB2 object creations for third part vendor products with the implementation and/or upgrade of the products. Performed maintenance on system catalog and directory for various agencys DB2 subsystem. Participated in the upgrades of various DB2 subsystems along with the installation of new DB2 subsystems. Participated in the consolidation of the various commonwealth agencies to a centralized location. Developed jobs to perform system maintenance on the system catalog and directory for various DB2 subsystems. Scheduled the jobs to perform modify recoveries, statistics update, copies, and reorganizations. Provided off-hours call support for production efforts. Performed SQL analysis with the EXPLAIN function. Assisted with data manipulation for the various database environments using SPUFI, FILE-AID, and various IBM utilities.

Confidential

System Engineer (DB2 DBA)

Responsibilities:

• Supported their client, Confidential for DB2 development and production support. Performed database administrative tasks for DB2 utility development, data analysis, object creation, application design, application security, application monitoring and tuning, and application database backup and recovery.
• DB2 Database Administrator skills in utility development, data analysis, object creation, database performance monitoring and tuning,, application design, application security and turnover, application performance monitoring, application database backup and recovery, and job scheduling.
• Hardware IBM 3090 MVS ESA/XA
• Software IBM DB2 3.2/5.0, Platinum Tool Suite, COBOL, CICS, Strobe, Expeditor, Intertest, Omegamon for DB2
• Developed utilities to backup (make copies), statistics update, modify recoveries, recover tables and indexes, and reorganizations of tables and indexes. Participated in disaster recovery drills for recovery of DB2 subsystems.. Created new and altered existing DB2 objects (tables and indexes) for application enhancements. Granted and revoked privileges as needed and/or requested. Provided off-hours call support for production efforts. Participated in the upgrades of DB2 subsystems, like converting type 1 indexes to type 2 indexes. Scheduled and supported the utility jobs for test, model office, user acceptance, and the production environments. Participated in the study for acquiring third party DB2 tools. Participated in SQL analysis with the use of the EXPLAIN statement. Performed data manipulation with FILE-AID, SPUFI, RC/UPDATE, and various IBM utilities.

Confidential

Consultant

Responsibilities:

• Supported Confidential and their client, Confidential in the preparation and movement of the data center from Camp Hill, PA to Plano TX; along with a technology refresh of the products and applications used on the account.
• DB2 Database Administrator skills in database performance monitoring and tuning, application design application security and turnover, and design reviews.
• Hardware IBM 3090 ESA/XA
• Software IBM DB2 3.2/5.0, Platinum Tool Suite, COBOL, CICS, Strobe, Expeditor, Intertest, Omegamon for DB2
• Reviewed and enhanced CICS/COBOL/DB2 (online) and COBOL/DB2 (batch) application programs to verify compliance with current versions of DB2 and CICS. Assisted DB2 DBA in the creation of DDL and DML statements for application to the various databases.

Confidential

Consultant (Application Programmer)

Responsibilities:

• Supported Confidential in the development of conversion processes and the purge/archive processes of their applications.
• DB2 skills in program coding and testing, application design, application performance monitoring, and application turnover.
• Hardware IBM 3090 MVS/XA
• Software IBM DB2 3.2, COBOL, CICS, Platinum tool suite, STROBE, and Omegamon
• Developed and tested COBOL/DB2 programs to convert the accounts payable check writing function. Also developed a purge/archive process that used COBOL/DB2 programs for the warehouse accounts payable system and the direct store deliverable accounts payable system.