98 lines
3.4 KiB
Markdown
98 lines
3.4 KiB
Markdown
# Competences — database administrator
|
|
|
|
Source: ESCO v1.2.1 occupation-skill relations (http://data.europa.eu/esco/occupation/8c57af09-719c-42b3-be40-6ed4946236cc).
|
|
|
|
## Essential
|
|
|
|
- **administer ICT system** (skill/competence)
|
|
- **apply company policies** (skill/competence)
|
|
- **balance database resources** (skill/competence)
|
|
- **create data models** (skill/competence)
|
|
- **data models** (knowledge)
|
|
- **data quality assessment** (knowledge)
|
|
- **data storage** (knowledge)
|
|
- **database development tools** (knowledge)
|
|
- **database management systems** (knowledge)
|
|
- **define database physical structure** (skill/competence)
|
|
- **design database backup specifications** (skill/competence)
|
|
- **design database scheme** (skill/competence)
|
|
- **distributed computing** (knowledge)
|
|
- **domain name service** (knowledge)
|
|
- **information structure** (knowledge)
|
|
- **interpret technical texts** (skill/competence)
|
|
- **maintain database performance** (skill/competence)
|
|
- **maintain database security** (skill/competence)
|
|
- **manage database** (skill/competence)
|
|
- **operate relational database management system** (skill/competence)
|
|
- **perform backups** (skill/competence)
|
|
- **perform ICT troubleshooting** (skill/competence)
|
|
- **query languages** (knowledge)
|
|
- **resource description framework query language** (knowledge)
|
|
- **system backup best practice** (knowledge)
|
|
- **use an application-specific interface** (skill/competence)
|
|
- **use databases** (skill/competence)
|
|
- **use scripting programming** (skill/competence)
|
|
|
|
## Optional
|
|
|
|
- business intelligence (knowledge)
|
|
- data engineering (knowledge)
|
|
- DB2 (knowledge)
|
|
- design database in the cloud (skill/competence)
|
|
- estimate duration of work (skill/competence)
|
|
- execute ICT audits (skill/competence)
|
|
- Filemaker (database management systems) (knowledge)
|
|
- IBM Informix (knowledge)
|
|
- implement a firewall (skill/competence)
|
|
- implement anti-virus software (skill/competence)
|
|
- implement ICT security policies (skill/competence)
|
|
- LDAP (knowledge)
|
|
- LINQ (knowledge)
|
|
- manage cloud data and storage (skill/competence)
|
|
- MarkLogic (knowledge)
|
|
- MDX (knowledge)
|
|
- Microsoft Access (knowledge)
|
|
- MySQL (knowledge)
|
|
- N1QL (knowledge)
|
|
- ObjectStore (knowledge)
|
|
- online analytical processing (knowledge)
|
|
- OpenEdge Database (knowledge)
|
|
- Oracle Relational Database (knowledge)
|
|
- PostgreSQL (knowledge)
|
|
- protect personal data and privacy (skill/competence)
|
|
- provide ICT support (skill/competence)
|
|
- provide technical training (skill/competence)
|
|
- quality assurance methodologies (knowledge)
|
|
- remove computer virus or malware from a computer (skill/competence)
|
|
- SPARQL (knowledge)
|
|
- SQL Server (knowledge)
|
|
- support ICT system users (skill/competence)
|
|
- Teradata Database (knowledge)
|
|
- TripleStore (knowledge)
|
|
- use automatic programming (skill/competence)
|
|
- use back-up and recovery tools (skill/competence)
|
|
- use different communication channels (skill/competence)
|
|
- use spreadsheets software (skill/competence)
|
|
- XQuery (knowledge)
|
|
|
|
<!-- market-evidence -->
|
|
|
|
## Market evidence (job-ad analysis, 56 ads, as of 2026-07-10)
|
|
|
|
Share of analyzed job ads mentioning the item (threshold ≥ 20 %). Source: JSearch/Adzuna APIs.
|
|
|
|
### Hard skills
|
|
|
|
- database administration — **66 %**
|
|
- performance tuning — **48 %**
|
|
- data modeling — **39 %**
|
|
- backup and recovery — **29 %**
|
|
- disaster recovery — **29 %**
|
|
- database design — **21 %**
|
|
|
|
### Responsibilities
|
|
|
|
- database administration — **27 %**
|
|
|
|
<!-- market-evidence -->
|