Home > Ask the Data Management Experts > DBMS and data warehousing Questions & Answers > Database administrator job roles: Organizing the DBAs
Ask The Data Management Expert: Questions & Answers
EMAIL THIS

Database administrator job roles: Organizing the DBAs

Mark Whitehorn EXPERT RESPONSE FROM: Mark Whitehorn

Pose a Question
Other Data Management Categories
Meet all Data Management Experts
Become an Expert for this site


Tips, expert advice and sample chapters
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 17 January 2008
I am one of several database administrators (DBAs) in my company. We are trying to segregate our duties (figure out who does what). Is there an easy way to do this? Are there "levels" of DBAs?

>
EXPERT RESPONSE
A common model for establishing database administrator (DBA) job roles is as follows: The guy who has been doing the job longest takes charge. He becomes the top level, or Senior DBA; the others drop into the lower levels, take no part in the decision making process and are simply given tasks to accomplish. What could be simpler or more appropriate?

While it is clear (I hope) that I am being facetious about this being "appropriate", we all know that this is what often happens. So the first question is – do we want/need a DBA hierarchy with levels?

In an organization where, as in your case, you still talk to each other and try to work together, it sounds as if levels are inappropriate. My advice would be to work as a team, split the work up between all DBAs and keep the hierarchy flat.

How do you segregate the work? The tempting answer is to split it up by both existing skills and preference. So, if you have a DBA who is good with indexes, put him or her in charge of indexing and so on. The problem with that, however, is the old one of redundancy. What happens when the indexing guy goes? So, in an organization with a limited number of DBAs, my temptation is to share the work evenly, learn from each other, expand your own skill sets and provide redundancy for the company at the same time.

Of course, in large organizations with many DBAs there are very good reasons for developing levels. In a perfect world those with experience and vision lead while those who are new and gaining experience are led. As the comic character Dilbert suggests, this ideal in not always perfectly achieved...

More on DBA jobs and roles

  • Understanding the DBA job description: Database administrator's roles and responsibilities
  • Database administration: DBA staffing considerations
  • Data warehousing jobs: Using your database administrator experience
  • Developer and DBA: Working together for greater efficiency


  • Sound Off! -   Be the first to post a message to Sound Off!


    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


    RELATED CONTENT
    DBMS and data warehousing
    Data warehousing, data mining and data querying: Terms and definitions
    The difference between data definition language (DDL) and data manipulation language (DML)
    What is an operational data store vs. a data warehouse?
    Can a dimension table be a fact table for another data mart?
    Top three database management system (DBMS) trends
    Can I have two data warehouses?
    Data modeling for data warehouse projects
    Data warehouse testing
    Data warehouse development: Four strategic steps
    Logical database design

    Data management jobs
    Business intelligence and data warehousing salaries continue to rise
    Data management industry event and conference calendar
    DAMA keynote: Survival of the data management fittest
    IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 2
    IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 1
    IBM DB2 9 Fundamentals certification (Exam 730): Sample question No. 7
    IBM DB2 9 Fundamentals certification (Exam 730): Sample question No. 8
    Business intelligence analyst career advice
    Data architect careers: The benefits of working at a System Integrator
    IBM DB2 9 Fundamentals certification (Exam 730): Sample question No. 6

    Database management systems (DBMS)
    The difference between data definition language (DDL) and data manipulation language (DML)
    Can a dimension table be a fact table for another data mart?
    Top three database management system (DBMS) trends
    DB2 looks to enterprise information management to fend off Microsoft
    Data migration planning: Key things to remember
    Logical database design
    Data migration evolves from scripts to software
    The latest database management system (DBMS) trends
    Centralized database systems vs. data silos for master data storage
    Gartner data warehouse DBMS Magic Quadrant 2007: New tools, old mantras

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    data classification  (SearchDataManagement.com)
    OLAP  (SearchDataManagement.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary



    Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice

    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




    All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts