Database analysts and data administrators (NOC 2172)

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
  • data miner / mining analyst
  • DBA (database admin / analyst / architect)
  • specialist, EDP (electronic data procss'g)
  • analyst, data - informatics and systems
  • analyst, data warehouse / database (DBA)
  • analyst, information resource
  • architect, technical - database (DBA)
  • custodian, data
  • data miner / mining analyst

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

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.

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.

Select a region to view regional outlook
Vancouver Island / Coast Mainland / Southwest Thompson-Okanagan Kootenay Cariboo Northeast North Coast & Nechako
Cariboo
Employment in 2016:
0
Average annual employment growth:
N/A
Expected number of job openings:
N/A
Kootenay
Employment in 2016:
0
Average annual employment growth:
N/A
Expected number of job openings:
N/A
Mainland / Southwest
Employment in 2016:
1,150
Average annual employment growth:
2.0%
Expected number of job openings:
590
North Coast & Nechako
Employment in 2016:
0
Average annual employment growth:
N/A
Expected number of job openings:
N/A
Northeast
Employment in 2016:
0
Average annual employment growth:
N/A
Expected number of job openings:
N/A
Thompson-Okanagan
Employment in 2016:
50
Average annual employment growth:
N/A
Expected number of job openings:
N/A
Vancouver Island / Coast
Employment in 2016:
250
Average annual employment growth:
1.5%
Expected number of job openings:
120

N/A - Data not available

Source: B.C. Labour Market Outlook

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.