Explore occupational profile
- Version:
- OaSIS 2022 Version 1.0
Search the OaSIS
Overview
Example job titles
- Data administrator
- Data custodian
- Database administrator (DBA)
Main duties
This group performs some or all of the following duties:
- Develop and implement data administration policy, standards and models
- Research and document data requirements, data collection and administration policy, data access rules and security
- Develop policies and procedures for network and/or Internet database access and usage and for the backup and recovery of data
- Conduct research and provide advice to other information systems professionals regarding the collection, availability, security and suitability of data
- Write scripts related to stored procedures and triggers
- May lead and coordinate teams of data administrators in the development and implementation of data policies, standards and models.
Additional information
Similar occupations classified elsewhere
Exclusions:
- Computer and information systems managers (20012)
NOC hierarchy breakdown
NOC version
NOC 2021 Version 1.0Broad occupational category
2 – Natural and applied sciences and related occupationsTEER
1 – Occupations usually require a university degreeMajor group
21 – Professional occupations in natural and applied sciencesSub-major group
212 – Professional occupations in applied sciences (except engineering)Minor group
2122 – Computer and information systems professionalsUnit group
21223 – Database analysts and data administratorsOccupational profile
21223.02 – Data administratorsWork characteristics
This section outlines the key elements of each occupation’s work environment, including the type of work done, its location, and the setting. There are three categories included in this section:
- Work Activities: describes common tasks undertaken by occupations, grouped into physical, mental, people-oriented, or information gathering activities
- Work Context: highlights key descriptors of the occupation’s setting, such as the physical work environment, physical demands, and the types of interactions with others
- Workplaces/employers: lists common industries or types of companies where the occupation is typically found
The most important descriptors are displayed, in descending order based first on complexity (for Work Activities) or other measurement dimensions (for Work Context) and then alphabetically. Expand the list to present the full list of descriptors and their ratings by selecting “see more”.
Work Activities
General types of work-related activities.
Workplaces/employers
- Information technology consulting firms
- Information technology departments in the private and public sectors
Work Context
Structural Job Characteristics
Physical Work Environment
Physical Demands
Interpersonal Relations
Skills and abilities
This section outlines the competencies required for an occupation in the categories of:
- Abilities: innate or developed aptitudes that enable a person to be able to perform expected tasks in this occupation, grouped into cognitive, psychomotor, sensory, and physical abilities
- Skills: developed capabilities that an individual must have to be effective in this occupation, grouped into foundational, analytical, technical, resource management, or interpersonal skills
- Personal Attributes: personal characteristics that are innate or developed through social context and personal experiences
Each category displays up to five descriptors, in descending order based first on proficiency level (for Skills and Abilities) or importance (for Personal Attributes) and then alphabetically. Expand the list to present the full list of descriptors and their ratings by selecting “see more”.
Abilities
Innate and developed aptitudes that facilitate the acquisition of knowledge and skills to carry out expected work.
Skills
Developed capabilities that an individual must have to be effective in a job, role, function, task or duty.
Personal Attributes
Personal characteristics that are innate and developed through the social context and personal experiences to which the individual is exposed. These qualities influence the way one is and does things and are considered to be valuable assets for work performance.
Employment requirements
Employment requirements include the education, training, certifications, and knowledge needed for each occupation. The Knowledge category displays up to five descriptors, in descending order based first on the knowledge level and then alphabetically. Expand the list to present the full list of descriptors and their ratings by selecting “see more”.
Education, certification and licensing
- A bachelor's degree or college program, usually in computer science, computer engineering, or mathematics is usually required.
- Computer programming and related experience is usually required.
Skills for Success
The Skills for Success (SFS) is a model that outlines the fundamental and transferable skills needed to learn, work, and fully participate in daily life. It includes skills descriptions and proficiency levels for nine key skills: adaptability, collaboration, communication, creativity and innovation, digital, numeracy, problem solving, reading and writing.
This section is intended to help users navigate between the SFS model and the occupational competency requirements in the OaSIS.
For each occupational profile, the nine SFS are aligned with corresponding competencies in the OaSIS. The OaSIS provides valuable insights into the level of proficiency or importance required for over 240 competencies across 900 occupations.
To find out how the OaSIS ratings were developed, please consult the methodology here: Occupational and Skills Information System (OaSIS) methodology - Canada.ca
For questions or comments, feel free to contact us.
Interests
The OaSIS uses the Holland Codes to describe work-related interests. According to the Holland model, people perform best in work environments that match their preferences, meaning individuals and occupations can be matched for an optimal fit. In this model, occupational environments are categorized based on a combination of primary interests and related activities. There are six interests in the Holland typology: Realistic, Investigative, Artistic, Social, Enterprising, and Conventional. Each occupation in the OaSIS is assigned up to three of these interest types.
Interests
Preferences for work environments and outcomes.
Interests profile: ICE
Investigative (I)
Investigative occupations are characterized by the dominance of activities that entail the observation and symbolic, systematic, and creative investigation of physical, biological, or cultural phenomena. These occupations require an extensive amount of thinking and frequently involve working with ideas, searching for facts, and figuring out problems mentally. They encourage scientific competencies and achievements. Workers in those occupations are erudite, have mathematical and scientific abilities, and see the world in complex, abstract, independent, and original terms. They are rewarded in their work environment for the display of scientific values.
Conventional (C)
Conventional occupations are characterized by the dominance of activities that entail the explicit, ordered, and systematic manipulation of data, such as keeping records, filing materials, reproducing materials, organizing written and numerical data according to a prescribed plan, and operating business and data processing machines. They often require following a clear line of authority or set procedures and routines, and usually involve working with data and details more than with ideas. They foster clerical competencies and achievements. Workers in those occupations are conforming, orderly, and methodical. They see the world in conventional, stereotypical, constricted, simple, and dependent terms. They are rewarded in their work environment for the display of conventional values: money, dependability, conformity.
Enterprising (E)
Enterprising occupations are characterized by the dominance of activities that entail the interaction with others to attain organizational or self-interest goals. They frequently involve starting up and carrying out projects, influencing, leading or mobilizing people and making decisions, and sometimes require risk taking and dealing with business. They foster enterprising competencies and achievements. Workers in those occupations are audacious, popular, self-confident, sociable, and possess leadership and speaking abilities. They see the world in terms of power, status, responsibility, and in stereotyped, dependent, and simple terms. They are rewarded in their work environment for the display of enterprising values and goals: money, power and status.
This page includes information from the O*NET 27.2 Database by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET® is a trademark of USDOL/ETA. Employment and Social Development Canada has modified all or some of this information. USDOL/ETA has not approved, endorsed, or tested these modifications.