ANZSCO 262111 – Database Administrator

database administrator
 

ANZSCO 262111 – Database Administrator

Description

Database Administrator 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.(Read More)

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

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

Plans, maintains and supports, develops, configures, an organization’s database management system in accordance with user requirements ensuring the single data have single value, providing the security, backup, reliability and performance of the system. Data modeling (data modelling) is the analysis of data and their relationships to other data objects.

Data modeling is often the first step in design and as the designers first create a conceptual model of how data items relate to each other. Structure of the data storage format that enables in an organization, management, and access and modification and reuse of those data and values. it refers as an activities performed by a database administrator to ensure that a database is always available as needed. Various languages are used for to compile and find the errors.

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

Database administrator serves as a relation between client and server technology. It also can be called as a client path method. It should follow the policy method and the security methods for security. To save the file and for any other who are just needed for read only purpose. Collaboration with the database administrator and project manager it helps to build a valuable result for the project. Like the database administrator the major goal includes as closing the work of a team to achieve specific goals and meet specific success criteria at the specified time.