2712 Database and Systems Administrators
2712 Database and Systems Administrators
Design, develop, install and maintain operating systems, software and server hardware to support secure and reliable database management systems.
OSCA skill level
The occupations in this unit group have a skill level corresponding to the qualifications and experience below.
- Skill Level 1: Bachelor Degree, higher qualification, or at least five years of relevant experience
271231 Database Administrator
Plans, designs, 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 developers are excluded from this occupation. Database developers are included in Occupation 273333 Software Engineer.
Alternative titles
- DBA
- ICT Database Manager
Specialisation
- ICT Database Analyst
Skill level: 1
Main tasks
- Designs and implements database structures to optimise system performance and data storage efficiency
- Monitors and optimises database performance using various techniques such as indexing and fine-tuning queries
- Implements and maintains security protocols to protect databases from unauthorised access or breaches
- Performs regular data backups and recovery tasks to ensure data integrity and availability
- Coordinates database updates and migrations, including database software installation, configuration and patch management
- Develops disaster recovery plans to protect data from any potential loss or corruption
271232 Systems Administrator
Plans, develops, installs, troubleshoots, maintains and supports an operating system and associated server hardware, software and databases, ensuring optimum system integrity, security, backup and performance.
Alternative title
- ICT Systems Manager
Skill level: 1
Main tasks
- Installs, configures and maintains server hardware, software, operating systems and databases infrastructure
- Diagnoses and resolves hardware, software and network connectivity issues to ensure uninterrupted system operation
- Conducts regular system backups and recovery procedures, ensuring data safety and integrity
- Facilitates IT infrastructure changes through change management processes, in accordance with organisational protocols
- Provides system related technical support and guidance to end users
- Manages user accounts, permissions and security policies to ensure data security and compliance with regulations