Administrative DBA – Work on maintaining the server and
keeping it running. Concerned with backups, security, patches, replication,
etc. Things that concern the actual server software.
Development DBA - works on building queries, stored
procedures, etc. that meet business needs. This is the equivalent of the
programmer. You primarily write T-SQL.
Architect – Design schemas. Build tables, FKs, PKs, etc. Work
to build a structure that meets the business needs in general. The design is
then used by developers and development DBAs to implement the actual application.
Data Warehouse DBA - Newer role, but responsible for merging
data from multiple sources into a data warehouse. May have to design warehouse,
but cleans, standardizes, and scrubs data before loading. In SQL Server, this
DBA would use DTS heavily.
OLAP DBA – Builds Multi-Dimensional cubes for decision support
or OLAP systems. The primary language in SQL Server is MDX, not SQL here
Application DBA- Application DBAs straddle the fence between
the DBMS and the application software and are responsible for ensuring that the
application is fully optimized for the database and vice versa. They usually
manage all the application components that interact with the database and carry
out activities such as application installation and patching, application
upgrades, database cloning, building and running data cleanup routines, data
load process management, etc.
No comments:
Post a Comment