database-designer/references/skills.md

Competences — database designer

Source: ESCO v1.2.1 occupation-skill relations (http://data.europa.eu/esco/occupation/8d9ec84d-cf2d-4179-87bc-335cda54a427).

Essential

• analyse business requirements (skill/competence)
• apply ICT systems theory (skill/competence)
• assess ICT knowledge (skill/competence)
• business process modelling (knowledge)
• create data sets (skill/competence)
• create database diagrams (skill/competence)
• create software design (skill/competence)
• database (knowledge)
• database development tools (knowledge)
• database management systems (knowledge)
• define technical requirements (skill/competence)
• design database scheme (skill/competence)
• develop automated migration methods (skill/competence)
• ICT security legislation (knowledge)
• information structure (knowledge)
• manage database (skill/competence)
• manage standards for data exchange (skill/competence)
• migrate existing data (skill/competence)
• operate relational database management system (skill/competence)
• perform data analysis (skill/competence)
• query languages (knowledge)
• resource description framework query language (knowledge)
• systems development life-cycle (knowledge)
• systems theory (knowledge)
• use markup languages (skill/competence)
• web programming (knowledge)
• write database documentation (skill/competence)

Optional

• ABAP (knowledge)
• Agile project management (knowledge)
• AJAX (knowledge)
• APL (knowledge)
• apply technical communication skills (skill/competence)
• ASP.NET (knowledge)
• Assembly (computer programming) (knowledge)
• build business relationships (skill/competence)
• C# (knowledge)
• C++ (knowledge)
• CA Datacom/DB (knowledge)
• COBOL (knowledge)
• CoffeeScript (knowledge)
• Common Lisp (knowledge)
• computer programming (knowledge)
• data engineering (knowledge)
• data models (knowledge)
• data science (knowledge)
• DB2 (knowledge)
• define database physical structure (skill/competence)
• design database backup specifications (skill/competence)
• design database in the cloud (skill/competence)
• Erlang (knowledge)
• Filemaker (database management systems) (knowledge)
• Groovy (knowledge)
• Haskell (knowledge)
• IBM Informix (knowledge)
• ICT project management methodologies (knowledge)
• Java (computer programming) (knowledge)
• JavaScript (knowledge)
• LDAP (knowledge)
• lean project management (knowledge)
• LINQ (knowledge)
• Lisp (knowledge)
• manage cloud data and storage (skill/competence)
• MarkLogic (knowledge)
• MATLAB (knowledge)
• MDX (knowledge)
• Microsoft Access (knowledge)
• Microsoft Visual C++ (knowledge)
• ML (computer programming) (knowledge)
• MySQL (knowledge)
• N1QL (knowledge)
• Objective-C (knowledge)
• ObjectStore (knowledge)
• OpenEdge Advanced Business Language (knowledge)
• OpenEdge Database (knowledge)
• Oracle Relational Database (knowledge)
• Oracle WebLogic (knowledge)
• Pascal (computer programming) (knowledge)
• perform resource planning (skill/competence)
• Perl (knowledge)
• PHP (knowledge)
• PostgreSQL (knowledge)
• Process-based management (knowledge)
• Prolog (computer programming) (knowledge)
• Python (computer programming) (knowledge)
• R (knowledge)
• Ruby (computer programming) (knowledge)
• SAP R3 (knowledge)
• SAS language (knowledge)
• Scala (knowledge)
• Scratch (computer programming) (knowledge)
• Smalltalk (computer programming) (knowledge)
• SPARQL (knowledge)
• SQL Server (knowledge)
• Swift (computer programming) (knowledge)
• Teradata Database (knowledge)
• TripleStore (knowledge)
• TypeScript (knowledge)
• unstructured data (knowledge)
• use access control software (skill/competence)
• use databases (skill/competence)
• VBScript (knowledge)
• Visual Basic (knowledge)
• XQuery (knowledge)

Market evidence (job-ad analysis, 5 ads, as of 2026-07-11)

Share of analyzed job ads mentioning the item (threshold ≥ 20 %). Source: JSearch/Adzuna APIs.

Hard skills

• data modeling — 60 %
• database design — 60 %
• database management — 20 %
• database performance optimization — 20 %
• database schema design — 20 %
• database security — 20 %
• geospatial data management — 20 %
• project management — 20 %
• records retention — 20 %
• requirements analysis — 20 %
• resource allocation — 20 %
• data organization — 20 %
• data architecture — 20 %
• data integrity management — 20 %
• data management strategy — 20 %
• audit implementation — 20 %
• backup system administration — 20 %
• security measures planning — 20 %
• sql development — 20 %
• sql querying — 20 %
• stored procedure development — 20 %
• system design — 20 %
• technical expertise — 20 %
• system performance optimization — 20 %

Responsibilities

• performance optimization — 40 %
• policy establishment — 20 %
• solution security — 20 %
• system performance ensuring — 20 %
• task automation — 20 %
• backup and recovery implementation — 20 %
• technical requirement understanding — 20 %
• technical support provision — 20 %
• technology selection — 20 %
• user requirement identification — 20 %
• version history implementation — 20 %
• backup system management — 20 %
• blueprint creation — 20 %
• business requirement understanding — 20 %
• computer database setup — 20 %
• cross-functional collaboration — 20 %
• customer partnership — 20 %
• analytics support — 20 %
• application support — 20 %
• data integrity control — 20 %
• data integrity maintenance — 20 %
• data security implementation — 20 %
• data storage determination — 20 %
• data system design — 20 %
• database configuration — 20 %
• schema maintenance — 20 %
• security measure planning — 20 %
• modification coordination — 20 %
• database security implementation — 20 %
• dataset development — 20 %