Post reply

Types of DBA's ???

  • October 16, 2012 at 6:44 am

    #264334

    Can any of you gentlemen tell me totally how many types of DBA's exists for an organization or overall

    Administrative DBA

    Development DBA

    Architect DBA

    Data Warehouse DBA

    OLAP DBA

    Are above mentioned list is correct anymore will you add to it ?

    I need Types of DBA's and their description.

    Thank you for all,

  • October 16, 2012 at 7:29 am

    #1549553

    Application Support DBA

  • October 16, 2012 at 7:48 am

    #1549568

    Thanx.. Is there any production DBA, if possible can you/anyone give me a small description regarding all DBA types ..

  • October 16, 2012 at 8:28 am

    #1549607

    Hybrid DBA

    Accidental DBA

    😀

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 16, 2012 at 9:09 am

    #1549633

    Good DBA, Bad DBA, Ugly DBA. :w00t:

    I've heard of it more as Production dba instead of administrative dba.

    a quick google /Feeling lucky gives me this which about covers it, but the names of the tiles will vary, but job is about the same.

    http://www.craigsmullins.com/dbta_065.htm

  • October 16, 2012 at 9:28 am

    #1549644

    Don't forget evil DBAs!

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46783

  • October 16, 2012 at 9:36 am

    #1549648

    Scary DBA?! http://www.scarydba.com/

    ---------------------------------------------------------

    It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
    David Edwards - Media lens[/url]

    Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
    Howard Zinn

  • October 16, 2012 at 9:56 am

    #1549659

    At least in the US, keyword searches on a job site would also include Business Intelligence. This would have parts of Architect, Data Warehouse, and OLAP DBA's in the skill set.

    Production support would include monitoring the backup and maintenance jobs run, and taking corrective actions as required. Also responding to alerts, and escalating to the application DBA's or developers when apappropriate. Running DML scripts in production with the proper authorization. Service pack and hotfix upgrades, and QA after OS and server level patching.

    The division of labor will vary from shop to shop. In a smaller shop, DBA's wear more hats. Even in large companies, there may be autonomous business units who have partial or complete control over their own systems.

  • October 16, 2012 at 11:04 am

    #1549694

    Thank you @SSC Rookie i appriciate your explanation..

    And rest of you friends give some information which can make discussion to go on to improve knowledge

    Thank you

  • October 16, 2012 at 11:50 am

    #1549713

    http://www.reluctantdba.com/

  • October 16, 2012 at 2:45 pm

    #1549791

    I'm not entirely sure what you're looking for here. There are probably as many "types" of "DBA" as there are DBAs in the world. I seriously doubt any two have exactly identical duties, skills, expectations, etc.

    The key to being a DBA is flexibility, both in scope and strength of skills, and in focus of duties and projects.

    Last week, I spent most of the week administering databases and servers. I wrote up some scripts I've been meaning to do for a long while, since I finally had time for them, and automated some reports to myself from the servers. Database growth charts, smarter index cleanup, a few things like that.

    This week, I'm debugging an ETL process that was originally implemented based on flawed understanding of the business rules.

    A few months ago, I was cleaning up millions of rows of data that had duplicates, fuzzy matches, etc., and doing complex pattern analysis on things like multinational names and addresses.

    Today I had to debug a stored procedure that was failing without raising an error message.

    Next month, I'll be upgrading a server to SQL 2008 R2, including upgrading all the SSIS packages on it.

    There are plans, early next year, to build a whole new set of on-site database servers, with a serious hardware upgrade at all levels (CPUs, SAN, you name it).

    What "type" of DBA does that make me?

    My job before this one, the main emphasis was on setting up SSRS and on a DR plan implementation. What type of DBA does those two things?

    So, don't worry about the specific titles. They usually don't mean much, in the real world, anyway.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • October 16, 2012 at 3:55 pm

    #1549811

    vamsi056 (10/16/2012)

    Thank you @SSC Rookie i appriciate your explanation..

    And rest of you friends give some information which can make discussion to go on to improve knowledge

    Thank you

    Gosh! When did Google go down? Do you know when it's coming back up? :blink:

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • October 16, 2012 at 6:58 pm

    #1549840

    Jeff Moden (10/16/2012)

    vamsi056 (10/16/2012)

    Thank you @SSC Rookie i appriciate your explanation..

    And rest of you friends give some information which can make discussion to go on to improve knowledge

    Thank you

    Gosh! When did Google go down? Do you know when it's coming back up? :blink:

    G

    o

    o

    g

    l

    e

    d

    o

    w

    n

    .

    :w00t:

  • October 16, 2012 at 10:25 pm

    #1549859

    😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • October 17, 2012 at 2:15 am

    #1549900

    Lowell (10/16/2012)

    Accidental DBA

    😀

    +1 🙂

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply