Functioned as Project DBA and System Architect during the downsizing of this project. The project used over 140 database tables that occupy 12GB of storage. Developed software to maintain duplicate read-only copies on the PC/LAN of 30 databases that were maintained on the Mainframe in Datacom/DB. This process is completely data driven and consists of a Mainframe extract program and a PC database update program. Changes are detected on the Mainframe, the changed records from each table are extracted and sent to the PC along with the copybook for the table. The PC update program processes the copybook and builds an internal table that maps the input data fields and data types. It then uses the SQL dictionary tables to dynamically create an Update or Insert command with the data from the mainframe extract record. It also performs a full database record count comparison and hash-total to ensure that the databases are in sync.