Infocomm TechnologyInformation and communications technology professionalsISCO 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.
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
European Skills Framework
Skills and knowledge areas required for this occupation based on European classification.
Essential (26)
information structureinformation structureThe type of infrastructure which defines the format of data: semi-structured, unstructured and structured.systems development life-cyclesystems development life-cycleThe sequence of steps, such as planning, creating, testing and deploying and the models for the development and life-cycle management of a system.databasedatabaseThe classification of databases, that includes their purpose, characteristics, terminology, models and use such as XML databases, document-oriented databases and full text databases.web programmingweb programmingThe 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 appropriat...ICT security legislationICT security legislationThe set of legislative rules that safeguards information technology, ICT networks and computer systems and legal consequences which result from their misuse. Regulated measures include firewalls, intr...business process modellingbusiness process modellingThe 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 proce...resource description framework query languageresource description framework query languageThe query languages such as SPARQL which are used to retrieve and manipulate data stored in Resource Description Framework format (RDF).database development toolsdatabase development toolsThe methodologies and tools used for creating logical and physical structure of databases, such as logical data structures, diagrams, modelling methodologies and entity-relationships.database management systemsdatabase management systemsThe tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.systems theorysystems theoryThe 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 achie...migrate existing datamigrate existing dataApply migration and conversion methods for existing data, in order to transfer or convert data between formats, storage or computer systems.use markup languagesuse markup languagesUtilise 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.develop automated migration methodsdevelop automated migration methodsCreate automated transfer of ICT information between storage types, formats and systems to save human resources from performing the task manually.assess ICT knowledgeassess ICT knowledgeEvaluate the implicit mastery of skilled experts in an ICT system to make it explicit for further analysis and usage.manage databasemanage databaseApply database design schemes and models, define data dependencies, use query languages and database management systems (DBMS) to develop and manage databases.perform data analysisperform data analysisCollect 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.create software designcreate software designTranspose a series of requirements into a clear and organised software design.write database documentationwrite database documentationDevelop documentation containing information about the database that is relevant to end users.design database schemedesign database schemeDraft 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.operate relational database management systemoperate relational database management systemExtract, 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 ...create database diagramscreate database diagramsDevelop the database design models and diagrams which establish the structure of a database by using modelling software tools to be implemented in further processes.create data setscreate data setsGenerate a collection of new or existing related data sets that are made up out of separate elements but can be manipulated as one unit.analyse business requirementsanalyse business requirementsStudy clients' needs and expectations for a product or service in order to identify and resolve inconsistencies and possible disagreements of involved stakeholders.manage standards for data exchangemanage standards for data exchangeSet and maintain standards for transforming data from source schemas into the necessary data structure of a result schema.apply ICT systems theoryapply ICT systems theoryImplement principles of ICT systems theory in order to explain and document system characteristics that can be applied universally to other systems.define technical requirementsdefine technical requirementsSpecify 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 acc...
Optional (75)
HaskellHaskellThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Haskell.ErlangErlangThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Erlang.SAS languageSAS languageThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in SAS language.Agile project managementAgile project managementThe 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.Ruby (computer programming)Ruby (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Ruby.Common LispCommon LispThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Common Lisp.LispLispThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Lisp.Visual BasicVisual BasicThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Visual Basic.Java (computer programming)Java (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Java.computer programmingcomputer programmingThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms (e.g. object oriented programming, functional programming) a...Prolog (computer programming)Prolog (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Prolog.OpenEdge Advanced Business LanguageOpenEdge Advanced Business LanguageThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in OpenEdge Advanced Business Language.JavaScriptJavaScriptThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in JavaScript.DB2DB2The computer program IBM DB2 is a tool for creating, updating and managing databases, developed by the software company IBM.Microsoft AccessMicrosoft AccessThe computer program Access is a tool for creating, updating and managing databases, developed by the software company Microsoft.XQueryXQueryThe computer language XQuery is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organis...PerlPerlThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Perl.Smalltalk (computer programming)Smalltalk (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Smalltalk.PHPPHPThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in PHP.OpenEdge DatabaseOpenEdge DatabaseThe computer program OpenEdge Database is a tool for creating, updating and managing databases, developed by the software company Progress Software Corporation.Assembly (computer programming)Assembly (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Assembly.data engineeringdata engineeringThe process of developing and constructing systems for implementing data collection and analysis at large scale.ObjectStoreObjectStoreThe computer program ObjectStore is a tool for creating, updating and managing databases, developed by the software company Object Design, Incorporated.C#C#The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in C#.MySQLMySQLThe computer program MySQL is a tool for creating, updating and managing databases, currently developed by the software company Oracle.TripleStoreTripleStoreThe 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.RRThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in R.GroovyGroovyThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Groovy.ASP.NETASP.NETThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ASP.NET.APLAPLThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in APL.SPARQLSPARQLThe computer language SPARQL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organis...Oracle WebLogicOracle WebLogicThe 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.Microsoft Visual C++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. It is dev...IBM InformixIBM InformixThe computer program IBM Informix is a tool for creating, updating and managing databases, developed by the software company IBM.TypeScriptTypeScriptThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in TypeScript.CoffeeScriptCoffeeScriptThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in CoffeeScript.Objective-CObjective-CThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Objective-C.ML (computer programming)ML (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ML.LDAPLDAPThe computer language LDAP is a query language for retrieval of information from a database and of documents containing the needed information.PostgreSQLPostgreSQLThe computer program PostgreSQL is a free and open-source software tool for creating, updating and managing databases, developed by the PostgreSQL Global Development Group.AJAXAJAXThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in AJAX.C++C++The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in C++.Filemaker (database management systems)Filemaker (database management systems)The computer program FileMaker is a tool for creating, updating and managing databases, developed by the software company FileMaker Inc.SAP R3SAP R3The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in SAP R3.Swift (computer programming)Swift (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Swift.ICT project management methodologiesICT project management methodologiesThe 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 pro...SQL ServerSQL ServerThe computer program SQL Server is a tool for creating, updating and managing databases, developed by the software company Microsoft.MATLABMATLABThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in MATLAB.unstructured dataunstructured dataThe 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.CA Datacom/DBCA Datacom/DBThe computer program CA Datacom/DB is a tool for creating, updating and managing databases, currently developed by the software company CA Technologies.LINQLINQThe computer language LINQ is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.Python (computer programming)Python (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Python.Scratch (computer programming)Scratch (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Scratch.Process-based managementProcess-based managementThe 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.Teradata DatabaseTeradata DatabaseThe computer program Teradata Database is a tool for creating, updating and managing databases, developed by the software company Teradata Corporation.lean project managementlean project managementThe 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.VBScriptVBScriptThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in VBScript.Oracle Relational DatabaseOracle Relational DatabaseThe computer program Oracle Rdb is a tool for creating, updating and managing databases, developed by the software company Oracle.COBOLCOBOLThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in COBOL.MarkLogicMarkLogicThe 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 dat...Pascal (computer programming)Pascal (computer programming)The techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Pascal.ABAPABAPThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in ABAP.data sciencedata scienceThe 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.N1QLN1QLThe computer language N1QL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Couchbase.data modelsdata modelsThe 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.ScalaScalaThe techniques and principles of software development, such as analysis, algorithms, coding, testing and compiling of programming paradigms in Scala.define database physical structuredefine database physical structureSpecify the physical configuration of database files on a given media. This consists of in-detail specifications of indexing options, data types and data elements placed in the data dictionary.use databasesuse databasesUse 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.use access control softwareuse access control softwareUtilise software to define the roles and manage user authentication, privileges and access rights to ICT systems, data and services.design database in the clouddesign database in the cloudApply design principles for an adaptive, elastic, automated, loosely coupled databases making use of cloud infrastructure. Aim to remove any single point of failure through distributed database design...design database backup specificationsdesign database backup specificationsSpecify procedures to be performed on databases which ensure the copying and archiving of data for possible restoration in case of a data loss event.apply technical communication skillsapply technical communication skillsExplain technical details to non-technical customers, stakeholders, or any other interested parties in a clear and concise manner.manage cloud data and storagemanage cloud data and storageCreate and manage cloud data retention. Identify and implement data protection, encryption, and capacity planning needs.build business relationshipsbuild business relationshipsEstablish 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 orga...perform resource planningperform resource planningEstimate the expected input in terms of time, human and financial resources necessary to achieve the project objectives.
Related Occupations
Other occupations in the Other category that share similar skill requirements.
AI Replacement Risk
54/ 100
Moderate Risk
Low riskHigh risk