What and what is expected?

Discussion in 'Databases' started by mat6plus, Nov 25, 2007.

  1. #1
    Its nice to know it's not all about the certification that matters but what you can do but if i may ask what and what is expected of a database administrator i mean a all and all responsibility of a database administrator.
    Pls share your idea with me.
     
    mat6plus, Nov 25, 2007 IP
  2. live-cms_com

    live-cms_com Notable Member

    Messages:
    3,128
    Likes Received:
    112
    Best Answers:
    0
    Trophy Points:
    205
    Digital Goods:
    1
    #2
    I guess you would need to keep the hardware working well and to make sure the SQL statements are not CPU hogs. Not really sure what else. I imagine you would need to know a LOT of SQL, or would that be left up to the programmers?

    I think I remember Shawn saying that if somebody wants to change their username the database lags out. Being the database admin you would need to have structured the database to avoid this or at least know not to try it, so the database DOESN'T lag out.
     
    live-cms_com, Nov 25, 2007 IP
  3. Petey

    Petey Peon

    Messages:
    68
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I would say there are three main jobs for a DBA:

    Database design - Either design a database from scratch or tune-up an existing database for you. A DBA will tell you exactly what hardware you need to deliver the performance you require.

    Database development - Create the physical database, sort out the security and setup the backup routines.

    Database support - Monitor performance and recommend/make changes to SQL queries to improve performance.
     
    Petey, Nov 26, 2007 IP