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, Summerdale, Pennsylvania

DB2 DBA

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

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