Home > Types of DBAs
Chapter Download:
EMAIL THIS LICENSING & REPRINTS

Types of DBAs

21 Nov 2005 | Written by Craig S. Mullins

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

The following is an excerpt from Database Administration: The Complete Guide to Practices and Procedures, by Craig Mullins. It is reprinted here with permission from Addison Wesley Professional. Read the chapter below to learn about the various types of database administrators (DBAs) or download a free .pdf of the chapter: "Types of DBAs."

There are database administrators (DBAs)who focus on logical design and DBAs who focus on physical design; DBAs who specialize in building systems and DBAs who specialize in maintaining and tuning systems; specialty DBAs and general-purpose DBAs. Truly, the job of DBA encompasses many roles.

Some organizations choose to split DBA responsibilities into separate jobs. Of course, this occurs most frequently in larger organizations, because smaller organizations often cannot afford the luxury of having multiple, specialty DBAs.

Still other companies simply hire DBAs to perform all of the tasks required to design, create, document, tune, and maintain the organization's data, databases, and database management systems. Let's look at some of the more common types of DBA.
More database administration resources
DBA staffing considerations

Roles of a DBA

Using DBA experience to find a data warehousing job

DBA type 1: System DBA
A system DBA focuses on technical rather than business issues, primarily in the system administration area. Typical tasks center on the physical installation and performance of the DBMS software and can include the following:

  • Installing new DBMS versions and applying maintenance fixes supplied by the DBMS vendor
  • Setting and tuning system parameters
  • Tuning the operating system, network, and transaction processors to work with the DBMS
  • Ensuring appropriate storage for the DBMS
  • Enabling the DBMS to work with storage devices and storage managementsoftware
  • Interfacing with any other technologies required by database applications
  • Installing third-party DBA tools

System DBAs are rarely involved with actual implementation of databases and applications. They might get involved in application tuning when operating system parameters or complex DBMS parameters need to be altered.

DBA type 2: Database architect
Some organizations create a separate position, database architect, for design and implementation of new databases. The database architect is involved in new design and development work only; he is not involved in maintenance, administration, or tuning of established databases and applications. The database architect designs new databases for new or existing applications.
More information about this book
Database Administration: The Complete Guide to Practices and Procedures
By Craig S. Mullins
Published by Addison Wesley Professional
ISBN: 0201741296
Published: June 2002
Pages: 703
To learn more about types of DBAs, buy this book!

The rationale for creating a separate position is that the skills required for designing new databases are different from the skills required to keep an existing database implementation up and running. A database architect is more likely than a generalpurpose DBA to have data administration and modeling expertise.

Typical tasks performed by the database architect include:

  • Creating a logical data model (if no DA or data modeler position exists)
  • Translating logical data models into physical database designs
  • Implementing efficient databases, including specifying physical characteristics, designing efficient indexes, and mapping database objects to physical storage devices
  • Analyzing data access and modification requirements to ensure efficient SQL and optimal database design
  • Creating backup and recovery strategies for new databases

Most organizations do not staff a separate database architect position, instead requiring DBAs to work on both new and established database projects.

Continue reading Types of DBAs and download a sample chapter
Read other excerpts and download more sample chapters from the Chapter Download Library

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


RELATED CONTENT
Database management systems (DBMS)
Worst practices: How not to choose a database engine
Database selection 101: How to choose a database engine
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
Database administrator job roles: Organizing the DBAs
Data migration planning: Key things to remember
Logical database design
Data migration evolves from scripts to software

Enterprise data architecture management
Data migration planning: Key things to remember
Data architecture vs. information architecture
Data architect careers: The benefits of working at a System Integrator
Responsibilities of the information architect
A guide to conceptual data models for IT managers
SOA and decentralized IT systems
SOA and business rules management
Data management jobs are out there, but many don't know it
Data and the enterprise architecture framework
XQuery and XML data: DB2 helps manage the era of unstructured data

Data warehousing / DBMS
DB2 tools and products for Linux, UNIX and Windows: The basics
Understanding IBM DB2: Product history and strategy
Database management: How to protect your electronic security systems
Definitions of design and data modeling
What is a data model?
Introduction to network analysis, architecture and design
Business process change: A guide for business managers and Six Sigma professionals
A guide to the IBM DB2 9 Fundamentals certification exam
Multiuser application design strategies for Microsoft Access
XML basics: What is XML?

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


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