Database analysts and data administrators

NOC

21223

Database analysts design, develop and maintain database management systems. Data administrators develop and implement data administration policy, standards and models.

Compare

View Snapshot

Full NOC Description

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.

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.

Also Known As

data administrator
data custodian
data dictionary administrator
data warehouse analyst
database administrator (DBA)

database analyst

database architect

technical architect - database

Requirements

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.

Provincial Regulation

Not Provincially Regulated

Employment by Sex

The following graph shows the percentage of men and women working in this occupation in New Brunswick.

Data legend

40.0%

Female

60.0%

Male

Employment by age

The following graph shows the breakdown of all persons working in this occupation in New Brunswick by age group.

Data legend

0.0%

15-24

18.5%

25-34

27.8%

35-44

27.8%

45-54

25.9%

55-64

0.0%

65+

Employment by highest level of education

The following graph shows the breakdown of all persons working in this occupation in New Brunswick by highest level of education achieved.

Data legend

0.0%

No Certificate, Diploma or Degree

16.4%

High School, Diploma or Equivalent

0.0%

Apprenticeship or Trades Certificate or Diploma

30.9%

College or University Below Bachelor Level

52.7%

University - Bachelor Level or Above

Employment by Industry

The following graph shows the industry groups in which the largest shares of persons working in this occupation in New Brunswick are employed. Small percentages for all top three industry groups may suggest employment for this occupation is widely distributed amongst many industry groups.

Data legend

30.9%

Public administration

25.5%

Professional, scientific and technical services

9.1%

Manufacturing

34.5%

All Other Industries

Employment by Economic Regions

The following graph shows the breakdown of all persons employed in this occupation in New Brunswick by which economic region they reside in.

Data legend

10.90%

Northeast

34.50%

Southeast

18.20%

Southwest

30.90%

Central

5.50%

Northwest

Economic Regions

The following map displays New Brunswick’s five economic regions. An economic region (ER) is a grouping of counties, created as a standard unit for analysis of regional economic activity across Canada.

Annual Average Salary by Economic Regions

The following graph shows the average salary of all persons employed in this occupation in each of New Brunswick’s five economic regions.

Data legend

$68,000

Northeast

$90,000

Southeast

$84,000

Southwest

$73,000

Central

N/A

Northwest

Economic Regions

Hourly Median Wages by Economic Regions

The following represents the median hourly wage of all persons employed in this occupation in each of New Brunswick’s five economic regions.

No Data Available

Salary

The following shows the average salary of everyone who worked full-time and year-round in this occupation across each of the Atlantic Provinces and nationally.

Employment Outlook

The following represents the number of job openings that are expected to occur in this occupation over the next three and ten years respectively, broken down by openings expected to result from growth (“new jobs”) and openings expected to result from attrition (death and retirements).

Occupational Profiles