21223 – Database analysts and data administrators
TEER 1Occupations usually requiring a university degree
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.