Unit of competency Outline

Date retreived
22/07/2026 10:26 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 a database

Monitor and administer a database

Unit of competency
National Code
ICTDBS409
State Code
AUT47
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
25/03/2015
View on TGA
State Implementation and Classification
Approved Date
16/09/2015
Field of Education
020303 - Database Management
Original Release Date
16/09/2015
Nominal Hours
25
Description
This unit describes the skills and knowledge required to manage databases including start up, operation, testing, monitoring and maintenance, in accordance with organisational requirements.It applies to individuals employed as database support staff who are required to maintain a database, monitor its performance and access, as well as to administer its security.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Start up a database
  • 1.1 Configure the system for a database start-up
  • 1.2 Monitor the database start-up and operation for irregularities
2. Manage the database
  • 2.1 Take action to ensure that a data dictionary has been compiled and that data structures are in place
  • 2.2 Maintain data integrity constraints, according to business requirements
  • 2.3 Create and design indexes, and multiple-field keys, according to business requirements
  • 2.4 Monitor the locking options chosen for the database
  • 2.5 Confirm that recent backups of the database have been stored, and that backups can be retrieved as a full working copy
  • 2.6 Monitor data storage space for ongoing viability, and resize as needed
  • 2.7 Update the data according to organisational guidelines
3. Manage database access
  • 3.1 Allocate or remove access privileges according to user status
  • 3.2 Monitor network server log-in log file for illegal log-in attempts, or for security breaches
  • 3.3 Manage system resources in the context of database administration
4. Document database maintenance tasks
  • 4.1 Document changes to database start-up procedures
  • 4.2 Itemise database management structures
  • 4.3 File authorisations for access changes
  • 4.4 Detail the procedures for monitoring log files
  • 4.5 Record the procedures to manage systems resources
No information
No information
Replaces
State Code National Code Title Type
D7773 ICADBS409A Monitor and administer a database Unit of competency
Replaced By
State Code National Code Title Type
OBU90 ICTDBS418 Monitor and administer databases Unit of competency