ACS RPL for Database Administrator 262111

ANZSCO 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. Database administrators design, implement, maintain and repair an organisation's database. The role includes developing and designing the database strategy, monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.

Description of Employment Duties:

  • 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; analyzing, 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

Description of Closely Related Core ICT Units:

  • Data modeling
  • Data structures
  • Database administration
  • Database design
  • Database implementation
  • Database languages - (e.g. SQL)
  • Database Management Systems - (Relational Database, Object Oriented Database, RDBMS)
  • Entity relationship modeling
  • Operating systems - (Unix, Linux, Xenix, Network OS)

Description of Additional Closely Related ICT Units:

  • Client Server Technology
  • Critical Path Method
  • Data policy
  • Data security
  • Distributed Systems
  • File Processing
  • Introduction to ICT - (Introduction to Computer Science, Computer Theory, Introduction to Business Computing, Computer Science I)
  • Project Management
  • Quality management - (Quality Assurance, Software Quality)
  • Testing strategies and methods