What does a Database Administrator do?
Administer, test, and implement computer databases, applying knowledge of database management systems. Coordinate changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases.
- Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Test programs or databases, correct errors, and make necessary modifications.
- Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
- Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
- Train users and answer questions.
- Establish and calculate optimum values for database parameters, using manuals and calculator.
- Specify users and user access levels for each segment of database.
- Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
- Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
- Review project requests describing database user needs to estimate time and cost required to accomplish project.
- Review procedures in database management system manuals for making changes to database.
- Work as part of a project team to coordinate database development and determine project scope and limitations.
- Select and enter codes to monitor database performance and to create production database.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
- Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
- Revise company definition of data as defined in data dictionary.