262111 DATABASE ADMINISTRATOR
Plans, develops, configures, maintains and supports an organisation's database management system in accordance with user requirements ensuring optimal database integrity, security, backup, reliability and performance.
Skill Level: 1
2621 DATABASE AND SYSTEMS ADMINISTRATORS, AND ICT SECURITY SPECIALISTS
DATABASE AND SYSTEMS ADMINISTRATORS, AND ICT SECURITY SPECIALISTS plan, develop, maintain, manage and administer organisations' database management systems, operating systems and security policies and procedures to ensure optimal database and system integrity, security, backup, reliability and performance.
Indicative Skill Level:
In Australia and New Zealand:
Most occupations in this unit group have a level of skill commensurate with a bachelor degree or higher qualification. At least five years of relevant experience and/or relevant vendor certification may substitute for the formal qualification. In some instances relevant experience and/or on-the-job training may be required in addition to the formal qualification (ANZSCO Skill Level 1).
designing and maintaining database architecture, data structures, tables, dictionaries and naming conventions to ensure the accuracy and completeness of all data master files
performing the operational establishment and preventive maintenance of backups, recovery procedures, and enforcing security and integrity controls
implementing and administering database documentation, guidelines, policies and procedures
testing database systems and upgrades, such as debugging, tracking, reproduction, logging and resolving all identified problems, according to approved quality testing scripts, procedures and processes
accepting responsibility for the processes, procedures and operational management associated with system security and disaster recovery planning
liaising with security vendors, suppliers, service providers and external resources; analysing, recommending, installing and maintaining software security applications; and monitoring contractual obligations, performance delivery and service level agreements
troubleshooting and providing service support in diagnosing, resolving and repairing server-related hardware and software malfunctions, encompassing workstations and communication infrastructure
preparing and maintaining documentation, policies and instructions, and recording and detailing operational procedures and system logs
ensuring that the design of computer sites allows all components to fit together and work properly, and monitoring and adjusting the performance of networks
continually surveying the current computer site to determine future network needs and making recommendations for enhancements in the implementation of future servers and networks