Infocomm TechnologyISCO 2521
Database designer
Database designers specify the database's logical structure, processes, and information flows. They design data models and databases to serve data acquisition.
Check yourself in a minute: database designer
Rate 5 of the 26 essential skills of this occupation (European ESCO data). No account needed.
migrate existing data
use markup languages
develop automated migration methods
assess ICT knowledge
manage database
Do You Have the Skills for This Role?
Core competency requirements inferred from the occupation's skill profile. Take the free assessment to see how you match.
Must-Have Skills (Advanced)
Developing PeopleAdvanced
CommunicationAdvanced
Transdisciplinary ThinkingAdvanced
Key skills in this occupation
Essential skills and knowledge areas from the European ESCO classification, 26 in total. The ones most specific to this occupation come first.
- migrate existing data
Apply migration and conversion methods for existing data, in order to transfer or convert data between formats, storage or computer systems.
practical skill - use markup languages
Utilise computer languages that are syntactically distinguishable from the text, to add annotations to a document, specify layout and process types of documents such as HTML.
practical skill - develop automated migration methods
Create automated transfer of ICT information between storage types, formats and systems to save human resources from performing the task manually.
practical skill - assess ICT knowledge
Evaluate the implicit mastery of skilled experts in an ICT system to make it explicit for further analysis and usage.
practical skill - manage database
Apply database design schemes and models, define data dependencies, use query languages and database management systems (DBMS) to develop and manage databases.
practical skill - perform data analysis
Collect data and statistics to test and evaluate in order to generate assertions and pattern predictions, with the aim of discovering useful information in a decision-making process.
practical skill - create software design
Transpose a series of requirements into a clear and organised software design.
practical skill - design database scheme
Draft a database scheme by following the Relational Database Management System (RDBMS) rules in order to create a logically arranged group of objects such as tables, columns and processes.
practical skill
Check which of these skills you already have ↑
Knowledge (10)
information structure
The type of infrastructure which defines the format of data: semi-structured, unstructured and structured. More →
systems development life-cycle
The sequence of steps, such as planning, creating, testing and deploying and the models for the development and life-cycle management of a system. More →
database
The classification of databases, that includes their purpose, characteristics, terminology, models and use such as XML databases, document-oriented databases and full text databases. More →
web programming
The programming paradigm that is based on combining markup (which adds context and structure to text) and other web programming code, such as AJAX, javascript and PHP, in order to carry out appropriate actions and… More →
ICT security legislation
The set of legislative rules that safeguards information technology, ICT networks and computer systems and legal consequences which result from their misuse. More →
business process modelling
The tools, methods and notations such as Business Process Model and Notation (BPMN) and Business Process Execution Language (BPEL), used to describe and analyse the characteristics of a business process and model its… More →
resource description framework query language
The query languages such as SPARQL which are used to retrieve and manipulate data stored in Resource Description Framework format (RDF). More →
database development tools
The methodologies and tools used for creating logical and physical structure of databases, such as logical data structures, diagrams, modelling methodologies and entity-relationships. More →
database management systems
The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server. More →
systems theory
The principles that can be applied to all types of systems at all hierarchical levels, which describe the system's internal organisation, its mechanisms of maintaining identity and stability and achieving adaptation and… More →
Practical skills (8)
operate relational database management system
Extract, store and verify information using database management systems based on the relational database model, which arranges data into tables of rows and columns, such as Oracle Database, Microsoft SQL Server and… More →
create database diagrams
Develop the database design models and diagrams which establish the structure of a database by using modelling software tools to be implemented in further processes. More →
create data sets
Generate a collection of new or existing related data sets that are made up out of separate elements but can be manipulated as one unit. More →
analyse business requirements
Study clients' needs and expectations for a product or service in order to identify and resolve inconsistencies and possible disagreements of involved stakeholders. More →
manage standards for data exchange
Set and maintain standards for transforming data from source schemas into the necessary data structure of a result schema. More →
apply ICT systems theory
Implement principles of ICT systems theory in order to explain and document system characteristics that can be applied universally to other systems. More →
define technical requirements
Specify technical properties of goods, materials, methods, processes, services, systems, software and functionalities by identifying and responding to the particular needs that are to be satisfied according to customer… More →
write database documentation
Develop documentation containing information about the database that is relevant to end users. More →
Optional skills (75) — show
Haskell
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Haskell. More →
Erlang
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Erlang. More →
SAS language
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in SAS language. More →
Agile project management
The agile project management approach is a methodology for planning, managing and overseeing of ICT resources in order to meet specific goals and using project management ICT tools. More →
Ruby (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Ruby. More →
Common Lisp
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Common Lisp. More →
Lisp
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Lisp. More →
Visual Basic
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Visual Basic. More →
Java (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Java. More →
computer programming
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms (e.g. object oriented programming, functional programming) and of programming… More →
Prolog (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Prolog. More →
OpenEdge Advanced Business Language
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in OpenEdge Advanced Business Language. More →
JavaScript
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in JavaScript. More →
DB2
The computer program IBM DB2 is a tool for creating, updating and managing databases, developed by the software company IBM. More →
Microsoft Access
The computer program Access is a tool for creating, updating and managing databases, developed by the software company Microsoft. More →
XQuery
The computer language XQuery is a query language for retrieval of information from a database and of documents containing the needed information. More →
Perl
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Perl. More →
Smalltalk (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Smalltalk. More →
PHP
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in PHP. More →
OpenEdge Database
The computer program OpenEdge Database is a tool for creating, updating and managing databases, developed by the software company Progress Software Corporation. More →
Assembly (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Assembly. More →
data engineering
The process of developing and constructing systems for implementing data collection and analysis at large scale. More →
ObjectStore
The computer program ObjectStore is a tool for creating, updating and managing databases, developed by the software company Object Design, Incorporated. More →
C#
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in C#. More →
MySQL
The computer program MySQL is a tool for creating, updating and managing databases, currently developed by the software company Oracle. More →
TripleStore
The RDF store or TripleStore is a database used for storage and retrieval of Resource Description Framework triples (subject-predicate-object data entities) which can be accessed by semantic queries. More →
R
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in R. More →
Groovy
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Groovy. More →
ASP.NET
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ASP.NET. More →
APL
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in APL. More →
SPARQL
The computer language SPARQL is a query language for retrieval of information from a database and of documents containing the needed information. More →
Oracle WebLogic
The application server Oracle WebLogic is Java EE based application server which serves as a middle tier that links the back-end databases to the related applications. More →
Microsoft Visual C++
The computer program Visual C++ is a suite of software development tools for writing programs, such as compiler, debugger, code editor, code highlights, packaged in a unified user interface. More →
IBM Informix
The computer program IBM Informix is a tool for creating, updating and managing databases, developed by the software company IBM. More →
TypeScript
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in TypeScript. More →
CoffeeScript
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in CoffeeScript. More →
Objective-C
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Objective-C. More →
ML (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ML. More →
LDAP
The computer language LDAP is a query language for retrieval of information from a database and of documents containing the needed information. More →
PostgreSQL
The computer program PostgreSQL is a free and open-source software tool for creating, updating and managing databases, developed by the PostgreSQL Global Development Group. More →
AJAX
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in AJAX. More →
C++
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in C++. More →
Filemaker (database management systems)
The computer program FileMaker is a tool for creating, updating and managing databases, developed by the software company FileMaker Inc. More →
SAP R3
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in SAP R3. More →
Swift (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Swift. More →
ICT project management methodologies
The methodologies or models for planning, managing and overseeing of ICT resources in order to meet specific goals, such methodologies are Waterfall, Incremental, V-Model, Scrum or Agile and using project management ICT… More →
SQL Server
The computer program SQL Server is a tool for creating, updating and managing databases, developed by the software company Microsoft. More →
MATLAB
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in MATLAB. More →
unstructured data
The information that is not arranged in a pre-defined manner or does not have a pre-defined data model and is difficult to understand and find patterns in without using techniques such as data mining. More →
CA Datacom/DB
The computer program CA Datacom/DB is a tool for creating, updating and managing databases, currently developed by the software company CA Technologies. More →
LINQ
The computer language LINQ is a query language for retrieval of information from a database and of documents containing the needed information. More →
Python (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Python. More →
Scratch (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Scratch. More →
Process-based management
The process-based management approach is a methodology for planning, managing and overseeing of ICT resources in order to meet specific goals and using project management ICT tools. More →
Teradata Database
The computer program Teradata Database is a tool for creating, updating and managing databases, developed by the software company Teradata Corporation. More →
lean project management
The lean project management approach is a methodology for planning, managing and overseeing of ICT resources in order to meet specific goals and using project management ICT tools. More →
VBScript
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in VBScript. More →
Oracle Relational Database
The computer program Oracle Rdb is a tool for creating, updating and managing databases, developed by the software company Oracle. More →
COBOL
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in COBOL. More →
MarkLogic
The NoSQL enterprise non-relational database used for creating, updating and managing large amounts of unstructured data stored in the cloud and which provides features such as semantics, flexible data models and Hadoop… More →
Pascal (computer programming)
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Pascal. More →
ABAP
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ABAP. More →
data science
The field of study that deals with big amount of data using AI techniques such as machine learning algorithms to predict patterns and obtain useful information to make business decisions. More →
N1QL
The computer language N1QL is a query language for retrieval of information from a database and of documents containing the needed information. More →
data models
The techniques and existing systems used for structuring data elements and showing relationships between them, as well as methods for interpreting the data structures and relationships. More →
Scala
The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Scala. More →
define database physical structure
Specify the physical configuration of database files on a given media. More →
use databases
Use software tools for managing and organising data in a structured environment which consists of attributes, tables and relationships in order to query and modify the stored data. More →
use access control software
Utilise software to define the roles and manage user authentication, privileges and access rights to ICT systems, data and services. More →
design database in the cloud
Apply design principles for an adaptive, elastic, automated, loosely coupled databases making use of cloud infrastructure. More →
design database backup specifications
Specify procedures to be performed on databases which ensure the copying and archiving of data for possible restoration in case of a data loss event. More →
apply technical communication skills
Explain technical details to non-technical customers, stakeholders, or any other interested parties in a clear and concise manner. More →
manage cloud data and storage
Create and manage cloud data retention. More →
build business relationships
Establish a positive, long-term relationship between organisations and interested third parties such as suppliers, distributors, shareholders and other stakeholders in order to inform them of the organisation and its… More →
perform resource planning
Estimate the expected input in terms of time, human and financial resources necessary to achieve the project objectives. More →
Related Occupations
Occupations that need many of the same essential skills, so the move between them is shortest.
data warehouse designer24 shared essential skillsknowledge engineer13 shared essential skillsICT system architect11 shared essential skillsartificial intelligence engineer8 shared essential skillsdatabase administrator7 shared essential skillsbig data archive librarian6 shared essential skillsdata quality specialist6 shared essential skillsdigital games designer6 shared essential skills
Frequently asked questions
What does a database designer do?
Database designers specify the database's logical structure, processes, and information flows. They design data models and databases to serve data acquisition.
What skills does a database designer need?
A database designer needs 26 essential skills, including information structure, systems development life-cycle, database, web programming, ICT security legislation.
Will AI replace database designer jobs?
The AI disruption score for database designer is 54/100 (moderate risk). Skills most exposed to automation: create data sets, LDAP, write database documentation. Most resilient: build business relationships, systems theory, apply ICT systems theory.
AI Replacement Risk
54/ 100
Moderate Risk
Low riskHigh risk
Quick Facts
SectorInfocomm Technology
ISCO GroupInformation and communications technology professionals
Essential Skills26
Core Skills3
Is database designer right for you?
Take the free 10-minute Career Portrait to see which career direction fits your motivations and strengths.
Take the free test