Wednesday, August 11, 2010

Oracle Data Warehouse DBA Top Skills

Please see if you could add any feature in the following skill set for any DBA who has to manage a data warehouse in Oracle?

  • Dimensional Modeling
  • Concept about architecture of Oracle
  • Partitioning
  • Compression
  • Indexing
  • External Table
  • SQL Loader
  • Parallelism
  • DBMS_STAT
  • SCHEDULER
  • Resource Manager
  • ASM
  • RMAN
  • Materialized Views
  • Data Pump
  • Tuning of ETL like ensuring Set Based Operations, nologging, parallel, etc.
  • Able to make proper assessment of hardware (RAM, I/0, CPU) according to work load and volume of data
If you think anything else should be there, please add your take in comments.