View unit group
- Version:
- NOC 2016 Version 1.3
Search
Search by job title
Search by NOC code
2172 – Database analysts and data administrators
Database analysts design, develop and administer data management solutions using database management software. 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 private and public sectors.
Profile
Example titles
- Data administrator
- Data custodian
- Data dictionary administrator
- Data warehouse analyst
- Database administrator (DBA)
- Database analyst
- Database architect
- Technical architect - database
Main duties
This group performs some or all of the following 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, co-ordinate 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 co-ordinate teams of data administrators in the development and implementation of data policies, standards and models.
Database analysts
Data administrators
Employment requirements
- A bachelor's degree, usually in computer science or in mathematics or completion of a college program in computer science is usually required.
- Computer programming experience is usually required.
Additional information
Exclusions
- Computer and information systems managers (0213)
- Computer engineers (except software engineers and designers) (2147)
- Computer programmers and interactive media developers (2174)
- Information systems analysts and consultants (2171)
- Software engineers and designers (2173)
- Web designers and developers (2175)
Breakdown summary
- Broad occupational category
- 2 – Natural and applied sciences and related occupations
- Skill level
- A – Occupations usually require university education.
- Major group
- 21 – Professional occupations in natural and applied sciences
- Minor group
- 217 – Computer and information systems professionals
- Associated Career Handbook profiles
- 2172.1 – Database analysts 2172.2 – Data administrators
- Version
- NOC 2016 Version 1.3