Database analysts and data administrators

About this job

Database analysts and data administrators:

design, develop and carry out data management solutions using database management software
develop and put into use data administration policy, standards and models
work for information technology consulting firms and in information technology units throughout the private and public sectors

Common job titles

analyst, data - informatics and systems
analyst, data warehouse / database (DBA)
analyst, information resource

architect, technical - database (DBA)
custodian, data

data miner / mining analyst
DBA (database admin / analyst / architect)
specialist, EDP (electronic data procss'g)

supervisor, computer database management

analyst, data - informatics and systems
analyst, data warehouse / database (DBA)
analyst, information resource
architect, technical - database (DBA)
custodian, data
data miner / mining analyst

DBA (database admin / analyst / architect)
specialist, EDP (electronic data procss'g)
supervisor, computer database management

Earnings

Annual provincial median salary

$65,175

Source: 2017 Job Bank Wage data

Note:Estimated median employment income based on 2017 Job Bank median hourly wage rate (median annual salary = hourly wage rate x 40 (hours per week) x 52.14 (weeks per year))

Provincial hourly rate

High
Median
Low

Source: 2017 Job Bank Wage Report

B.C. Labour Market Outlook (2018-2028)

Provincial outlook

Forecasted average employment growth rate

2018 - 2023
2023 - 2028

Source: B.C. Labour Market Outlook

Job openings

10 year expected job openings: 960

2018
2023
2028

Source: B.C. Labour Market Outlook

Composition of job openings

New jobs due to economic growth:
47.9%
460 openings

Replacement of retiring workers:
52.1%
500 openings

Source: B.C. Labour Market Outlook

Regional outlook

Cariboo

Employment in 2018:

50

Average annual employment growth:

0.7%

Expected number of job openings:

10

Kootenay

Employment in 2018:

20

Average annual employment growth:

3.9%

Expected number of job openings:

20

Mainland / Southwest

Employment in 2018:

1,770

Average annual employment growth:

1.7%

Expected number of job openings:

690

North Coast & Nechako

Employment in 2018:

N/A

Average annual employment growth:

N/A

Expected number of job openings:

N/A

Northeast

Employment in 2018:

N/A

Average annual employment growth:

N/A

Expected number of job openings:

N/A

Thompson-Okanagan

Employment in 2018:

120

Average annual employment growth:

1.3%

Expected number of job openings:

40

Vancouver Island / Coast

Employment in 2018:

460

Average annual employment growth:

1.7%

Expected number of job openings:

200

N/A - Data not available

Source: B.C. Labour Market Outlook

Duties

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 environment

Work in this occupation is typically performed in a structured environment, such as an office, hospital or school.

Workforce and employment statistics

Workforce characteristics

2,200 workers are employed

72% of workers are working mostly full time

Source: 2016 Census

Employment by gender

Men

Women

Source: 2016 Census

Employment by age group

15 - 24 years

25 - 44 years

45 - 64 years

65+ years

Source: 2016 Census

Labour force by industry

Professional, Scientific, and Technical Services:

32%

Information, Culture and Recreation:

14%

Public Administration:

14%

Finance, Insurance and Real Estate:

9%

Health Care and Social Assistance:

7%

View more industry data

Source: 2016 Census

Employment by region

% employment of this occupation

% employment of all occupations

Cariboo

Kootenay

Mainland / Southwest

North Coast & Nechako

Northeast

Thompson-Okanagan

Vancouver Island / Coast

Source: 2016 Census

Job requirements

Education, training & qualifications

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.

Skills

Spatial Perception
Innovative
Numerical Ability
Detail-Oriented
Finger Dexterity

View skills definitions

Education programs in B.C.

The following program areas are related to this occupation:

Computer Information Systems/Science
Computing Science/Systems Related
Information Technology Management

Math/Statistics (Science)
Math/Statistics Related (Arts)
Web Technologies

For more information about programs offered specifically for this career, visit EducationPlannerBC.

Related careers

Career paths and resources

Career paths

With experience mobility may be possible between specializations in this group, to other fields of physical science, or to management or regulatory program management.

Additional resources

Additional resources are not currently available for this career.

Database analysts and data administrators (NOC 2172)

About this job

Earnings

Annual provincial median salary

Provincial hourly rate

B.C. Labour Market Outlook (2018-2028)

Provincial outlook

Forecasted average employment growth rate

Job openings

Composition of job openings

Regional outlook

Duties

Work environment

Workforce and employment statistics

Workforce characteristics

Employment by gender

Employment by age group

Labour force by industry

Employment by region

Job requirements

Education, training & qualifications

Skills

Education programs in B.C.

Related careers

Career paths and resources

Database Administrator

Database Analyst

Data Warehouse Automation Architect / WhereScape Consultant