Manage database

Apply database design schemes and models, define data dependencies, use query languages and database management systems (DBMS) to develop and manage databases.

implement database theory

skill/competence

cross-sector

Manage database is an essential skill of the following occupations:

Data warehouse designer: Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
ICT intelligent systems designer: ICT intelligent systems designers apply methods of artificial intelligence in engineering, robotics and computer science to design programs which simulate intelligence including thinking models, cognitive and knowledge-based systems, problem solving, and decision making. They also integrate structured knowledge into computer systems (ontologies, knowledge bases) in order to solve complex problems normally requiring a high level of human expertise or artificial intelligence methods.
Lottery manager: Lottery managers organise and coordinate the activities of a lottery organisation. They oversee daily operations and facilitate communications between staff and customers. They review lottery procedures, arrange prices train staff and strive to improve the profitability of their business. They take responsibility for all lottery activities and ensure that relevant lottery rules and regulations are followed.
Big data archive librarian: Big data archive librarians classify, catalogue and maintain libraries of digital media. They also evaluate and comply with metadata standards for digital content and update obsolete data and legacy systems.
Bioinformatics scientist: Bioinformatics scientists analyse biological processes using computer programmes. They maintain or construct databases containing biological information. Bioinformatics scientists gather and analyse biological data and may also assist scientists in various fields, including in biotechnology and pharmaceutics. They perform scientific research and statistical analyses, and report on their findings. Bioinformatics scientists may also collect DNA samples, discover data patterns and conduct genetic research.
Data quality specialist: Data quality specialists review organisation’s data for accuracy, recommend enhancements to record systems and data acquisition processes and assess referential and historical integrity of data. They also develop documents and maintain data quality goals and standards and oversee an organisation’s data privacy policy and monitor compliance of data flows against data quality standards.
Knowledge engineer: Knowledge engineers integrate structured knowledge into computer systems (knowledge bases) in order to solve complex problems normally requiring a high level of human expertise or artificial intelligence methods. They are also responsible for eliciting or extracting knowledge from information sources, maintaining this knowledge, and making it available to the organisation or users. To achieve this, they are aware of knowledge representation and maintenance techniques (rules, frames, semantic nets, ontologies) and use knowledge extraction techniques and tools. They can design and build expert or artificial intelligence systems that use this knowledge.
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.
Database designer: Database designers specify the database’s logical structure, processes, and information flows. They design data models and databases to serve data acquisition.
Data centre operator: 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.
Curator of horticulture: Curators of horticulture develop and maintain the botanical collections, exhibits and landscapes of a botanical garden.
ICT system architect: ICT system architects design architecture, components, modules, interfaces, and data for a multi-components system to meet specified requirements.

Manage database is optional for these occupations. This means knowing this skill may be an asset for career advancement if you are in one of these occupations.

ICT security administrator: ICT security administrators plan and carry out security measures to protect information and data from unauthorised access, deliberate attack, theft and corruption.
Criminologist: Criminologists study conditions pertaining to humans such as the social and psychological aspects that could lead them to commit criminal acts. They observe and analyse different factors ranging from behavioural conditions up to social background and environment of suspects in order to advise organisations on the prevention of crime.
Auditing clerk: Auditing clerks collect and examine financial data, such as inventory transactions, for organisations and companies and ensure they are accurate, properly maintained, and that they add up. They review the numbers in databases and documents, evaluate, and consult and assist the source of the transaction if necessary, which includes accountants, managers or other clerks.
Market research analyst: Market research analysts collect the information gathered in the market research and study it to draw conclusions. They define the potential customers of a product, the target group and the way they can be reached. Market research analysts analyse the position of products in the market from different perspectives such as features, prices and competitors. They analyse cross selling and interdependencies between different products and their placement. Market research analysts prepare information helpful for the development of marketing strategies.
Statistician: Statisticians collect, tabulate, and, most importantly, analyse quantitative information coming from a varied array of fields. They interpret and analyse statistical studies on fields such as health, demographics, finance, business, etc. and advise based on patterns and drawn analysis.
Biometrician: Biometricians perform research in the field of biometrics. They carry statistical or biological research projects by measuring fingerprints, retinas, and human shapes for medical or industrial applications.
Grants administrator: Grants administrators handle the pass-through track of grants, often given out by the government to the grant recipient. They prepare the paperwork such as the grant applications and give out the grants. They are also responsible to make sure that the grant recipient spends the money correctly according to the terms laid out.
Statistical assistant: Statistical assistants collect data and use statistical formulas to execute statistical studies and create reports. They create charts, graphs and surveys.
Demographer: Demographers study a variety of parameters related with population. They develop, based on their observations, statistical analyses on the evolutions and changes of births, elderly, marriage and divorce, employment, mortality, immigration and related matters.

References

1. Manage database – ESCO