What are the prevailing wages for NOC 21223 across major Canadian cities?

According to official ESDC Job Bank benchmarks, the prevailing median rate for NOC 21223 (Database analysts and data administrators) is $43.44/hr in Montréal, $42.05/hr in Ottawa, $44.47/hr in Toronto, $44.06/hr in Calgary, $45.8/hr in Edmonton.

NOC 21223: Database analysts and data administrators

Official definition · Statistics Canada NOC 2021 v1.0 · statcan.gc.ca ↗

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.

Median Pay$40.87/hrPrevailing median rate

TEER LevelLevel 1Express Entry pool

Priority StreamSTEM PriorityCategory draws

Official Titles23 TitlesGovernment aliases

Interactive Reference Letter Tool

Official Main Duties for NOC 21223

Select the duties you perform in your actual job. Under IRCC guidelines, you must perform at least 60% of these duties for a successful work permit or PR reference letter.

🔎 Check Your Company Job Title23 official aliases

Checklist (14 official duties):Click each to toggle

💡

IRCC Reference Letter Rule:

Your employer reference letter must confirm you performed the main actions described in the duties above. Avoid copying words directly from the NOC description — officers expect natural job descriptions with specific company context.

Live Match Score⚠ Needs 9 More

0 of 14 selected

0%60% Recommended100%

Below 60% Target (0%)To qualify for NOC 21223, your employer letter should verify at least 9 main duties. Select 9 more to see if your experience matches.

Minimum Needed9 Duties

Current StatusIncomplete

Canadian Labour Market & PR Pathways for NOC 21223

Under Canada's National Occupational Classification (NOC 2021 Version 1.0), Database analysts and data administrators is categorized under TEER 1. Occupations in this tier typically require a university degree (bachelor’s, master’s, or doctorate) or substantial managerial tenure.

Express Entry Alignment

Qualifies directly for the Federal Skilled Worker (FSW) and Canadian Experience Class (CEC) under Express Entry. Work experience must be full-time (or equivalent part-time) and continuous for at least one year.

Target Category Status

Designated under IRCC's STEM Priority Stream →. Candidates with 6 months of qualifying Canadian or foreign experience in this NOC can receive Invitations to Apply (ITAs) at significantly lower CRS cutoff thresholds.

NOC 2016 to NOC 2021 Transition & Equivalency

Open Full NOC Converter Tool→

Under Canada's previous NOC 2016 classification, this occupation was mapped under the following 4-digit code(s). When preparing your Express Entry profile or work reference letters, you must use the new 5-digit code NOC 21223.

Former NOC 21724-Digit Legacy

Database analysts and data administrators

RC4.2 - Split off

2172 continues as 21223 and part split off to emerging item 21211

Job Bank Open Data (2025/2026)

Regional Wages Across Canada

Legal Benchmark for LMIA

Under Canadian immigration law, an employer hiring you under an LMIA must pay you at least the median wage listed below for your province.

Province / Territory	Low Wage	Median Wage	High Wage
Canada (National Average)	$25	$40.87/hr	$61.03
Newfoundland and Labrador →	$24.04/hr	$45.08/hr	$68.66/hr
Prince Edward Island →	$18/hr	$36.3/hr	$49.23/hr
Nova Scotia →	$20/hr	$33.65/hr	$76.92/hr
New Brunswick →	$26.92/hr	$40.87/hr	$51.28/hr
Quebec →	$22/hr	$43.96/hr	$55/hr
Ontario →	$24.58/hr	$40.87/hr	$61.54/hr
Manitoba →	$31.25/hr	$38.94/hr	$47.12/hr
Saskatchewan →	$25.34/hr	$38.46/hr	$61.03/hr
Alberta →	$28.27/hr	$39.82/hr	$60.58/hr
British Columbia →	$28.75/hr	$43.96/hr	$60/hr

🏙️Top Metropolitan Cities Wage Rates (ESDC 2025/2026)

Economic Region Benchmarks

Official ESDC prevailing median wages across major Canadian metropolitan regions. Crucial for LMIA prevailing wage compliance and local job offer evaluations.

Montréal

$43.44/hr

$28.98 - $60.8

Ottawa

$42.05/hr

$24.73 - $61.54

Toronto

$44.47/hr

$21.9 - $67.45

Calgary

$44.06/hr

$28.57 - $67.91

Edmonton

$45.8/hr

$33 - $60.58

Vancouver

$44.71/hr

$32.08 - $60

Employment Requirements

These are the education, training, and certification standards usually required by Canadian employers for this occupation:

A bachelor's degree or college program, usually in computer science, computer engineering, or in mathematics is usually required.
Computer programming and related experience is usually required.

Official Job Titles for NOC 21223

23 Titles Listed

If your current job title matches any of these official examples, this NOC code is likely the right choice for your Express Entry reference letter:

data administratordata custodiandata dictionary administratordata warehouse analystdatabase administrator (DBA)database analystdatabase architecttechnical architect - databasedata analyst - informatics and systemsdata management specialistdata processing specialistdata quality analystdata stewarddatabase designerdatabase developerdatabase management supervisor - computer systemsdatabase managerelectronic data processing (EDP) analystelectronic data processing (EDP) specialistelectronic data processing (EDP) systems analystenterprise data architectinformation resource analystInformation technology (IT) data analyst

Exclusions (Similar Jobs with Different Codes)

Check this list to make sure your actual job is not classified under one of these related codes:

Computer and information systems managers (See 20012 Computer and information systems managers)View NOC 20012→
Computer engineers (except software engineers and designers) (See 21311 Computer engineers (except software engineers and designers))View NOC 21311→
Computer systems developers and programmers (See 21230 Computer systems developers and programmers)View NOC 21230→
Information systems specialists (See 21222 Information systems specialists)View NOC 21222→
Software developers and programmers (See 21232 Software developers and programmers)View NOC 21232→
Software engineers and designers (See 21231 Software engineers and designers)View NOC 21231→

Frequently Asked Questions for NOC 21223 (Database analysts and data administrators)

Essential answers regarding Express Entry eligibility, LMIA prevailing wage compliance, and official reference letter rules.

Yes. Because NOC 21223 is classified as TEER 1, it qualifies for the Federal Skilled Worker Program (FSW) and Canadian Experience Class (CEC) under Express Entry.

For an LMIA work permit, your employer must offer at least the median wage of $40.87/hr (or the prevailing median rate in your specific Canadian province of employment).

Under Section 75(2) of the Immigration and Refugee Protection Regulations (IRPR), your employment reference letter must confirm you perform the actions in the lead statement and a substantial number (recommended at least 60%) of the official main duties listed above. You do not need to perform 100% of the duties.

Under Canada's previous NOC 2016 classification, Database analysts and data administrators was categorized under NOC 2172 (Database analysts and data administrators). In NOC 2021, it transitioned to NOC 21223 under TEER 1.

According to official ESDC Job Bank benchmarks, the prevailing median rate for NOC 21223 is $43.44/hr in Montréal, $42.05/hr in Ottawa, $44.47/hr in Toronto, $44.06/hr in Calgary, $45.8/hr in Edmonton.

Generally no. While provincial associations (like PEO in Ontario or EGBC in British Columbia) protect the title 'Engineer', IRCC evaluates immigration eligibility based on your actual job duties and university degrees rather than provincial P.Eng licensure.

Topic Cluster • Natural and Applied Sciences (Tech & Engineering)

Related Occupations & Alternative Career Codes

Browse All 516 NOCs→

If your daily responsibilities for Database analysts and data administrators overlap with other roles, compare duties and prevailing salaries across these closely related NOC codes:

NOC 21222

TEER 1 STEM

Information systems specialists

Information systems specialists analyze, test and assess systems requirements, develop and implement information systems development plans, policies and procedures, and provide advice on a wide range of information systems issues. They are employed in information technology consulting firms and in information technology units throughout the public and private sectors, or they may be self-employed.

Median Pay$46.15/hr

Duties→

NOC 21221

TEER 1 STEM

Business systems specialists

Business systems specialists perform detailed system tests, produce reports and develop new system architectures. They must also identify the strategic objectives of a company and translate these objectives into achievable tasks for an organization's information technology department. They are employed in information technology consulting firms and in information technology units throughout the public and private sectors.

Median Pay$45.13/hr

Duties→

NOC 21220

TEER 1 STEM

Cybersecurity specialists

Cybersecurity specialists develop, plan, recommend, implement, improve and monitor security measures to protect an organization's computer networks, connected devices and information to prevent unauthorized access, use, disclosure, disruption, modification, or destruction of the information or of the systems on which the information resides. They are employed in information technology consulting firms and in information technology units throughout the public and private sectors.

Median Pay$49.52/hr

Duties→

NOC 21230

TEER 1 STEM

Computer systems developers and programmers

Computer systems developers and programmers write, modify, integrate and test computer code for software applications, data processing applications, operating systems-level software and communications software. They are employed in computer software development firms, information technology consulting firms, and in information technology units throughout the public and private sectors.

Median Pay$43.27/hr

Engineering managers plan, organize, direct, control and evaluate the activities of an engineering department, service or firm. They are employed by a wide range of private sector and government establishments and by consulting engineering and scientific research companies.

Median Pay$71.79/hr

Duties→

NOC 20011

TEER 0

Architecture and science managers

Architecture and science managers plan, organize, direct, control and evaluate the activities of an architecture, landscape architecture, scientific or statistical department, service or firm. They are employed by a wide range of private sector and government establishments as well as by architectural firms and scientific research companies.

Median Pay$62.56/hr

Duties→

Next Steps for NOC 21223

Check Your Express Entry Score & Latest Cutoffs

Calculate your exact Comprehensive Ranking System (CRS) score for NOC 21223, explore your TEER 1 immigration pathways, and check recent draw cutoffs.

Calculate CRS Score →View Draw Trends →TEER 1 Guide →

NOC data: Statistics Canada NOC 2021 v1.0

Wages: ESDC Job Bank 2025/2026 Open Data

·Last verified: September 2026