Database analysts and data administrators (NOC 2172)

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 in this occupation is typically performed in a structured environment, such as an office, hospital or school.