Information Technology Reference
In-Depth Information
Topics within the Database Track
There are various job titles given to database activities in the workplace, such as these
listed on the ITWORKS-OHIO Web site: Data Analyst, Database Administrator, Database
Analyst, Database Developer, and Database Specialist. Many others exist in the marketplace.
However, based on the author's opinion, when the job descriptions are examined, one can
find that there are really three, interrelated roles. Figure 1 illustrates these roles using the
structure of a house as an example. The DBA (as the foundation) keeps a database available,
secure, and healthy. Without the DBA, the rest of the database team could not function. The
database developer (as the framing of the house) encodes the business logic in the database.
Additionally, the developer often develops the interface layer between the system software
and the database engine. Last, the database architect (as the roof of the house) is often a senior
staff member. Typical duties include determining the amount of business logic to be encoded
in the database, developing the database design (including distribution of data, data flows,
etc.), and often overseeing the implementation of the database. Like the components of a
house, all three roles are codependant and necessary. In addition to the specific duties, each
member must maintain several lines of communication within the development team and
organization.
The database administrator must often work with the system/network administrators
when it comes to purchasing hardware, determining network traffic and bandwidth require-
ments, coordinating the use of backup devices, etc. They often work with the database
architects in providing recommendations for physical implementation issues. The database
developer must interact with the database architect since they are implementing the design
from the architect, and with the system developers to ensure that the developers have access
to the data they need, while maintaining the integrity of the database. The database architect
must work with the software architect. Together they determine how to partition the business
logic of the system. The database architect works with the DBA in determining the best
physical implementation of the supporting database. And, the architect often coordinates
the activities of the database developers.
Figure 1. Database roles
Database Architect
Oversees all database activities on a project
Provides the vision and leadership for the database staff
Works closely with the Database Developers, DBAs, and System
Architects
Database Developer
Develops and maintains the procedural integrity of the database
Works closely with the Database Architect and the Application
Developers
Database Administrator
Ensures that the database is accessible when it is called upon
Performs backups and enforces security policies
Works closely with the Database Architect and System
