Maintain Access database of statistical data gathered from a large mainframe database. The Access database intended for monitoring database growth, prognostication and proactive tuning. Perform regular data loads. Create tables, views, queries, reports and forms. Provide ad hoc reporting.
Logical design and maintenance of an Oracle9i data warehouse created as replication of the legacy DMS2200 database. Validate the Entity Relationship Diagrams against the hierarchical-network model of the original database. Create the corresponding tables, indexes and constraints. Maintain statistics, weekly loads of the mainframe data, logical backups (exports). Create SQL*Plus ad hoc reports. SQL query tuning.
DMS2200 Database Administration - Schema changes, reorganizations. Maintain Access database of statistical data for monitoring the mainframe database.
Legacy On Line Transaction Processing (OLTP) applications - Batch/transaction programs tuning, troubleshooting, functio