Oracle Data Warehouse DBA
Oracle Database Tips by Donald Burleson
An Oracle data warehouse DBA has specialized
Oracle DBA skills relating to the administration and management of a
large database with an analytical front-end:
Very large databases (VLDB) - Oracle
DBA partitioning skills.
Decision support systems (DSS) -
Materialized view DBA setup and Oracle Discoverer
Online analytical processing (OLAP)
- Star schema design and DBA administration.
In addition, some Oracle data warehouse DBA's
require skills in Business Intelligence tools management for
products such as Oracle Discoverer, Oracle warehouse builder (OWB)
and Oracle Data Mining (ODM).
Oracle data warehouse DBA skills
The Oracle data warehouse DBA often has an
advanced degree in statistics because multivariate (chi square)
analysis is part and parcel of Oracle advanced analytics. The Oracle
data warehouse DBA must also understand predictive modeling and
The Oracle data warehouse DBA must also have
specialized skills on Oracle materialized views, Oracle
partitioning, and specific OLAP tools such as Cognos and SAS
For an example Oracle DBA data warehouse
Carolyn Hamm. Note her DBA data warehousing skills and
warehouse skills - Oracle Discoverer, Oracle OLAP and Oracle
Data Warehouse Builder, and is an expert in multivariate
statistics using SAS, SPSS and Clementine.
degree - Ph.D. in Experimental Psychology
DBA data warehouse professional memberships
- NIH Data Mining Multidisciplinary Research Team 2005 Oracle
Life Science User Group (OLSUG)
DBA research publication in data
warehousing - An Operational Data Store for Reporting Clinical
Practice Guideline Adherence in Chronic Disease Patients
Here are my notes on Oracle data warehouse DBA
If you like Oracle tuning, you may enjoy my new book "Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts.