Download PDF

Contents

Database analysts & data administrators (NOC 2172) may also be called:

  • database administrator (DBA)
  • database analyst
  • database architect
  • database designer
  • data dictionary administrator
  • data analyst informatics and systems
  • EDP (electronic data processing) analyst
  • information resource analyst
  • data custodian
  • data warehouse analyst
  • data miner / mining analyst

What Would I Do?

Database analysts design, develop and administer data management solutions using database management software. Their duties may include:

  • 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.

Data administrators develop and implement data administration policy, standards and models. Their duties may include:

  • 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

More information:

Am I Suited For This Job?

Database analysts & data administrators must be:

  • logical
  • creative
  • detail oriented
  • willing to keep up with advances in the field

They must have:

  • strong communication skills

Most database analysts & data administrators spend much of their time on computers and may be at risk of neck and back strain. They work mainly in offices, alone or as part of a team and usually work a regular five day week.

Sources: WorkBC Career Profile for Database Analysts & Data Administrators,  Career Cruising database (Profile for ‘Database developer’).

What Are The Wages And Benefits?

WorkBC reports that the median annual salary for Database Analysts & Data Administrators in British Columbia is approximately $64,654 with a $31.00 median hourly wage rate across the province. JobBank Canada lists hourly wages for BC’s regions where Database Analysts & Data Administrators can expect to make:

Regional Hourly Wages for Database Analysts & Data Administrators

Table from Job Bank Canada Wage Report

Database analysts & data administrators who find permanent full-time positions typically receive benefits in addition to their salaries. Benefits often include dental coverage and paid vacation and sick leave.

Sources: WorkBC Career Profile for Database analysts & data administratorsCareer Cruising database (Profile for ‘Database developer’).

What Is The Job Outlook In BC?

WorkBC reports that for the period 2015-2025, the expected annual demand growth rate for database analysts & data administrators will be 1.8% across the province, with largest growth in these regions:

  • Lower Mainland & Southwest (2.0% annual employment growth and total 590 job openings from 2015-2025
  • Vancouver Island Coast (1.5% annual employment growth and total of 120 job openings from 2015-2025)

job outlook for database analysts & data administrators

JobBank Canada reports that for the 2015-2017 period, the employment outlook is expected to be ‘good’ for Database Analysts & Data Administrators (NOC 2172) in British Columbia. Employment growth is expected to be strong and a moderate number of people are expected to retire.

Sources: WorkBC Career Profile for Database Analysts & Data Administrators, JobBank Canada, Employment Outlook

How Do I Become a Database Analyst or Data Administrator?

In BC, there is no certification/licensing required to be a Database Analyst or Data Administrator. However, a bachelor’s degree, usually in computer science or in mathematics is required, or completion of a college program in computer science. Computer programming experience is also a requirement. You should have a solid knowledge base in relational database theory, computer operating system software, programming languages, and the skills and tools needed for database maintenance.

Voluntary certification is available through CIPS (Canada’s Association of I.T. Professionals) in three categories: Associate Information Technology Professional (AITP), Information Systems Professional (I.S.P.), and Information Technology Certified Professional (ITCP).

Sources: WorkBC Career Profile for Database analysts & data administratorsCareer Cruising database (Profile for ‘Database developer’).

How Do I Find A Job?

Where would I work?

Database analysts & data administrators work in:

  • information technology consulting firms
  • information technology units throughout the private and public sectors
  • governments, universities, banks, and other large organizations that use databases

Finding Advertised Jobs

Jobs are advertised in a variety of sources including newspapers, magazines and online job sites.

Local Newspapers

You can look at the Vancouver Sun & The Province at Vancouver Public Library for free. Check the job postings daily, the careers section in the Vancouver Sun on Wednesdays and Saturdays and, in The Province on Sundays.

Online Job Postings

Finding “Hidden Jobs”

Many job vacancies are not advertised. The resources below help you with finding jobs in this “hidden” job market.

Using Directories to Create a List of Potential Employers

You can use directories to produce lists of employers who are in this industry. Contact them directly to find out if they’re hiring.

  • BC Tech, Technology Guide (special issue of BC Tech magazine)
    Includes company lists for: biggest BC tech companies, BC software developers, BC telecommunication companies, and the top 100 tech companies in BC.
    Available at the Central Library, 380 EL3CBh
  • Reference Canada
    Click on “Start Search” beside Canadian Businesses, then select the “Advanced Search” button.
    Select both “Keyword/SIC/NAICS” under Business Type and “City” under Geography.
    In the top search box enter “computer services” and click LOOKUP.
    Select the appropriate headings.
    Lower down, select the Province, choose the cities, and click the “View Results” button.
    NOTE: You can access this database from a Library computer. If you are using a computer from outside the Library, you will need a Vancouver Public Library card to login to this database. After clicking on the database name, you will be asked to enter your library card number and PIN (usually last four digits of your telephone number).

Volunteering and Temporary Agencies

Many positions are filled by people who have been recommended by someone they know. Networking, working as a volunteer or registering with a temporary employment agency are good ways of helping you find jobs and meet people in your industry.

Networking and the Hidden Job Market:

When looking for work, be sure to talk to friends, relatives and neighbours. They may know someone who is hiring! Working as a volunteer, attending events, and joining clubs and associations are good ways to gain “Canadian experience.” They are also good ways to meet people to learn about the local job market.

Volunteer opportunities

  • Charity Village
    Find a Job

    Find Jobs: Advanced Search [in ‘Position Type’ box, select ‘unpaid volunteer position’ and then select a relevant ‘Job Category’ e.g. ‘IT Service & Support’]
  • Volunteer Connections.net
    [volunteer opportunities in Coquitlam, Port Coquitlam, Port Moody, New Westminster, Anmore, Belcarra]
  • Career Mash
    [Career Mash is a service of the Information Technology Association of Canada (ITAC); it promotes information technology careers]
    [committed tech professionals volunteer with CareerMash for the ‘In-Class Guest Speaker program’ and/or the ‘Online Presenter program’, spreading the word about the benefits of choosing a tech-related career]

For additional tips see:

Applying for a Job

In Canada, employers usually expect to receive a resume and a cover letter that identifies the position you are applying for and summarizes your experience.

Use the library catalogue to find books on writing resumes and cover letters specific to your industry.

For more information see:

Where Can This Job Lead?

With experience mobility may be possible between specializations in this group, to management or regulatory program management.

Where Can I Find More Information?

  • CareerMash
    Explore CareerMash to learn how to mash up your personal interests with a well-paid tech career.