21223 - Database Analysts and Data Administrators
Broad Occupation Category
2 - Natural and applied sciences and related occupations.
TEER
1 - Occupations usually require a university degree.
Major Group
21 - Professional occupations in natural and applied sciences.
Sub-major Group
212 - Professional occupations in applied sciences (except engineering).
Minor Group
2122 - Computer and information systems professionals.
Main Duties
Database Analysts and Data Administrators perform some or all of the following duties:
- Collect and document user requirements
- Design and develop database architectures
- Build and test data models and DBMS platforms
- Provide technical guidance on database tools
- Operate systems for analytics and data mining
- Supervise junior database staff
- Develop data governance policies and standards
- Define security, access, and retention frameworks
- Establish backup and disaster recovery protocols
- Advise IT teams on data availability and compliance
- Write stored procedure and trigger scripts
- Lead data administration teams
Employment Requirements
These are the typical employment requirements and benefits associated with this occupation in Canada:
- A bachelor's degree or college diploma in computer science, engineering, mathematics, or a related field is usually required.
- Programming experience is typically required.
- Practical experience managing enterprise-scale databases is usually expected.
- Many employers offer health benefits, pension contributions, paid leave, training support, and professional development opportunities.
Database Analysts and Data Administrators Salary Prospects
Community/Area
Low ($/hour)
Median ($/hour)
High ($/hour)
Community/AreaCanada
Low ($/hour)25.38
Median ($/hour)42.36
High ($/hour)61.54
Community/AreaAlberta
Low ($/hour)33.33
Median ($/hour)44.23
High ($/hour)60.58
Community/AreaBritish Columbia
Low ($/hour)26.97
Median ($/hour)43.96
High ($/hour)69.23
Community/AreaManitoba
Low ($/hour)30.77
Median ($/hour)38.94
High ($/hour)57.69
Community/AreaNew Brunswick
Low ($/hour)26.00
Median ($/hour)36.88
High ($/hour)46.15
Community/AreaNewfoundland and Labrador
Low ($/hour)29.81
Median ($/hour)47.26
High ($/hour)68.66
Community/AreaNova Scotia
Low ($/hour)20.00
Median ($/hour)32.00
High ($/hour)52.88
Community/AreaOntario
Low ($/hour)25.38
Median ($/hour)43.27
High ($/hour)62.50
Community/AreaPrince Edward Island
Low ($/hour)18.00
Median ($/hour)32.55
High ($/hour)49.23
Community/AreaQuebec
Low ($/hour)26.00
Median ($/hour)42.05
High ($/hour)54.30
Community/AreaSaskatchewan
Low ($/hour)25.48
Median ($/hour)40.00
High ($/hour)61.03
