Types of DBA's ???

  • vamsi056

    Mr or Mrs. 500

    Points: 583

    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,

  • Chandra Sekhara Vyas Dhara

    SSChampion

    Points: 10207

    Application Support DBA

  • vamsi056

    Mr or Mrs. 500

    Points: 583

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

  • Lowell

    SSC Guru

    Points: 323442

    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!

  • Ray M

    SSC-Insane

    Points: 21093

    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

  • Michael Valentine Jones

    SSC Guru

    Points: 64818

    Don't forget evil DBAs!

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

  • Abu Dina

    SSChampion

    Points: 14155

    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

  • lptech

    Hall of Fame

    Points: 3188

    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.

  • vamsi056

    Mr or Mrs. 500

    Points: 583

    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

  • homebrew01

    SSC Guru

    Points: 55137

    http://www.reluctantdba.com/

  • GSquared

    SSC Guru

    Points: 260824

    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

  • Jeff Moden

    SSC Guru

    Points: 995147

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • Lynn Pettis

    SSC Guru

    Points: 442180

    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:

  • Jeff Moden

    SSC Guru

    Points: 995147

    😛

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • Boris Pazin

    Ten Centuries

    Points: 1036

    Lowell (10/16/2012)


    Accidental DBA

    😀

    +1 🙂

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

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