DBA Vs DWHA Vs Apps DBA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DBA Vs DWHA Vs Apps DBA

  1. #1
    Join Date
    Dec 2001
    Posts
    139
    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???

    Database Administrator
    Datawarehouse Administrator
    Applications DBA


    Regards
    Shaan - Virginia - USA
    rshaan@hotmail.com
    ___________________________
    OCP DBA 9i, 8i - DEV 6i, 2.0, 1.0
    SCSA 8.0

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The Application DBA must have good knowledge in system, design, system documentation, system inetegration, system architect, etc...

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width