Database Analysts and Data Administrators

(NOC 2172)

Career Description

Database analysts design, develop and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards and models.

Duties May Include

Database analysts

  • 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

  • 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.

Examples of Titles

Data administrator
Data custodian
Data dictionary administrator
Data warehouse analyst
Database administrator (DBA)
Database analyst
Database architect
Technical architect - database

Here are some schools that have programs related to this career:

Carleton University
Ottawa, Ontario, CA

Related Program(s):
Business Analytics Bachelor; Co-op
Request Info
Wilfrid Laurier University
Waterloo, Ontario, CA

Related Program(s):
Economics and Data Analytics (BA) Bachelor; Co-op; Honours
Request Info
view all
Modified on April 07, 2022