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.
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
- Database Operator
- Database Specialist
- Database Support
- Database Analyst
Source: 1220.0 - ANZSCO - Australian and New Zealand Standard Classification of Occupations, First Edition.
Note: The tasks associated with the occupation are to be used as guidance only. The tasks listing may include tasks associated with the grouping/category to which the occupation belongs.
One course found.
|ICT50515: Diploma of Database Design and Development|