2161-NOC

Database analysts and data administrators

(NOC 21223)
High opportunity occupation High opportunity occupation
Annual Earnings
$79,253
Training, Education, Experience and Responsibilities
University Degree
Job Openings
(2023-2033)
1,360

Career Overview

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

 

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

 

Earnings

Earnings is income that workers receive in exchange for their labour. Depending on the type of employment, earnings can be in the form of wages (hourly), salaries (fixed monthly or annual) or self-employed earnings.

Annual Earnings

$79,253

Provincial Hourly Rate

High$57.69/hr
Median$38.00/hr
Low$21.88/hr
Source: B.C. Labour Market Information Office, derived from 2023 Job Bank Wage data

Work Environment

# Workers Employed

2,400

% Employed Full Time

79%
Source: 2021 Census

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

Career Pathways

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

Occupational Interests

It’s important to understand what kinds of occupations align with your interests.

For more about occupational interests visit Skills for the Future Workforce > Characteristics.

Here are the top occupational interest(s) for this career profile:

Investigative
Investigative
Conventional
Conventional

Job Titles

Data administrator
Data custodian
Data dictionary administrator
Data warehouse analyst
Database administrator (DBA)
Database analyst
Database architect
Technical architect - database

Education, Training and Skills

  • 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

 

Education programs in B.C.

The following program areas are related to this occupation:

  • Computer Information Systems/Science
  • Math/Statistics Related (Arts)
  • Computing Science/Systems Related
  • Math/Statistics (Science)
  • Information Technology Management
  • Web Technologies
EducationPlannerBC Logo
Find out more information about programs offered specifically for this career.

Skills

Every job calls for a certain set of skills. Knowing those skills is the first step in finding a good career fit.

Here, you will find the 10 most relevant workplace skills. Some are more important to achieving success in a certain career than others. These skills may come naturally to you or you may need to gain them through education, training and experience.

See the list of work-related skills below, ranked in order of importance for this career. Check out the list and see if this career matches your skills—take that first step!

Critical Thinking

Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.

73%
Reading Comprehension

Understanding written sentences and paragraphs in work-related documents.

69%
Active Listening

Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.

66%
Speaking

Talking to others to share information effectively.

65%
Complex Problem Solving

Being able to solve novel, ill-defined problems in complex, real-world settings.

63%
Writing

Communicating effectively in writing as appropriate for the needs of the audience.

62%
Judgment and Decision Making

Considering the relative costs and benefits of potential actions to choose the most appropriate one.

61%
Systems Analysis

Determining how a system should work and how changes in conditions, operations and the environment will affect outcomes.

60%
Active Learning

Understanding how new information could be used to solve current and future problems in making decisions.

59%
Monitoring

Keeping track of and assessing your performance, other individuals, or organizations to make improvements or take corrective action.

56%

Labour Market Statistics

Discover data, facts and information that have been gathered and analyzed. Learn about the characteristics of the economy and labour market in B.C.

Employment

Find out about employment types and trends by region and industry.

Employment

2,400
Source: 2021 Census

Employment by Region

Map of BC Map of BC highlighting Cariboo region Map of BC highlighting Kootenay region Map of BC highlighting Mainland/Southwest region Map of BC highlighting North Coast and Nechako region Map of BC highlighting Northeast region Map of BC highlighting Thompson-Okanagan region Map of BC highlighting Vancouver Island/Coast region
Cariboo
Kootenay
Mainland/Southwest
North Coast and Nechako
Northeast
Thompson-Okanagan
Vancouver Island/Coast
Region Employment % Employment of this Occupation
Cariboo 0 0.0%
Kootenay 15 0.6%
Mainland/Southwest 1,715 71.5%
North Coast and Nechako 10 0.4%
Northeast 0 0.0%
Thompson-Okanagan 135 5.6%
Vancouver Island/Coast 510 21.2%
Source: 2021 Census

Labour Market Outlook

The B.C. Labour Market Outlook is a 10-year forecast of the expected supply and demand for labour in the province. It’s usually updated every year. The purpose is to provide British Columbians with the knowledge to make informed decisions on careers, skills training, education and hiring.

Forecasted Job Openings (2023-2033)

1,360
Source: B.C. Labour Market Outlook

Forecasted Job Openings

Forecasted Employment Growth Rate

Composition of Job Openings

Source: B.C. Labour Market Outlook

Job Openings by Region (2023-2033)

Map of BC Map of BC highlighting Cariboo region Map of BC highlighting Kootenay region Map of BC highlighting Mainland/Southwest region Map of BC highlighting North Coast and Nechako region Map of BC highlighting Northeast region Map of BC highlighting Thompson-Okanagan region Map of BC highlighting Vancouver Island/Coast region
Cariboo
Kootenay
Mainland/Southwest
North Coast and Nechako
Northeast
Thompson-Okanagan
Vancouver Island/Coast
Region Job Openings Avg. Annual Employment Growth
Cariboo Not available Not available
Kootenay Not available Not available
Mainland/Southwest 990 2.0%
North Coast and Nechako Not available Not available
Northeast Not available Not available
Thompson-Okanagan 70 2.0%
Vancouver Island/Coast 300 2.1%
Source: B.C. Labour Market Outlook

Industry Highlights

Learn about the opportunities in B.C.'s major industries, including employment trends, earning potential, locations of work and more.

Forecasted Job Openings by Industry

IndustryJob Openings (2023-2033)
Professional, Scientific And Technical Services720
Public Administration150
Information, Culture And Recreation80
Educational Services60
Retail Trade60
For additional industry information, visit the Industry Profiles page.
Source: B.C. Labour Market Outlook

Resources

Resource information is currently not available.