database management systems
The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.
digital
Data centre operators maintain computer operations within the data centre. They manage daily activities within the centre to solve problems, maintain the system availability, and evaluate the system's performance.
Competences and skills
49 ESCO relationsEssential knowledge 3 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
3 competencesquery languages
The field of standardised computer languages for retrieval of information from a database and of documents containing the needed information.
digital
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).
digital
Cross-sector
0 competencesNo competences in this bucket.
Essential skills and competences 11 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
10 competencesadminister ICT system
Handle components of ICT system by maintaining configuration, managing users, monitoring resource use, performing backups and installing hardware or software to comply with the set requirements.
digital
analyse ICT system
Analyse the functioning and performance of information systems in order to define their goals, architecture and services and set procedures and operations to meet end users requirements.
digital
balance database resources
Stabilise the workload and resources of a database, by controlling the demand of transactions, allocating disk spaces and ensuring reliability of the servers in order to optimise cost and risk ratio.
digital
develop contingency plans for emergencies
Compose procedures outlining specific actions to be taken in the event of an emergency, taking into account all the risks and dangers that could be involved, ensuring that the plans comply with safety legislation and represent the safest course of action.
keep up with the latest information systems solutions
Gather the latest information on existing information systems solutions which integrate software and hardware, as well as network components.
digital
maintain database performance
Calculate values for database parameters. Implement new releases and execute regular maintenance tasks such as establishing backup strategies and eliminating index fragmentation.
digital
maintain database security
Master a wide variety of information security controls in order to pursue maximal database protection.
digital
maintain ICT server
Diagnose and eliminate hardware faults via repair or replacement. Take preventive measures, review performance, update software, review accessibility.
digital
migrate existing data
Apply migration and conversion methods for existing data, in order to transfer or convert data between formats, storage or computer systems.
digital
monitor system performance
Measure system reliability and performance before, during and after component integration and during system operation and maintenance. Select and use performance monitoring tools and techniques, such as special software.
digital
Cross-sector
1 competencemanage database
Apply database design schemes and models, define data dependencies, use query languages and database management systems (DBMS) to develop and manage databases.
digital
Optional knowledge 24 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
23 competencesbusiness ICT systems
The software packages, hardware devices and new technologies used in supporting business processes such as enterprise resource planning (ERP), customer relationship management (CRM), mobile devices and network solutions.
digital
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.
digital
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.
digital
data storage
The physical and technical concepts of how digital data storage is organised in specific schemes both locally, such as hard-drives and random-access memories (RAM) and remotely, via network, internet or cloud.
digital
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.
digital
DB2
The computer program IBM DB2 is a tool for creating, updating and managing databases, developed by the software company IBM.
digital
Filemaker (database management systems)
The computer program FileMaker is a tool for creating, updating and managing databases, developed by the software company FileMaker Inc.
digital
IBM Informix
The computer program IBM Informix is a tool for creating, updating and managing databases, developed by the software company IBM.
digital
information confidentiality
The mechanisms and regulations which allow for selective access control and guarantee that only authorised parties (people, processes, systems and devices) have access to data, the way to comply with confidential information and the risks of non-compliance.
digital
LDAP
The computer language LDAP is a query language for retrieval of information from a database and of documents containing the needed information.
digital
LINQ
The 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.
digital
MDX
The computer language MDX 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.
digital
Microsoft Access
The computer program Access is a tool for creating, updating and managing databases, developed by the software company Microsoft.
digital
MySQL
The computer program MySQL is a tool for creating, updating and managing databases, currently developed by the software company Oracle.
digital
N1QL
The 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.
digital
ObjectStore
The computer program ObjectStore is a tool for creating, updating and managing databases, developed by the software company Object Design, Incorporated.
digital
OpenEdge Database
The computer program OpenEdge Database is a tool for creating, updating and managing databases, developed by the software company Progress Software Corporation.
digital
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.
digital
SPARQL
The 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 organisation World Wide Web Consortium.
digital
SQL Server
The computer program SQL Server is a tool for creating, updating and managing databases, developed by the software company Microsoft.
digital
Teradata Database
The computer program Teradata Database is a tool for creating, updating and managing databases, developed by the software company Teradata Corporation.
digital
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.
digital
XQuery
The 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 organisation World Wide Web Consortium.
digital
Cross-sector
1 competenceWorld Wide Web Consortium standards
The standards, technical specifications and guidelines developed by the international organisation World Wide Web Consortium (W3C) which allow the design and development of web applications.
digital
Optional skills and competences 11 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
5 competencesdevelop automated migration methods
Create automated transfer of ICT information between storage types, formats and systems to save human resources from performing the task manually.
digital
implement a firewall
Download, install and update a network security system designed to prevent unauthorized access to a private network.
digital
implement a virtual private network
Create an encrypted connection between private networks, such as different local networks of a company, over the internet to ensure that only authorized users can access it and that the data cannot be intercepted.
digital
implement anti-virus software
Download, install and update software to prevent, detect and remove malicious software, such as computer viruses.
digital
integrate system components
Select and use integration techniques and tools to plan and implement integration of hardware and software modules and components in a system.
digital
Cross-sector
6 competencescontrol of expenses
Monitor and maintain effective cost controls, in regards to efficiencies, waste, overtime and staffing. Assessing excesses and strives for efficiency and productivity.
create solutions to problems
Solve problems which arise in planning, prioritising, organising, directing/facilitating action and evaluating performance. Use systematic processes of collecting, analysing, and synthesising information to evaluate current practice and generate new understandings about practice.
use back-up and recovery tools
Use tools which allow users to copy and archive computer software, configurations and data and recover them in case of loss.
digital
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.
digital
use different communication channels
Make use of various types of communication channels such as verbal, handwritten, digital and telephonic communication with the purpose of constructing and sharing ideas or information.
use ICT ticketing system
Utilise a specialised system to track registration, processing and resolution of issues in an organisation by assigning each of these issues a ticket, registering inputs from involved persons, tracking changes and displaying the status of the ticket, until it is completed.
digital