Oracle Database and Application Consulting

 

 

We each have more than 20 years of IT experience.  We are experienced consultants.  Please call 888-803-5607 or email us to discuss how we can help you.

We have extensive hands-on experience with:

  • Database administration (Oracle, DB2, IMS) including installation, tuning (database and application), backup and recovery (including Oracle RMAN), patches, upgrades, conversions and migrations, monitoring and security (including HIPAA compliance).
  • Application development
  • Web site development and enhancements (HTML, ColdFusion MX, Oracle Application Express)
  • Platform and Migration

Recent consulting assignments and projects completed by SkillBuilders include:

  • Completed migration of Oracle10g Release 1 database and ASM instance to Oracle10g Release 2.   See Dave's article documenting the upgrade process
  • Remotely provided advice for corrupt log data on Oracle10g Release 2 in time for critical production migration for an Web-based arena ticketing application database.  This service was requested just hours before the migration;  we were able to respond immediately to the customer's request.  Also remotely monitored production Oracle database with AWR and ADDM after production migration;  provided backup and recovery strategy using Oracle RMAN;  provided temporary Oracle DBA services while primary Oracle DBA was unavailable and advised on several other Oracle administration issues
  • Dave recently completed migrating a health care database from Oracle 8.1.7 to 9.2.0.  This work was done entirely remote, on time and under budget - saving our customer lots of money!  Tasks included installing Oracle9i, applying patches, migrating test data, enabling system for testing, migrating production data and providing complete documentation.
  • Provided DB2, ORACLE , and IMS DBA skills in a large medical complex. Responsibilities included training new DBAs in Oracle and DB2, logical and physical design of a new clinical data repository using the ERWin data modeling tool, installation and testing of ORACLE and DB2, migration of MVS/ESA DBMSs (IMS and DB2) to OS/390, evaluation of DB2 Universal, replication of centralized DB2 repository data to Oracle databases at associated hospitals, and the development of Java web applications accessing ORACLE and DB2 databases via JDBC. Also provided due diligence assessments of HIPAA compliance for existing in-house written applications as well as vendor supplied software.
  • Developed the RIOUG.org website using Oracle Application Express