Completion requirements
Recall the summary report on database administrators that you read earlier in Unit 1 (1.3.4). Pay attention to the tasks, skills, knowledge, and abilities. What is the importance of a DBA? What are some strengths and weaknesses of organizations that do and do not have DBAs?
Tasks
- 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.
- Modify existing databases and database management systems or direct programmers and analysts to make changes.
- Specify users and user access levels for each segment of database.
- Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
- Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.
- Review procedures in database management system manuals to make changes to database.
- Revise company definition of data as defined in data dictionary.
- Train users and answer questions.
- Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
- Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
- Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
- Develop data model describing data elements and how they are used, following procedures and using pen, template, or computer software.
- Select and enter codes to monitor database performance and to create production database.
- Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
- Plan and install upgrades of database management system software to enhance database performance.
- Provide technical support to junior staff or clients.
- Test changes to database applications or systems.