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