21223 – Database analysts and data administrators

 

 

21223 – Database analysts and data administrators
Database analysts design, develop and administer data management solutions. 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
Index of titles
Data administrator
Data analyst - informatics and systems
Data custodian
Data dictionary administrator
Data management specialist
Data processing specialist
Data quality analyst
Data steward
Data warehouse analyst
Database administrator (DBA)
Database analyst
Database architect
Database designer
Database developer
Database management supervisor - computer systems
Database manager
Electronic data processing (EDP) analyst
Electronic data processing (EDP) specialist
Electronic data processing (EDP) systems analyst
Enterprise data architect
Information resource analyst
Information technology (IT) data analyst
Technical architect - database

 

Main duties
This group performs some or all of the following duties:

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, coordinate 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 coordinate teams of data administrators in the development and implementation of data policies, standards and models.

 

Employment requirements
A bachelor's degree or college program, usually in computer science, computer engineering, or mathematics is usually required.
Computer programming and related experience is usually required.

 

Additional information
 

Exclusions
Computer systems developers and programmers (21230)
Computer and information systems managers (20012)
Information systems specialists (21222)
Software developers and programmers (21232)
Computer engineers (except software engineers and designers) (21311)

 

Link:

https://noc.esdc.gc.ca/Structure/NocProfile?objectid=R0rlzuDnffOXyjUYNvrZmkMiMTk%2BtjoajAqOmZClmnA%3D