NOC 21223Database analysts and data administrators

TEER 1 — Usually require a university degree

NOC 21223 is the Canadian National Occupational Classification code for Database analysts and data administrators. It is classified TEER 1 — Usually require a university degree, which meets the skill requirement for Express Entry. An officer decides whether you can claim this code by comparing the duties written in your reference letter against the official main duties below — not by your job title.

Express Entry eligible: Yes
Regulated in Québec: No
In demand in Manitoba: Yes

Classification

Natural & applied sciences

2 › 21 › 212 › 2122

Definition

Database analysts design, develop and administer data management solutions. Data administrators develop and implement data administration policy, standards and models. They are employed in information technology consulting firms and in information technology units throughout the public and private sectors.

Main duties

This group performs some or all of the following duties:
Database analysts
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.
Data administrators
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.

Example job titles

•data administrator
•data custodian
•data dictionary administrator
•data warehouse analyst
•database administrator (DBA)
•database analyst
•database architect
•technical architect - database

Track the latest Express Entry and Québec draws →

Overview

Under the Canadian National Occupational Classification (NOC) 2021 system, Database analysts and data administrators are classified under code 21223 (TEER 1). Database analysts are responsible for designing, developing, and administering data policies, standards, and models. Meanwhile, database administrators (DBAs) focus on the technical execution of these models, which includes writing, modifying, integrating, implementing, and testing database management systems. These professionals are highly sought after in IT consulting firms and across information technology units in both the public and private sectors.

To qualify for immigration pathways under NOC 21223, candidates typically require a bachelor's degree in computer science or a closely related discipline, or completion of a college program in computer science. Experience as a computer programmer or network administrator is often required for database administrators. Candidates can leverage this TEER 1 classification to apply for Canadian permanent residency through the Express Entry system, specifically under the Federal Skilled Worker Program and the Canadian Experience Class, as well as targeted tech draws in various Provincial Nominee Programs (PNPs).

Educational overview summarizing this occupation. Always confirm against the official NOC profile and IRCC before relying on it.

Check program eligibility →

Frequently asked questions

Is NOC 21223 eligible for Express Entry?

Yes — Database analysts and data administrators is TEER 1, and TEER 0–3 occupations meet the skill-level requirement for Express Entry programs such as the Federal Skilled Worker Program and the Canadian Experience Class. Full eligibility also depends on your work experience, language results and other program criteria.

What education or training does NOC 21223 usually require?

Database analysts and data administrators is classified as TEER 1 — Usually require a university degree. Always confirm the exact employment requirements on the official NOC profile before relying on them.

Get the next draw in your inbox

One short email when IRCC publishes a new Express Entry draw — the cutoff, invitations, and what it means. Roughly every two weeks. No spam, ever.

By subscribing you consent to receive draw-alert emails from ScoreRoute Canada. Every email includes a one-click unsubscribe. See our privacy policy for details.

Occupation data: Statistics Canada / ESDC — National Occupational Classification (NOC) 2021.