Unit of competency Outline

Date retreived
22/07/2026 7:22 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Monitor and administer databases

Monitor and administer databases

Unit of competency
National Code
ICTDBS418
State Code
OBU90
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
21/07/2020
View on TGA
State Implementation and Classification
Approved Date
15/01/2021
Field of Education
020303 - Database Management
Original Release Date
15/01/2021
Nominal Hours
25
Description
This unit describes the skills and knowledge required to monitor and manage databases including selecting the required database according to organisational requirements. It involves the operation, testing, monitoring and maintenance of a database, in accordance with organisational requirements.It applies to individuals employed as database support staff who are required to maintain a database, monitor its performance as well as access and administer its security and varying levels of access to users.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Select and start database
  • 1.1 Identify and select database according to organisational requirements
  • 1.2 Configure database system start-up according to organisational requirements and required vendor guidelines
  • 1.3 Monitor database start-up and operation and check for irregularities according to task requirements
2. Administer database
  • 2.1 Create and document data dictionary and implement data structures according to task requirements
  • 2.2 Maintain data integrity constraints according to organisational requirements
  • 2.3 Create and design indexes, locking options and multiple-field keys according to organisational requirements
  • 2.4 Confirm database backups have been stored and can be accessed by required personnel
  • 2.5 Monitor and update ongoing viability of data storage and resize according to organisational requirements
3. Manage database access
  • 3.1 Allocate and remove access privileges according to user status and organisational requirements
  • 3.2 Monitor network server log-in log file and prevent illegal log-in attempts and security breaches according to organisational policies and procedures
  • 3.3 Manage system and database administration resources according to task requirements
4. Record and store database maintenance tasks
  • 4.1 Document changes to database processes and start-up procedures according to organisational requirements
  • 4.2 Itemise database management structures and file access authorisations
  • 4.3 Detail required log file monitoring procedures
  • 4.4 Record the procedures to manage systems resources
  • 4.5 Save, back-up and close documentation and database resources
No information
No information
Replaces
State Code National Code Title Type
AUT47 ICTDBS409 Monitor and administer a database Unit of competency