What is the difference between database administrator and database analyst?

Answer 1

An administrator can manage, create, delete and update a database.

The manager can just update and manage (complete fields). He can't create or delete database.

I am a database administrator. An Administrator takes care of the database--having privileges to do anything to a database. Create objects, delete objects, drop objects. A Database Manager is a supervisor over the Database Administrator. Usually a database manager does not know the specifics of an administrator position--but must have high level knowledge of how a database works.

That is not to be confused with the database manager that is the non-human engine for the database that provides authorization control, makes integrity checks, and commands the processor.

Answer 2

A database administrator is the person who is responsible for keeping a database up to date and running. There responsibilities include: writing and applying scripts to update the database, keeping the database running 24/7, and backing up the database. A database analyst is a person who looks at a database from a higher level. That person would look at the database design and recommend additions for new projects and design the tables and relationships to meet needs. Then the administrator would make the changes in the database.

Answer 3

What it is suppose to be, but sys admins like to cross over to the DBA's responsibilties, is DBA's take care of the database and everything around the database. Where the sysadmin's supply the physical box and OS for the DBA to work on. It has been my experience that SYSAdmin's overstep their responsibilities and try to be the DBA's boss and do his job, especially senior sysadmins.