Database administrator
Description
The role of the database administrator (DBA) varies according to the size of the organisation and the organisational reliance on the database. A database administrator is responsible for ensuring that data stored in the database is available when needed and that security of the data and the database is maintained at all times. A database administrator is also responsible for ensuring that the database runs at an optimal speed so that users can access the information quickly.
Generally, a database administrator will have a number of tasks that are common across the role:
- installation and upgrades: install and update the platform the system is running on
- configuration management: understanding how large the database will become over time; ensuring that the database is placed on the correct server so that it is available to the correct people and ensuring that the correct type of storage is used for the information collected through the database
- security and compliance: understanding the security options for information held on the database
- monitoring and tuning: ensuring that the database is running to optimal levels and understanding the table structure within the database in order to 'tune' the database
- backup and recovery: understanding the options for backing up and recovering data held within the database. There will be local policy and procedures for each of these processes
- trouble shooting: investigate an issue and work to find the root cause of why there is a problem with the system. They must also be able to implement a solution to address the issues.
A database administrator exhibits a combination of capabilities from the Skills Framework for the Information Age (SFIA) and the Leadership competencies for Queensland.
SFIA profile
Within the SFIA profile, the database administrator has level 4 and 5 capabilities, i.e. enable, ensures and advises on the skills outlined below.
Refer to the framework for descriptions of the seven levels of responsibility and accountability.
 SFIA skill | SFIA skill code | SFIA skill level of responsibility | SFIA skill code descriptor |
|---|---|---|---|
| Database administration | DBAD | 5 | Provides technical leadership to optimise the performance of databases. Drives the adoption of tools and automated processes for effective database management and delivery. Oversees the planning, installation, maintenance and acceptance of new and updated database components and database-based services. Ensures alignment to service expectations, security requirements and other quality standards. Ensures database operational procedures and documentation are current and effective, tracks and addresses operational issues and reports to stakeholders. |
| Database design | DBDS | 5 | Provides specialist expertise in the design characteristics of database management systems or data warehouse products/services. Provides expert guidance in the selection, provision and use of database and data warehouse architectures, software and facilities. Ensures design policies optimise transactional data systems for performance and availability while meeting the needs of business intelligence and analytics platforms. |
| Information security | SCTY | 4 | Provides guidance on the application and operation of elementary physical, procedural and technical security controls. Explains the purpose of security controls and performs security risk and business impact analysis for medium complexity information systems. Identifies risks that arise from potential technical solution architectures. Designs alternate solutions or countermeasures and ensures they manage identified risks. Investigates suspected attacks and supports security incident management. |
| Security operations | SCAD | 4 | Maintains and optimises operational security processes. Checks that all requests for support are dealt with according to established protocols, including for cloud-based and automated systems. Provides advice on implementing and managing physical, procedural and technical security encompassing both physical and digital assets. Investigates security breaches in accordance with established procedures using advanced tools and techniques and recommends necessary corrective actions. Enables effective implementation of recommended security measures and monitors their performance. |
Leadership skills
Leadership competencies for Queensland describes what highly effective, everyday leadership looks like in the sector. In simple, action-oriented language, it provides a common understanding of the foundations for success across all roles. The profile describes three performance dimensions (vision, results and accountability) and 11 leadership competencies required against five leadership streams.
Leadership streams are not connected to a level or classification, but rather reflect the balance between leadership and technical skills required of an individual. Individuals can consider the value proposition of roles rather than the traditional lens of hierarchical structures or classification levels. The five leadership streams are:
- Individual contributor (Leads self and does not supervise others)
- Team leader (leads a team and typically reports to a program leader)
- Program leader (leads team leaders and/or multiple areas of work)
- Executive (leads program leaders or other executives)
- Chief executive (leads the organisation).
When developing a role description, identify the role type and then focus on the most important attributes and create a balance between SFIA skills and leadership skills.
Entry points
Most staff who work as a database administrator possess a degree in areas such as information technology or corporate systems management.
Industry experience or a diploma level qualification are also held in high regard and may be of some assistance in gaining entry to a career as a database administrator. Diploma level qualifications can generally be obtained through participation in a TAFE course.
Learning and development
Development or improvement of skills as a database administrator can occur in a number of ways.
Courses to increase general knowledge and skill in database administration are readily available through organisations such as TAFE or universities. Private companies offer courses that increase skill in specific database product. These courses are generally offered by the companies who market or sell a particular database.