Australia/Sydney
BlogAugust 11, 2010

Oracle Data Warehouse DBA Top Skills

Fahd Mirza
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.
Share this post:
On this page

Let's Partner

If you are looking to build, deploy or scale AI solutions — whether you're just starting or facing production-scale challenges — let's chat.

Subscribe to Fahd's Newsletter

Weekly updates on AI, cloud engineering, and tech innovations