21223 – Database analysts and data administrators
This occupation is on IRCC's Express Entry high-wage list (median wage at least 1.5 times the average median wage). From November 3, 2026, 12 months of qualifying Canadian work experience in it can add 40 CRS points, or a qualifying job offer in it can earn 70 points. Only the higher of the two counts, not both.
Lead statement
Database analysts design, develop and administer data management solutions.
Main duties
- 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.
Employment requirements
- 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.
Example job titles
database analyst · information technology (IT) data analyst · database designer · information resource analyst · electronic data processing (EDP) specialist · data quality analyst · database architect · data management specialist · database administrator (DBA) · data administrator · data custodian
Wages (per hour)
| Province / territory | Low | Median | High |
|---|---|---|---|
| Canada | $25.00 | $40.87 | $61.03 |
| Newfoundland and Labrador | $24.04 | $45.08 | $68.66 |
| Nova Scotia | $20.00 | $33.65 | $76.92 |
| New Brunswick | $26.92 | $40.87 | $51.28 |
| Quebec | $22.00 | $43.96 | $55.00 |
| Ontario | $24.58 | $40.87 | $61.54 |
| Manitoba | $31.25 | $38.94 | $47.12 |
| Saskatchewan | $25.34 | $38.46 | $61.03 |
| Alberta | $28.27 | $39.82 | $60.58 |
| British Columbia | $28.75 | $43.96 | $60.00 |
Source: Job Bank wages, 2025 release (ESDC). Low and high are the 10th and 90th percentiles.
Occupation details: ESDC OaSIS 2025, based on NOC 2021.