Enjoying life, no longer in IT.

Specializing in Oracle Database Administration for OLTP (transactional) and OLAP (data warehouse) environments; including instance and database creation, capacity planning, data migration, maintenance, instance and database tuning, and, trouble-shooting.

Perform health checks, monitoring, and performance tuning for in-house and third party developed Oracle Database Instances for the Colorado Department of Transportation. Responsible for providing input to the Security Office and Management regarding Oracle Patch Sets and their application. • Advised the EARS (Electronic Accident Reporting System) Management throughout a major application and database conversion project from FoxPro to Oracle • Tuned the Oracle instances, database… Show more Perform health checks, monitoring, and performance tuning for in-house and third party developed Oracle Database Instances for the Colorado Department of Transportation. Responsible for providing input to the Security Office and Management regarding Oracle Patch Sets and their application. • Advised the EARS (Electronic Accident Reporting System) Management throughout a major application and database conversion project from FoxPro to Oracle • Tuned the Oracle instances, database objects, and code reducing SQL Script runtimes from 8 to 10 hours to less than 5 minutes • Upgrading 13 Oracle 11gR2 Database Instances on MS Windows 2008 R2 Enterprise Servers in an Oracle Fail-Safe configuration targeted to Oracle 12c Enterprise Database Instances on virtualized, stand-alone Red Hat Enterprise Linux v6.x Servers. • Implemented and scheduled nightly and weekend RMAN and Data Pump data backups and data transfer routines as well as supporting maintenance scripts. • Tuned and adjusted data base parameters, disk allocation, UnDo table sizing and retention parameters, and, code performance where appropriate. Show less

Specializing in Oracle Database Administration for OLTP and OLAP environments; including database and instance creation, capacity planning, data migration, maintenance, instance and database tuning, and trouble-shooting.

Performed database and instance creation in HP/UX, Linux, and Windows Server environments. Monitored and tuned instance parameters, and, table space and logging utilization for the development (DEV), quality assurance (QA), and production (PROD) databases reducing load times from 10 to less than 4 hours. Provided management with TCO (total cost of ownership) and ROI (return on investment) implementation comparisons. Ensured incremental and full database backups were… Show more Performed database and instance creation in HP/UX, Linux, and Windows Server environments. Monitored and tuned instance parameters, and, table space and logging utilization for the development (DEV), quality assurance (QA), and production (PROD) databases reducing load times from 10 to less than 4 hours. Provided management with TCO (total cost of ownership) and ROI (return on investment) implementation comparisons. Ensured incremental and full database backups were successful.• Participated in the design and implementation of Star Schema Data Warehouses consisting of Dim, Fact, and Aggregate Tables in support of the Business Intelligence Team utilizing Oracle Warehouse Builder (OWB) ETL Mappings. • Implemented and scheduled nightly and weekend data load routines of the ODS (Operational Data Store), Data Warehouse, and Data Vault as well as supportin maintenance scripts. • Tuned and adjusted data base parameters, disk allocation, and code performance where appropriate.• Analyzed data sources (legacy systems), designed ETL mappings, tested, and, ensured ETL mapping and code success through an in-house developed code and process promotion methodology. Show less