Solutions

 

In the past years I have -among other things- faced the following challenges and come up with good solutions:

 

• Sponsorship registration system (workflow) using Oracle Forms/Reports 6i
• Central Addressbook with advanced automatic export/import engine (See Publications for an article  - in Dutch)
• Trigger Generator (light weight case tool)
• Financial reports
• Time Registration applications
• Generic search screen
• Periodic maintenance system with automatic workload generation
• A number of Oracle installations and upgrades
• Data conversions
• Administrative web based GUI using Oracle Jheadstart/ADF Faces
• Website with fast serach engine and automatic extracts
• Unix Oracle backup and recovery scripts
• Online backup design with RMAN / database duplications
• Online and offline backup design with BackupExec
• Oracle Row Level security / Fine Grained Access Control (VPD)
• Oracle password profiling
• Oracle 10g Cluster installation with Failsafe
• Oracle 10g Performance tuning in Siebel OLTP and OLAP environment (using partitioning, Extended SQLTrace, DBMS_STATS, Materialized views
• Oracle 9i RAC DBA