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

TECHNICAL SKILLS:

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: 3090 Z/OS

Software: DB2 8.0, IMS, BMC Tool Suite (Catalog manager and Change manager), File-Aid for DB2, Mainview for DB2.

PROFESSIONAL EXPERIENCE:

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.

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.

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 .

Confidential

Senior DB2 Administrator

Responsibilities:

• Responsible for the implementation of DB2 V8 subsystems, evaluation and recommendations for third party products, and interface to other Confidential 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.
• 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 Confidential 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.
• Performed table creation 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 Confidential utilities.

Confidential

Senior Application Development Specialist (DB2 DBA)

Responsibilities:

• Supported the application development team of Perot Systems and their client, 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.
• 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 Confidential utilities.
• Assisted application development community with SQL analysis using the EXPLAIN function.

Confidential

Consultant (DB2 Systems Programmer)

Responsibilities:

• Participated in the data center consolidation effort provided by Confidential for the various agencies of the 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.
• 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 Confidential utilities.