John Ou Email & Phone Number

Develop and maintain IMS databasesPerform all IMS databases internal activities; duties include DBDGEN, PSBGEN and ACBGEN. Convert database to IMS HALDB. Lead IMS team to a successful IMS Disaster Recovery. Create and maintain DB2 objects. Application support for Views and Stored Procedure, database design and enhancement. Migration of IMS/DB2 database to.

Took personal ownership of assigned application IMS and DB2 systems and delivery support.Coordinated and implemented changes to development, test, and production environments.Evaluated DBMS software products and provided recommendation to management. Tuned and monitored of IMS and DB2 database for optimal performance. Certification of Software products.

- IMS and DB2 support to all application developers. - Tuning and performance monitoring of existing database. - IMS databases creation for HIDAM/HDAM/SHISAM/HISAM. - DB2 database creation included tables/indexes/synonyms/view and relational integrity rules verification. - IBM Data Dictionary documentation for systems being developed. - Consultant to other.

• Deployed software utilities for IMS and DB2. Customized software product to internal environment needs.
• Interfaced with software vendors for problem and issues to ensure timely resolution.
• Maintained/modified in-house written COBOL program to support the IMS environment.
• Researched and evaluated DB2 vendor’s products. Contributed findings and recommendation for management that lead to BMC DB2 utilities purchase.
• On call support rotation for production IMS and DB2.
• Supported the IBM Data Dictionary Release upgrade.

Perform all IMS databases internal activities, duties include DBDGEN, PSBGEN, COMPRESS databases. Migration of IMS related products to new version/release.Support all application area related to database design and enhancement.Monitored and managed DASD for all Production databases. Evaluate and test vendors Database utilities products, customize software.