Regis Lichimo

Address: 3887 Cates Landing Way

North Vancouver

BC Canada

V7G 2N6 Email:mailto regis_lichimo@yahoo.com

May 2014 to May 2024 DB2 System Programmer,DB2 DBA Contract

IBM/Kyndryl

DSHS/State of Washington

Primary support for all DB2 for zOS subsystems and related software.

Highlights

• Rebuilt all DB2 subsystems from scratch at Version 11.
• Migrate to DB212 and RSU Upgrades
• Install and Customize DB2 third party Software
• Built Db2 subsystems for performance testing
• Provide Support for IMS to DB2 conversion
• DB2 disaster recovery planning and testing
• Verified accuracy of replication flowing from IMS to DB2

Nov 2007 – May 2014 Senior DBA (Contract)

WorkSafeBC

DB2 DBA For Claims Management System (CMS). CMS is built on top of CURAM for DB2/ZOS. CURAM as significantly modified. CMS was built to replace legacy application. CMS is a high volume system running 24 X 7.

Highlights

• Create multiple environments for testing.
• DB2 table modification based on data model
• Improve SQL Performance
• Implement CMS in production
• Cloning of production data to a reporting lpar. Automate postsnap process.
• Develop a process to data fix large quantities of rows
• Develop a process to cleanup select CMS tables that would grow at an alarming rate.
• Script to populate reporting data on DB2 LUW.

Primary DBA for DataWarehouse/BI. The Datawarehouse resides on SQL Server. Data is replicated from DB2-ZOS into SQL Server. Delta rows are processed daily via ETL process into dimension and fact tables in the data warehouse. ETL Process is built on DataStage. Responsible to all aspects of Sql Server database administration and support of ETL processing.

1978 - 1983 Bachelor of Science, Simon Fraser University

Attended multiple DB2 Conferences