ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Plan database backup and restore

1.1 Examine architecture of database file systems and determine likely risk and failure scenarios

1.2 Determine methods for database backup and restore to mitigate likely risk and failure scenarios

1.3 Prepare backup maintenance schedules according to organisational backup and restore policy

1.4 Prepare contingency plans according to organisational backup and restore policy

2. Undertake backup methods appropriate to database requirements

2.1 Complete full off-line backups with acceptable downtime according to organisational backup and restore policy and procedure

2.2 Complete online file backups with acceptable downtime according to organisational backup and restore policy and procedure and organisational data security plan

2.3 Deploy redundant array of inexpensive disks (RAID) configuration aligned with the organisational backup and restore policy

2.4 Arrange off-site copies of backup files consistent with organisational back and restore procedure and organisational data protection plan

3. Establish and test recovery points and disaster-recovery procedures

3.1 Determine and document database recovery points based on backup methods, according to organisational backup and restore policy and procedure

3.2 Test restore process to ensure database can be restored to given recovery points with acceptable down time as specified in organisational backup and restore policy

3.3 Complete and document restoration of databases to point of failure, without loss of committed transactions

4. Create and deploy a standby database

4.1 Create and deploy standby databases to support critical organisational functions according to organisational back and restore policy and procedure

4.2 Prepare documentation for standby databases that meet requirements of organisational backup and restore policy

Skill

Description

Reading

Analyses complex textual information in order to evaluate a range of backup and restoration methods

Numeracy

Interprets mathematical information in order to construct date and time based schedules

Extracts and calculates numerical information from textual and numerical information to determine and confirm requirements

Writing

Uses technically specific language in developing plans, schedules and documentation

Articulates information, and presents this information, in a clear, concise, sequential and grammatically-correct manner, and in a writing style that is appropriate to the audience

Oral Communication

Facilitates successful discussions by employing effective listening, questioning and summarising skills to ensure that appropriate information is gathered

Navigate the world of work

Recognises and follows, both explicit and implicit protocols, and meets expectations associated with own role when complying with organisational and security standards, and guidelines

Get the work done

Takes responsibility for planning, sequencing and prioritising tasks, and own workload for efficiency, and for effective outcomes

Makes routine decisions, and implements standard procedures, for routine tasks, using formal decision-making processes for more complex and non-routine situations

Addresses less predictable problems and initiates standard procedures in response to these, applying problem-solving processes in determining a solution

Uses familiar digital technologies and systems to access information, search and enter data, and code, present information and communicate with others, cognisant of data security and safety