# 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 (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 %**