Database analysts and data administrators

Database analysts and data administrators

NOC
2172

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

Quick facts

3 Year Outlook

Good
Good

3 Year Job Openings

32
 

Median Hourly Wage

$34.87
$21.63
Low
$48.72
High

Median Salary

$69,365
 

Typically Required

University

Employed

294
 

% Working Full Time

98%
 

% Working Full Year

88%
 
Job details

Full NOC Description

Database analysts design, develop and administer data management solutions using database management software. 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.

Main Duties

Database analysts and data administrators perform 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, co-ordinate 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 co-ordinate 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, usually in computer science or in mathematics or Completion of a college program in computer science is usually required.
  • Computer programming 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

33.5%
Female
66.5%
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

3.4%
15-24
22.0%
25-34
25.4%
35-44
28.8%
45-54
16.9%
55-64
3.4%
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
12.3%
High School, Diploma or Equivalent
0.0%
Apprenticeship or Trades Certificate or Diploma
31.6%
College or University Below Bachelor Level
56.1%
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

25.0%
Professional, scientific and technical services
23.3%
Public administration
18.3%
Information and cultural industries
33.3%
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.20%
Northeast
27.10%
Southeast
28.80%
Southwest
30.50%
Central
3.40%
Northwest
Province of New Brunswick Economic Regions

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 Median Salary by Economic Regions

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

Data legend

N/A
Northeast
$69,458
Southeast
$80,313
Southwest
$59,793
Central
N/A
Northwest
Province of New Brunswick Economic Regions

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.

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

This following represents the median salary of all persons employed in this occupation compared to the median salary of workers employed in this occupation that work full-time year-round.

All Workers Employed in this Occupation

$69,365

Workers Employed Full-time, Full-year

$75,057

This following represents the median salary of persons employed in this occupation across each of the Atlantic Provinces and nationally.

New Brunswick

$69,365

Newfoundland

$67,678

Prince Edward Island

$55,644

Nova Scotia

$65,742

Canada

$73,204
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).

Three Year Outlook

Total Openings: 3 Year

32
 

New Jobs: 3 Year

1
 

Retirements/Deaths: 3 Year

32
 

Ten Year Outlook

Total Openings: 10 Year

101
 

New Jobs: 10 Year

-1
 

Retirements/Deaths: 10 Year

102