Description

Database Administrator ANZSCO 262111 plans, develops, configures, maintains and supports an organization’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 organization’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.

Skill level: 1

Alternative Titles

• Database Operator
• Database Specialist
• Database Support
• DBA

Specializations

• Database Analyst

Skills Assessment Authority

• ACS (Australian Computer Society)

Occupation Lists

This occupation is on the following skill lists:

• Combined Skilled Occupations List (STSOL MLTSSL)
• RSMS Occupations List (RSMSL)
• Short-Term Skilled Occupation List (STSOL)

This occupation is not on the following skill lists:

• Labor Market Testing Required for 457 List (LMTL)
• Medium Long Term Strategic Skills List (MLTSSL)

Visa Provision

As the occupation features on the Short-term Skilled Occupation List (STSOL), it is possible to apply for a Skilled Nominated 190 visa or a Skilled Regional Nominated 489 visa. If you are employed in this occupation and you wish to pursue a GSM visa, you will be required to apply for state nomination in order to move to Australia.

Note: *While the occupation is on the STSOL it remains a possibility that no states currently have a demand for people in that profession. The online assessment only lists occupations which are currently in demand by a state or territory in Australia, so if the occupation does not appear on the online assessment you should consider seeking an employer sponsor in Australia.

Unit Group: 2621 Database and Systems Administrators, and ICT Security Specialist

Description

The job of a database administrator in Australia is to plan, develop, maintain, manage and administer organizations database management systems, operating systems and security policies and procedures to ensure optimal database and system integrity, security, backup, reliability and performance.

Tasks

• 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

Skill Level

Most occupations in the unit group (Group 2621) 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).

Occupations in this Group

• 262111 Database Administrator
• 262112 ICT Security Specialist
• 262113 Systems Administrator

Note: Whilst a similar occupation may appear in the database administrator group if not specifically listed in the STSOL or MLTSSL the ANZSCO description should be used for reference purposes only.

English Requirement

• IELTS result with a minimum score of 6 (L, R, W), 7 in speaking and 7 overall;
• OET result with a minimum grade B in all sections;
• TOEFL iBT with a minimum score (L:12 R:13 W:21 S:23 overall L93);
• PTE Academic with a minimum score of 50 (L, R, W), 65 in speaking and 65 overall

Exceptions

• Australian Graduate Exceptions apply in some states/territories
• Priority Skilled Lists may apply a specific requirement in some states/territories
• Countries exempt from submitting IELTS or OET include the UK; Canada; New Zealand; US; and Ireland
• Where mandatory licensing or registration is required you must demonstrate a level of English either sufficient to meet licensing / registration or a minimum IELTS, or equivalent, whichever is higher.

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)

Brief Description

The database administrator manages and maintain the database systems. The ICT units helps in the analysis of data objects and their relationships to other data objects. The database administrator create a conceptual model of how data items relate to each other. The tasks that they conduct are database security, database monitoring and troubleshooting, and planning for future growth. They also recommend optimizations of existing databases and design physical database. They develop the appropriate documentation for all tests procedures for databases and also prepare procedures for backup process for various operating systems.

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

Brief Description

The database administrator monitor system performance and identify problems that arise. They have to respond in a timely manner to user-reported errors. They ensure work according to user privileges and monitor database and application levels. Their main goal is to protect the database against threats or unauthorized access. So, they secure the database and back up file for any problem that arises in future. They also gives suggestion, changes and improvements for maintenance or protection.