Could you please explain the differences between a database engineer, a database architect and a database administrator?
Great question! It can get pretty confusing as these titles (and many more including database developer, data architect, data analyst, data modeler, database designer, etc.) are often intermixed, used improperly, or redefined by the companies using them. The definition really depends on the actual job descriptions as defined by the various companies posting them. I will do my best, however, to differentiate and simplify them for you.
Database Administrator. This is by far the most commonly used database-related job title. A database administrator (DBA) is a person responsible for the daily care and feeding of a database. A DBA's primary responsibility is to ensure that the database is available, is performing properly and is kept safe. This includes such tasks as software installation, upgrades and patching, backup and recovery, performance tuning, security, monitoring, problem solving, etc.
Database Architect. Often referred to as a Data Architect, a DA is responsible for gathering business requirements, designing a logical model and ultimately building the physical database. The DA is expected to analyze business needs and create a database solution to meet them. Tasks include requirements definition, business analysis, data modeling, database design; E-R (Entity Relationship) models, database programming, business report generation, ETL procedure development, database performance optimization, etc.
Database Engineer. This term is not really that commonly used and can often just be referring to one or both of the above definitions. One example job description that I found describes the Database Engineer as someone who is expected to "design, implement and maintain database systems," (serving as both DB and DBA).
Expert Michael Hillenbrand discusses whether Linux certification is necessary for a job in Oracle.continue reading
An Oracle user asks who should do the source-to-target mapping in a company--the Business Analyst or Data Architect.continue reading
Managing an Oracle shop expert Michael Hillenbrand talks about his experiences with remote database administration.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.