Database analysts and data administrators – NOC : 2172

Unit Group

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.

Example Titles

data administrator

data custodian

data dictionary administrator

data warehouse analyst

database administrator (DBA)

database analyst

database architect

technical architect – database

View all titles

Main duties

Database analysts perform 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.
Data administrators perform some or all of the following duties:
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.

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.

Classified elsewhere

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)