DBA > Job Interview Questions > What is Database Administrator, what is this job like?

WHAT EXACTLY IS A DBA? - Data Warehouse Administ

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

WHAT EXACTLY IS A DBA? - Data Warehouse Administrator

Data Warehouse Administrator
Organizations that implement data warehouses for performing in-depth data analysis often staff DBAs specifically to monitor and support the data warehouse environment. Data warehouse administrators must be capable DBAs, but with a thorough understanding of the differences between a database that supports OLTP and a data warehouse. Data warehouse administration requires experience with the following:
* Business intelligence, query, and reporting tools
* Database design for read-only access
* Data warehousing design issues such as star schema
* Data warehousing technologies such as OLAP (including ROLAP, MOLAP, and HOLAP)
* Data transformation and conversion
* Data quality issues
* Data formats for loading and unloading of data
* Middleware

(Continued on next question...)

Other Job Interview Questions