Database analysts and data administrators (NOC 2172)

About this job

Database analysts and data administrators:

  • design, develop and carry out data management solutions using database management software
  • develop and put into use data administration policy, standards and models
  • work for information technology consulting firms and in information technology units throughout the private and public sectors
Common job titles
  • analyst, data - informatics and systems
  • analyst, data warehouse / database (DBA)
  • analyst, information resource
  • data miner / mining analyst
  • DBA (database admin / analyst / architect)
  • specialist, EDP (electronic data procss'g)
  • analyst, data - informatics and systems
  • analyst, data warehouse / database (DBA)
  • analyst, information resource
  • architect, technical - database (DBA)
  • custodian, data
  • data miner / mining analyst

Duties

Database analysts:

  • collect and record user's requirements
  • design and develop database architecture for information systems projects
  • design, construct, modify, integrate, implement and test data models and database management systems
  • carry out research and provide advice to other information systems professionals regarding the selection and use of database management tools
  • operate database management systems to analyze data and perform data mining analysis.
  • lead, coordinate or supervise other workers in this group

Data administrators:

  • develop and put into use data administration policy, standards and models
  • research and record 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
  • carry out 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
  • lead and coordinate teams of data administrators in the development and implementation of data policies, standards and models

Work environment

Work in this occupation is typically performed in a structured environment, such as an office, hospital or school.

Career paths and resources

Career paths

With experience mobility may be possible between specializations in this group, to other fields of physical science, or to management or regulatory program management.

Additional resources

Additional resources are not currently available for this career.