View occupational profile

Search the OaSIS

Database analysts

OaSIS code 21223.01

Database analysts design, develop and administer data management solutions.

Overview

Also known as

  • Database analyst

Main duties

This group performs some or all of the following duties:

  • Collect and document user requirements
  • Design and develop database architecture for information systems projects
  • Design, construct, modify, integrate, implement and test data models and database management systems
  • Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools
  • Operate database management systems to analyze data and perform data mining analysis
  • May lead, coordinate or supervise other workers in this group.

Additional information

No data has been provided for this section.

Similar occupations classified elsewhere

Exclusions:

  • Information systems specialists (21222)
  • Computer systems developers and programmers (21230)
  • Software developers and programmers (21232)
  • Computer engineers (except software engineers and designers) (21311)

NOC hierarchy breakdown

NOC version

NOC 2021 Version 1.0

Broad occupational category

2 – Natural and applied sciences and related occupations

TEER

1 – Occupations usually require a university degree

Major group

21 – Professional occupations in natural and applied sciences

Sub-major group

212 – Professional occupations in applied sciences (except engineering)

Minor group

2122 – Computer and information systems professionals

Unit group

21223 – Database analysts and data administrators

Occupational profile

21223.01 – Database analysts

Work characteristics

Work characteristics gathers the various components describing the work environment of each occupation, such as employers, work activities, and the work context. Each category displays up to 10 descriptors in descending order based, firstly, on their attributed ratings by the level of complexity (for Work Activities) or other measurement dimensions (for Work Context), and secondly, in alphabetical order. The whole list of descriptors and their ratings can be expanded at the bottom of each page.

Work Activities

Proficiency or complexity level
Analyzing Data or Information
5 - Highest Level
Interacting with Computers
5 - Highest Level
Processing Information
5 - Highest Level
Thinking Creatively
5 - Highest Level
Applying New Knowledge
4 - High Level

Work Context

Structural Job Characteristics

Structured versus Unstructured Work
Degree of freedom to determine tasks and priorities
3 - Moderate amount of freedom
Work Week Duration
Worked hours in a typical week
2 - Between 35 to 40 hours

Physical Work Environment

Physical Proximity
Physical distance from others
3 - Somewhat close (e.g. share office)

Physical Demands

Sitting
Duration
5 - All the time, or almost all the time
Standing
Duration
1 - Very little time
Bending or Twisting the Body
Duration
1 - Very little time

Interpersonal Relations

Contact with Others
Frequency
4 - Every day, a few times per day
Duration
3 - About half the time
Work with Work Group or Team
Importance
4 - Highly important
Frequency
3 - Once a week or more but not every day

Workplaces/employers

  • Information technology consulting firms
  • Information technology departments in the private and public sectors

Skills and abilities

This section displays the various competencies required for an occupation. Each category displays up to 10 descriptors in descending order based, firstly, on their attributed ratings by the level of proficiency (for Skills and Abilities) or importance (for Personal Attributes) and secondly, in alphabetical order. The whole list of descriptors and their ratings can be expanded at the bottom of each page.

Abilities

Proficiency or complexity level
Deductive Reasoning
4 - High Level
Fluency of Ideas
4 - High Level
Inductive Reasoning
4 - High Level
Information Ordering
4 - High Level
Mathematical Reasoning
4 - High Level

Skills

Proficiency or complexity level
Critical Thinking
4 - High Level
Decision Making
4 - High Level
Digital Literacy
4 - High Level
Evaluation
4 - High Level
Numeracy
4 - High Level

Personal Attributes

Importance
Analytical Thinking
5 - Extremely important
Attention to Detail
5 - Extremely important
Active Learning
4 - Highly important
Adaptability
4 - Highly important
Collaboration
4 - Highly important