More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
WHAT EXACTLY IS A DBA? - Database Architect
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.
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 general-purpose 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.
(Continued on next question...)