NOC 21223 job description: database analyst duties and responsibilities
- 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.
- 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.
Job titles under NOC 21223
See every job title and its code in the A–Z job title index, or all TEER 1 jobs.
Is NOC 21223 eligible for Express Entry?
By TEER, yes. TEER 1 is inside the TEER 0 to 3 range that the Federal Skilled Worker Program and Canadian Experience Class accept. You still need qualifying work experience, language test results and enough CRS points to get an invitation. Category-based draws and provincial nominee programs use their own occupation lists.
| Program | TEER check | Why |
|---|---|---|
| Federal Skilled Worker | TEER qualifies | TEER 1 is within TEER 0 to 3 |
| Canadian Experience Class | TEER qualifies | TEER 1 is within TEER 0 to 3 |
| Federal Skilled Trades | Not a listed trade | Only certain trade groups qualify. Check IRCC |
| Spouse's open work permit | Qualifies | All TEER 1 jobs qualify. SOWP rules |
Category-based draws: NOC 21223 is not on any category-based selection list (checked 2026-10-16). Under NOC 2016, TEER 1 was skill level A ("NOC A").
Category-based Express Entry draws and provincial nominee programs use their own occupation lists. Check the current lists on IRCC's Express Entry page and provincial nominee page.
NOC 21223: common questions
What is NOC 21223?
NOC 21223 is the code for database analysts and data administrators in Canada's National Occupational Classification (NOC 2021). Its first digit, 2, is the broad category and its second digit, 1, is the TEER level. Immigration forms, job offers and LMIA applications use this five-digit code.
What TEER is NOC 21223?
NOC 21223 is TEER 1. Occupations that usually need a university degree. Under the older NOC 2016 system, TEER 1 lines up with skill level A.
Is NOC 21223 eligible for Express Entry and PR?
By TEER, yes. TEER 1 is inside the TEER 0 to 3 range that the Federal Skilled Worker Program and Canadian Experience Class accept. You still need qualifying work experience, language test results and enough CRS points to get an invitation. Category-based draws and provincial nominee programs use their own occupation lists.
Is NOC 21223 in a category-based Express Entry draw?
No. As of IRCC's list dated 2026-10-16, NOC 21223 is not in any category-based selection list (healthcare, STEM, trades, education, transport and others). You can still be invited in general and program-specific draws.
Is NOC 21223 eligible for a spousal open work permit (SOWP)?
Yes. All TEER 1 jobs qualify, so a worker in this job can support a spouse's open work permit, as long as their own work permit has at least 16 months left when the spouse applies (IRCC page modified 2026-06-12).
What is the NOC code for a database analyst?
Database analyst is listed under NOC 21223, database analysts and data administrators. The job title alone does not decide your code: your duties should match the main duties of NOC 21223.
How do I know if NOC 21223 is my NOC code?
Compare what you actually do with the main duties listed for NOC 21223, not just your job title. IRCC expects your duties to match the lead statement and most of the main duties of the code you choose. If they fit another code better, use that one. You can paste your duties into nocfinder to see how they line up, duty by duty.
Source: ESDC NOC 2021 · IRCC program pages. Not legal advice.