Database Administrator ICT Professionals
SaveWhat Does a Database Administrator Do?
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.
Resource recommendations may include affiliate links. Learn more
Where Do I Start?
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.
Sign up to trackReady to go deeper? Pick up to 3 skills to focus on from the list below.
These are common skills for this role. Real-world experience matters more than ticking every box — use this as a guide, not a checklist.
Skills You Need to Become a Database Administrator
Essential Skills
Essential Skills
-
EssentialData Storage knowledge
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 …
Recommended Books
2 books -
EssentialData Quality Assessment knowledge
The 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.
Recommended Books
1 book -
EssentialDatabase Development Tools knowledge
The methodologies and tools used for creating logical and physical structure of databases, such as logical data structures, diagrams, modelling methodologies and entity-relationships.
Recommended Books
1 book -
EssentialSystem Backup Best Practice knowledge
The procedures related to preparing for recovery or continuation of technology infrastructure vital to an organisation.
No book recommendations available yet.
-
EssentialInformation Structure knowledge
The type of infrastructure which defines the format of data: semi-structured, unstructured and structured.
No book recommendations available yet.
-
EssentialDistributed Computing knowledge
the software process in which computer components interact over a network and send messages to communicate on their actions.
Recommended Books
1 book -
EssentialDatabase Management Systems knowledge
The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.
No book recommendations available yet.
-
EssentialData Models knowledge
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.
No book recommendations available yet.
-
EssentialQuery Languages knowledge
The field of standardised computer languages for retrieval of information from a database and of documents containing the needed information.
No book recommendations available yet.
-
EssentialResource Description Framework Query Language knowledge
The query languages such as SPARQL which are used to retrieve and manipulate data stored in Resource Description Framework format (RDF).
No book recommendations available yet.
-
EssentialApply Company Policies skill
Apply the principles and rules that govern the activities and processes of an organisation.
Course recommendations coming soon.
-
EssentialDesign Database Scheme skill
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.
Course recommendations coming soon.
-
EssentialInterpret Technical Texts skill
Read and understand technical texts that provide information on how to perform a task, usually explained in steps.
Course recommendations coming soon.
-
EssentialManage Database skill
Apply database design schemes and models, define data dependencies, use query languages and database management systems (DBMS) to develop and manage databases.
Course recommendations coming soon.
-
EssentialPerform Backups skill
Implement 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 integrity …
Course recommendations coming soon.
-
EssentialPerform Ict Troubleshooting skill
Identify problems with servers, desktops, printers, networks, and remote access, and perform actions which solve the problems.
Course recommendations coming soon.
-
EssentialUse Scripting Programming skill
Utilise 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 programming languages which …
Course recommendations coming soon.
-
EssentialAdminister Ict System skill
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.
Course recommendations coming soon.
-
EssentialBalance Database Resources skill
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 …
Course recommendations coming soon.
-
EssentialCreate Data Models skill
Use 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 models. …
Course recommendations coming soon.
-
EssentialDefine Database Physical Structure skill
Specify 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.
Course recommendations coming soon.
-
EssentialDesign Database Backup Specifications skill
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.
Course recommendations coming soon.
-
EssentialMaintain Database Performance skill
Calculate values for database parameters. Implement new releases and execute regular maintenance tasks such as establishing backup strategies and eliminating index fragmentation. Evaluate hardware products and operating systems.
Course recommendations coming soon.
-
EssentialMaintain Database Security skill
Master a wide variety of information security controls in order to pursue maximal database protection.
Course recommendations coming soon.
-
EssentialOperate Relational Database Management System skill
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 …
Course recommendations coming soon.
Optional Skills (5 of 28 displayed)
-
OptionalBusiness Intelligence knowledge
The tools used to transform large amounts of raw data into relevant and helpful business information.
-
OptionalLdap knowledge
The computer language LDAP is a query language for retrieval of information from a database and of documents containing the needed information.
No book recommendations available yet.
-
OptionalLinq knowledge
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.
No book recommendations available yet.
-
OptionalXquery knowledge
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 …
No book recommendations available yet.
-
OptionalMicrosoft Access knowledge
The computer program Access is a tool for creating, updating and managing databases, developed by the software company Microsoft.
-
OptionalMysql knowledge
The computer program MySQL is a tool for creating, updating and managing databases, currently developed by the software company Oracle.
Recommended Books
2 books -
OptionalObjectstore knowledge
The computer program ObjectStore is a tool for creating, updating and managing databases, developed by the software company Object Design, Incorporated.
Recommended Books
1 book -
OptionalPostgresql knowledge
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.
No book recommendations available yet.
-
OptionalOpenedge Database knowledge
The computer program OpenEdge Database is a tool for creating, updating and managing databases, developed by the software company Progress Software Corporation.
No book recommendations available yet.
-
OptionalSparql knowledge
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 …
Recommended Books
1 book -
OptionalTeradata Database knowledge
The computer program Teradata Database is a tool for creating, updating and managing databases, developed by the software company Teradata Corporation.
No book recommendations available yet.
-
OptionalN1ql knowledge
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.
No book recommendations available yet.
-
OptionalOracle Relational Database knowledge
The computer program Oracle Rdb is a tool for creating, updating and managing databases, developed by the software company Oracle.
No book recommendations available yet.
-
OptionalFilemaker (Database Management Systems) knowledge
The computer program FileMaker is a tool for creating, updating and managing databases, developed by the software company FileMaker Inc.
Recommended Books
1 book -
OptionalIbm Informix knowledge
The computer program IBM Informix is a tool for creating, updating and managing databases, developed by the software company IBM.
Recommended Books
1 book -
OptionalSql Server knowledge
The computer program SQL Server is a tool for creating, updating and managing databases, developed by the software company Microsoft.
Recommended Books
1 book -
OptionalDb2 knowledge
The computer program IBM DB2 is a tool for creating, updating and managing databases, developed by the software company IBM.
No book recommendations available yet.
-
OptionalMdx knowledge
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.
No book recommendations available yet.
-
OptionalOnline Analytical Processing knowledge
The 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.
No book recommendations available yet.
-
OptionalQuality Assurance Methodologies knowledge
Quality assurance principles, standard requirements, and the set of processes and activities used for measuring, controlling and ensuring the quality of products and processes.
No book recommendations available yet.
-
OptionalEstimate Duration Of Work skill
Produce 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 …
Course recommendations coming soon.
-
OptionalExecute Ict Audits skill
Organise 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 issues and recommend solutions …
Course recommendations coming soon.
-
OptionalProvide Technical Documentation skill
Prepare documentation for existing and upcoming products or services, describing their functionality and composition in such a way that it is understandable for a wide audience without technical background and …
Course recommendations coming soon.
-
OptionalUse Automatic Programming skill
Utilise specialised software tools to generate computer code from specifications, such as diagrams, structured informations or other means of describing functionality.
Course recommendations coming soon.
-
OptionalUse Different Communication Channels skill
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.
Course recommendations coming soon.
-
OptionalProvide Ict Support skill
Resolve ICT-related incidents and service requests from customers, clients or colleagues including password resets and updating databases such as Microsoft Exchange email.
Course recommendations coming soon.
-
OptionalProvide Technical Training skill
Explain and demonstrate the use of training equipment and system functions.
Course recommendations coming soon.
-
OptionalSupport Ict System Users skill
Communicate 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.
Course recommendations coming soon.
