Infocomm TechnologyInformation and communications technology professionalsISCO 2521
database administrator
Database administrators test, implement and administer computer databases. They use their expertise in database management systems to plan, coordinate and implement security measures to safeguard computer databases. They also use scripts and configuration files to tailor a database to users' needs.
European Skills Framework
Skills and knowledge areas required for this occupation based on European classification.
Essential (27)
information structureinformation structureThe type of infrastructure which defines the format of data: semi-structured, unstructured and structured.domain name servicedomain name serviceNaming database which maps internet domain names to Internet Protocol (IP) addresses. The Domain Name System allows internet users to utilise names such as website titles instead of remembering numeri...system backup best practicesystem backup best practiceThe procedures related to preparing for recovery or continuation of technology infrastructure vital to an organisation.distributed computingdistributed computingThe software process in which computer components interact over a network and send messages to communicate on their actions.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.data storagedata storageThe 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 ...database management systemsdatabase management systemsThe tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.data quality assessmentdata quality assessmentThe process of revealing data issues using quality indicators, measures and metrics in order to plan data cleansing and data enrichment strategies according to data quality criteria.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.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 an application-specific interfaceuse an application-specific interfaceUnderstand and use interfaces particular to an application or use case.administer ICT systemadminister ICT systemHandle 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.apply company policiesapply company policiesApply the principles and rules that govern the activities and processes of an organisation.manage databasemanage databaseApply database design schemes and models, define data dependencies, use query languages and database management systems (DBMS) to develop and manage databases.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 scripting programminguse scripting programmingUtilise specialised ICT tools to create computer code that is interpreted by the corresponding run-time environments in order to extend applications and automate common computer operations. Use progra...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 ...perform ICT troubleshootingperform ICT troubleshootingIdentify problems with servers, desktops, printers, networks, and remote access, and perform actions which solve the problems.interpret technical textsinterpret technical textsRead and understand technical texts that provide information on how to perform a task, usually explained in steps.balance database resourcesbalance database resourcesStabilise 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.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.perform backupsperform backupsImplement backup procedures to backup data and systems to ensure permanent and reliable system operation. Execute data backups in order to secure information by copying and archiving to ensure integri...maintain database performancemaintain database performanceCalculate values for database parameters. Implement new releases and execute regular maintenance tasks such as establishing backup strategies and eliminating index fragmentation.maintain database securitymaintain database securityMaster a wide variety of information security controls in order to pursue maximal database protection.create data modelscreate data modelsUse specific techniques and methodologies to analyse the data requirements of an organisation's business processes in order to create models for these data, such as conceptual, logical and physical mo...
Optional (38)
business intelligencebusiness intelligenceThe tools used to transform large amounts of raw data into relevant and helpful business information.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...OpenEdge DatabaseOpenEdge DatabaseThe computer program OpenEdge Database is a tool for creating, updating and managing databases, developed by the software company Progress Software Corporation.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.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.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...IBM InformixIBM InformixThe computer program IBM Informix is a tool for creating, updating and managing databases, developed by the software company IBM.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.online analytical processingonline analytical processingThe online tools which analyse, aggregate and present multi-dimensional data enabling users to interactively and selectively extract and view data from specific points of view.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.SQL ServerSQL ServerThe computer program SQL Server is a tool for creating, updating and managing databases, developed by the software company Microsoft.quality assurance methodologiesquality assurance methodologiesQuality assurance principles, standard requirements, and the set of processes and activities used for measuring, controlling and ensuring the quality of products and processes.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.Teradata DatabaseTeradata DatabaseThe computer program Teradata Database is a tool for creating, updating and managing databases, developed by the software company Teradata Corporation.Oracle Relational DatabaseOracle Relational DatabaseThe computer program Oracle Rdb is a tool for creating, updating and managing databases, developed by the software company Oracle.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...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.implement ICT security policiesimplement ICT security policiesImplement statements, assertions or rules that specify the appropriate use and protection of the ICT assets and systems from an organisation. These ICT security policies cover topics such as data clas...use spreadsheets softwareuse spreadsheets softwareUse software tools to create and edit tabular data to carry out mathematical calculations, organise data and information, create diagrams based on data and to retrieve them.protect personal data and privacyprotect personal data and privacyProtect personal data and privacy in digital environments. Understand how to use and share personally identifiable information while being able to protect oneself and others from damages. Understand t...use different communication channelsuse different communication channelsMake 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 automatic programminguse automatic programmingUtilise specialised software tools to generate computer code from specifications, such as diagrams, structured informations or other means of describing functionality.execute ICT auditsexecute ICT auditsOrganise and execute audits in order to evaluate ICT systems, compliance of components of systems, information processing systems and information security. Identify and collect potential critical issu...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...use back-up and recovery toolsuse back-up and recovery toolsUse tools which allow users to copy and archive computer software, configurations and data and recover them in case of loss.remove computer virus or malware from a computerremove computer virus or malware from a computerCarry out actions to remove computer viruses or other types of malware from a computer.implement anti-virus softwareimplement anti-virus softwareDownload, install and update software to prevent, detect and remove malicious software, such as computer viruses.provide ICT supportprovide ICT supportResolve ICT-related incidents and service requests from customers, clients or colleagues including password resets and updating databases such as Microsoft Exchange email.manage cloud data and storagemanage cloud data and storageCreate and manage cloud data retention. Identify and implement data protection, encryption, and capacity planning needs.provide technical trainingprovide technical trainingExplain and demonstrate the use of training equipment and system functions.support ICT system userssupport ICT system usersCommunicate with end users, instruct them on how to progress with tasks, use ICT support tools and methods to solve problems and identify possible side effects and provide solutions.estimate duration of workestimate duration of workProduce accurate calculations on time necessary to fulfil future technical tasks based on past and present information and observations or plan the estimated duration of individual tasks in a given pr...implement a firewallimplement a firewallDownload, install and update a network security system designed to prevent unauthorized access to a private network.
Related Occupations
Other occupations in the Other category that share similar skill requirements.
AI Replacement Risk
85/ 100
Very High Risk
Low riskHigh risk