SUMMARY:

• To utilize my years of experience as a mainframe database specialist for mission critical applications, providing system administration, application support, disaster recovery and technical training.
• Have many years of experience supporting mission - critical database systems such as DB2, IMS, and MQSeries on a mainframe environment servicing a wide variety of industries including auto manufacturing, defense contractors, insurance, county government, and finance.
• Technical system programmer expertise general summary:
• Performed database system installation and maintenance using SMP/Efor DB2, IMS and MQSeries.
• Preformed problem determination of both system and application errors and performance issues using various IBM diagnostic tools including IPCS, GTF traces, slip traps, diagnostic dump data, worked with vendors to resolved errors in vendor code by supplying them with diagnostic data and applying vendor supplied fixes.
• Provided consulting service to Database Administrators to ensure new or modified applications would perform to customer’s expectations by providing performance data and testing in test environment.
• Worked with data warehouse teams to accomplish ETL (Extract, Translate, Load) of data using Infosphere.
• Provided technical analysis and preventive measures for RCA (Root Cause Analysis) for client’s interrupts to services involving database systems.
• Performed queue manger duties for reported database issues using various problem management systems such as AHD.
• Duties included triage of problem, assignment to appropriate team member, ensuring timely updates, and developing a suggested preventive measure that would be approved by the client for closure of the issue.
• Monitored DB2 catalog databases to ensure optimal performance of DB2 system related functions.
• Worked with client to develop and implement disaster recovery procedures of both DB2 catalog and application data.
• Performed complex restarts of DB2 using conditional restart at customer’s hot site locations.
• Used DB2 utilities including DSN1PRNT, DSN1LOGP, DSNJU004 to view DB2 internal data for conditional restart and problem determination of system related issues.
• Review DSNZPARM settings for optimal performance and made recommendations and implemented changes when necessary.
• Developed SQL statements to review system related database information.
• Published articles in Mainframe magazine regarding DB2 performance monitoring.
• Managed many high visibility projects to accomplish installs of system software and or maintenance of existing software without interrupt to client service levels.
• Worked directly with client representatives to identifying client requirements and to ensure those requirements were met by the deliverables of project.
• Provide project management services for complex database system upgrades for multiple clients.
• Ensuring that stated deliverables were acceptable to clients requirements.
• Provided technical consulting services for new and existing DB2 applications.
• Services included providing performance analysis reports in development environment prior to promotion into production. Using various DB2 utilities including DB2 performance monitoring reports.
• Developed automated system to flag and record resource deadlock situations with DB2 and IMS connections and allow applications group to review program logic to remove bottleneck.
• Assisted application developers in creating QMF and SPUFI queries.
• Programming languages used include Assembler, COBOL, PL/1, Python, REX.
• I have written code in Assembler to read VSAM files and assist in reporting various system related data.
• I have also written Assembler code user exits for IMS database customization.
• I have written COBOL programs for reporting on system related data. I have also assisted application programmers with their COBOL programs when they encountered errors.
• Extensive experience in IMS internals and performance tuning.
• Performed sysgen operation to define resources to IMS.
• Deep understanding of sysgen macros settings to customize IMS environments.
• Have the ability to read IMS assembler system code to help resolve system related issues.
• Familiar with application related functions such as PSB gen, ACB gen, MFS gens.
• Created code to review IMS application performance using IMS monitor data and report exceptions providing automated alerts of potential performance problems preventing costly delays in processing.
• Passed technical proficiency interview with Confidential technical staff for both IMS and MQseries before being allowed to support the software.
• Was responsible for primary support of IMS and MQseries system related activities.
• Worked closely with Confidential system personnel to install upgraded software for both IMS and MQseries.to ensure proper coordination with headquarters in Tokyo.
• Participated in Confidential ’s effort migrate / share data off to other platforms using IMS Connect product

EXPERIENCE:

Confidential, San Diego, CA

Senior Computer Scientist

Responsibilities:

• Technical team lead for team servicing over 28 concurrent client’s IMS, MQSeries and Oracle database system administration.
• Responsible for maintaining strict 99.9% database availability service levels. Provide technical training to junior members of team.
• Determined work assignments for team members to provide software upgrades and run and maintain efforts.

Confidential, San Diego, CA

Database System Programmer

Responsibilities:

• Lead DB2 database team.
• Developed disaster recovery procedures for critical business applications.
• Performed disaster recovery testing of production DB2 database systems.
• Performed database software problem determination by storage dumps using IPCS.
• Worked with IBM support team to find software fixes and restore service.
• Wrote assembler code programs to assist in recovery of application databases drastically reducing the time needed to correctly restore mission critical data.