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

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: Confidential 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: Confidential 3090 Z/OS, DB2 Linux 9.7.4

Software: DB2 9.0 DB2 10.0, Confidential 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: Confidential 3090 Z/OS

Software: DB2 9.0 DB2 10.0 Confidential 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: Confidential 3090 Z/OS

Software: DB2 8.0 DB2 9.0, Confidential DB Admin Tool, Confidential Application Performance Analyzer, Mainview, Confidential 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 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.

Skills Utilized:

Hardware: Confidential 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.

Hardware: Confidential 3090 Z/OS

Software: DB2 7.0, CICS, CA-Platinum Tool Suite, Omegamon for DB2, STROBE, COBOL, and Erwin/ModelMart 4.14.

Confidential

Senior Application Development Specialist (DB2 DBA)

Responsibilities:

• Supported the application development team of Perot Systems and their client, 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.

Hardware: Confidential 3090 OS/390

Software: DB2 6.0/7.0, CICS, CA-Platinum Tool Suite Confidential DB2 Tool Suite, Omegamon for DB2 and CICS.

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.

Hardware: 3090 OS/390

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