Database Administrator: Tasks | Saylor Academy | Saylor Academy

Home Specialization Programs Help

Read this summary report for DBAs. Familiarize yourself with the knowledge, skills, abilities, and education level organizations look for when seeking to hire database administrators.

Remember, proper data management and data lifecycle management add value to any organization. It is becoming easier to share and manage data due to advancements in technology. Therefore, it is important to have data management and data lifecycle management processes. This produces integrity in standards that effectively collect, analyze, and share data.

Details

Tasks

Importance	Category	Task
84	Core	Test programs or databases, correct errors, and make necessary modifications.
83	Core	Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
74	Core	Modify existing databases and database management systems or direct programmers and analysts to make changes.
74	Core	Specify users and user access levels for each segment of database.
69	Core	Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.
66	Core	Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.
62	Core	Review procedures in database management system manuals to make changes to database.
61	Core	Revise company definition of data as defined in data dictionary.
60	Core	Train users and answer questions.
59	Core	Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
55	Core	Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
54	Core	Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
51	Core	Develop data model describing data elements and how they are used, following procedures and using pen, template, or computer software.
71	Supplemental	Select and enter codes to monitor database performance and to create production database.
Not available	Not available	Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.
Not available	Not available	Plan and install upgrades of database management system software to enhance database performance.
Not available	Not available	Provide technical support to junior staff or clients.
Not available	Not available	Test changes to database applications or systems.