Starting this thread with a hope that people would contribute as much as they can.
How responsibilities differ in these three roles????
Technical Knowledge needed for these three roles in respective areas???
Shaan - Virginia - USA
OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
It's difficult to say as each company has it's own interpretation of these terms but I suppose you could start of with:
Database Administrator - All the usual stuff. Software installation, upgrade, backup, recovery, tuning etc.
Datawarehouse Administrator - Same as Database Administrator with additional responsibility for ETL (Extraction Tranformation Loading) of new data into the warehouse. Some sites will have a seperate person/department for traditional DBA duties and specialists for the warehousing elements.
Applications DBA - Same as Database Administrator with additional tuning as a result of poorly written Oracle applications
The Application DBA must have good knowledge in system, design, system documentation, system inetegration, system architect, etc...
Application DBA - will NOT handle Backup $ Recovery situations, or any technical aspect of Oracle. I.e. Application of Patches, migrating databases, etc. Handle SEGMENT sizing, creation, user creation role creation, indexes management.
Technical DBA - handle all technical aspecs of DBA, backup and recovery, database creation, migration, tablespace creation, datafile manipulation, Oracle installations.
I've been in two LARGE organisations where have this level of differentialtion (One is the largest Telco in Australia). I can sometimes be a right pain in the arse.
OCP 8i, 9i DBA
Click Here to Expand Forum to Full Width