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: 2016 Job Bank Wage data

Note:Estimated median employment income based on 2016 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: 2016 Job Bank Wage Report

B.C. Labour Market Outlook (2017-2027)

Provincial outlook

Forecasted average employment growth rate

2017 - 2022
2022 - 2027

Source: B.C. Labour Market Outlook

Job openings

10 year expected job openings: 760

2017
2022
2027

Source: B.C. Labour Market Outlook

Composition of job openings

New jobs due to economic growth:
41.0%
310 openings

Replacement of retiring workers:
59.0%
450 openings

Source: B.C. Labour Market Outlook

Regional outlook

Cariboo

Employment in 2017:

N/A

Average annual employment growth:

N/A

Expected number of job openings:

N/A

Kootenay

Employment in 2017:

N/A

Average annual employment growth:

N/A

Expected number of job openings:

N/A

Mainland / Southwest

Employment in 2017:

1,190

Average annual employment growth:

2.1%

Expected number of job openings:

630

North Coast & Nechako

Employment in 2017:

N/A

Average annual employment growth:

N/A

Expected number of job openings:

N/A

Northeast

Employment in 2017:

N/A

Average annual employment growth:

N/A

Expected number of job openings:

N/A

Thompson-Okanagan

Employment in 2017:

60

Average annual employment growth:

1.2%

Expected number of job openings:

20

Vancouver Island / Coast

Employment in 2017:

270

Average annual employment growth:

0.9%

Expected number of job openings:

110

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

1,500 workers are employed

62% of workers are working mostly full time

Source: 2011 National Household Survey

Employment by gender

Men

Women

Source: 2011 National Household Survey

Employment by age group

15 - 24 years

25 - 44 years

45 - 64 years

65+ years

Source: 2011 National Household Survey

Labour force by industry

Professional, Scientific, and Technical Services:

27%

Public Administration:

15%

Information, Culture and Recreation:

11%

Wholesale Trade¹:

9%

Retail Trade¹:

9%

View more industry data

Source: 2011 National Household Survey

Note:¹Data represents Wholesale and Retail Trade and will be updated when the 2017 data is available from Statistics Canada.

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: 2011 National Household Survey

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 (2017-2027)

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

Senior Database Administrator

Registrar's Office Functional Analyst