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.
No comments:
Post a Comment