Regis Lichimo
Senior DB2 System Programmer
Hire this person
Send a job offer directly to this candidate
About
Address: 3887 Cates Landing Way
North Vancouver
BC Canada
V7G 2N6 Email:mailto regis_lichimo@yahoo.com
Experience
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.
Education
1978 - 1983 Bachelor of Science, Simon Fraser University
