NOC 21223: Database analysts and data administrators
What database analysts and data administrators do
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.
Job titles under NOC 21223
23 job titles are classified here, including data administrator, data custodian, data dictionary administrator.
- data administrator
- data analyst - informatics and systems
- data custodian
- data dictionary administrator
- data management specialist
- data processing specialist
- data quality analyst
- data steward
- data warehouse analyst
- database administrator (DBA)
- database analyst
- database architect
- database designer
- database developer
- database management supervisor - computer systems
- database manager
- electronic data processing (EDP) analyst
- electronic data processing (EDP) specialist
- electronic data processing (EDP) systems analyst
- enterprise data architect
- information resource analyst
- Information technology (IT) data analyst
- technical architect - database
Employment requirements
- 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.
Database analysts and data administrators wages in Canada
Low, median and high hourly wages from Job Bank’s 2025 wage data. Annual figures assume full-time work (1,950 hours a year).
| Where | Low | Median | High |
|---|---|---|---|
Canada | $25.00/hr | $40.87/hr | $61.03/hr |
Toronto ON | $21.90/hr | $44.47/hr | $67.45/hr |
Montréal QC | $27.21/hr | $42.77/hr | $72.98/hr |
Vancouver Lower Mainland region, BC | $32.08/hr | $44.71/hr | $60.00/hr |
Calgary AB | $28.57/hr | $44.06/hr | $67.91/hr |
Edmonton AB | $33.00/hr | $45.80/hr | $60.58/hr |
Ottawa ON | $24.73/hr | $42.05/hr | $61.54/hr |
Winnipeg MB | $31.25/hr | $41.00/hr | $47.12/hr |
Québec City Quebec region, QC | $22.00/hr | $43.96/hr | $55.00/hr |
Hamilton Hamilton–Niagara Peninsula region, ON | $24.58/hr | $40.87/hr | $61.54/hr |
Kitchener-Waterloo Kitchener–Waterloo–Barrie region, ON | $27.16/hr | $43.78/hr | $65.22/hr |
London ON | $22.00/hr | $40.40/hr | $58.00/hr |
Victoria Vancouver Island and Coast region, BC | $28.75/hr | $43.96/hr | $60.00/hr |
Saskatoon Saskatoon–Biggar region, SK | $29.40/hr | $41.12/hr | $58.93/hr |
Regina Regina–Moose Mountain region, SK | $26.00/hr | $40.86/hr | $61.03/hr |
| Where | Low | Median | High |
|---|---|---|---|
Newfoundland and Labrador | $24.04/hr | $45.08/hr | $68.66/hr |
Nova Scotia | $20.00/hr | $33.65/hr | $76.92/hr |
New Brunswick | $26.92/hr | $40.87/hr | $51.28/hr |
Quebec | $22.00/hr | $43.96/hr | $55.00/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.00/hr |
Using NOC 21223 for your resume or Express Entry profile
- IRCC asks you to make sure the main duties listed for your NOC match what you actually did at your job. If they don’t, look for another unit group whose duties do.
- Describe your own work in your own words. Recruiters and ATS software look for concrete tools, results and scope, not text copied from the NOC.
- Applying from outside Canada? Run your resume through the Canadian resume format checker to catch things Canadian employers don’t expect, like a photo or date of birth.
- Use the job title the employer’s posting uses. The 23 titles above are how the same work is named across employers.
Not in this group
Similar jobs classified under a different NOC code:
- Computer and information systems managers (NOC 20012)
- Computer engineers (except software engineers and designers) (NOC 21311)
- Computer systems developers and programmers (NOC 21230)
- Information systems specialists (NOC 21222)
- Software developers and programmers (NOC 21232)
- Software engineers and designers (NOC 21231)
Frequently asked questions
What is the NOC code for database analysts and data administrators?
Database analysts and data administrators are NOC 2021 unit group 21223. Example job titles in this group include data administrator, data custodian, data dictionary administrator, data warehouse analyst.
What TEER is NOC 21223?
NOC 21223 is TEER 1 (University degree). Usually requires a university degree (bachelor’s, master’s or doctorate), or experience from a related TEER 2 occupation. TEER 0, 1, 2 and 3 work counts as skilled work experience for Express Entry’s Federal Skilled Worker and Canadian Experience Class programs.
How much do database analysts and data administrators earn in Canada?
Job Bank's 2025 wage data puts the median at $40.87/hr, about $80,000 a year full-time, with a range of $25.00/hr to $61.03/hr.
Related occupations
Sources: Statistics Canada, National Occupational Classification (NOC) 2021 Version 1.0; Employment and Social Development Canada, Job Bank wages (2025). Contains information licensed under the Open Government Licence – Canada. OfferJetAI is not affiliated with the Government of Canada. Check IRCC’s NOC guidance before you apply.