2161-NOC

Database analysts and data administrators

(NOC 2172)
High opportunity occupation High opportunity occupation
Annual Earnings
$84,675
Typical Education Background
Degree
Job Openings
(2022-2032)
1,570

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

$84,675

Provincial Hourly Rate

High$60.44/hr
Median$40.60/hr
Low$24.04/hr
Source: B.C. Labour Market Information Office, derived from 2022 Job Bank Wage data

Work Environment

# Workers Employed

2,200

% Employed Full Time

72%
Source: 2016 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:

Conventional
Conventional

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

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.

72%
Complex Problem Solving

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

66%
Reading Comprehension

Understanding written sentences and paragraphs in work-related documents.

63%
Judgment and Decision-Making

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

63%
Active Learning

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

63%
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.

63%
Monitoring

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

60%
Systems Evaluation

Identifying measures or indicators of system performance and the actions needed to improve or correct performance, while meeting the goals of the system.

60%
Programming

Writing computer programs for various purposes.

60%
Speaking

Talking to others to share information effectively.

60%

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,200
Source: 2016 Census

Employment by Region

Map of BC Map of Cariboo region Map of Kootenay region Map of Mainland/Southwest region Map of North Coast and Nechako region Map of Northeast region Map of Thompson-Okanagan region Map of Vancouver Island/Coast region
Cariboo
Kootenay
Mainland/Southwest
North Coast and Nechako
Northeast
Thompson-Okanagan
Vancouver Island/Coast
Map label line
Map label line
Map label line
Map label line
Map label line
Map label line
Map label line
Region Employment (2022) % Employment of this Occupation
Cariboo 50 1.1%
Kootenay 40 0.7%
Mainland/Southwest 2,250 75.1%
North Coast and Nechako N/A 0.7%
Northeast N/A 0.5%
Thompson-Okanagan 150 4.8%
Vancouver Island/Coast 530 17.4%
Source: 2016 Census and B.C. Labour Market Outlook

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 (2022-2032)

1,570
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 (2022-2032)

Map of BC Map of Cariboo region Map of Kootenay region Map of Mainland/Southwest region Map of North Coast and Nechako region Map of Northeast region Map of Thompson-Okanagan region Map of Vancouver Island/Coast region
Cariboo
Kootenay
Mainland/Southwest
North Coast and Nechako
Northeast
Thompson-Okanagan
Vancouver Island/Coast
Map label line
Map label line
Map label line
Map label line
Map label line
Map label line
Map label line
Region Job Openings Avg. Annual Employment Growth
Cariboo 0 1.8%
Kootenay 0 2.3%
Mainland/Southwest 1,170 2.3%
North Coast and Nechako N/A N/A
Northeast N/A N/A
Thompson-Okanagan 90 2.4%
Vancouver Island/Coast 300 2.5%
N/A: Data is not available for this region.
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 (2022-2032)
Professional, Scientific and Technical Services148,000
Information, Culture and Recreation57,300
Public Administration49,200
Finance, insurance and real estate50,900
Health Care and Social Assistance149,700
For additional industry information, visit the Industry Profiles page.
Source: 2016 Census and B.C. Labour Market Outlook

Resources

Resource information is currently not available.