21223 Database analysts and data administrators

What this occupation covers

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 public and private sectors.

Official main duties

The NOC profile lists 12 main duties for this code.

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

Do not copy these lines into your reference letter. The letter has to describe what you actually did, in your employer’s words. DUTYPROOF flags wording lifted from the NOC as something to review, and an officer reading a letter that mirrors the NOC reads it the same way.

What DUTYPROOF screens for

This is DUTYPROOF’s screening threshold, not IRCC’s decision. For this NOC, screening requires at least 2 of its 12 official duties to be evidenced in your own words, plus the required letter elements. IRCC asks that you performed the actions in the occupation’s lead statement and a substantial number of its main duties — so treat the duty coverage as the number that matters, not the badge.

Codes this one is confused with

The NOC profile names these itself. Choosing the wrong code of a look-alike pair is the most common way genuine work experience fails to establish eligibility.

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

Excluded from this code

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

Job titles filed under this code

A title on this list does not by itself put your experience in this code — the duties in your letter decide that.

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

Employment requirements

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