Explore Careers - Job Market Report

in
Database Analysts and Data Administrators  (NOC 2172)
Prince Edward Island
Description |  Titles |  Duties |   Related Occupations

Database analysts design, develop and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards and models. They are employed in information technology consulting firms and in information technology units throughout the private and public sectors.

data administrator, data custodian, data dictionary administrator, data warehouse analyst, database administrator (DBA), database analyst, database architect, technical architect – database.

Database analysts perform some or all of the following duties:
  • Collect and document 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
  • Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools
  • Operate database management systems to analyze data and perform data mining analysis.
  • May lead, co-ordinate or supervise other workers in this group.
Data administrators perform some or all of the following duties:
  • Develop and implement data administration policy, standards and models
  • Research and document 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
  • Conduct 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
  • May lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models.
Included Cities in Region | Service Canada Offices

Charlottetown, Summerside, Alberton, Cornwall, Kensington, Montague, Souris, Stratford

View a list of Service Canada offices in this area.

Outlook & Prospects for Database Analysts and Data Administrators in Prince Edward Island

The future forecast and current conditions for an occupation can vary based on location or due to changes in the economy, technology, or demand for a product or service.

National Outlook – 10-Year Projection (2011-2020)

This section provides labour demand and labour supply projections for this occupation over the 2011-2020 period.

Note: The tables, graphs and middle paragraph shown under this section display updated 2011-2020 projection results. The remaining narrative text (2009-2018 projections) will be updated shortly. We apologize for the inconvenience.

The data in the following table are derived from HRSDC’s Canadian Occupational Projection System (COPS). COPS uses a variety of models to produce a detailed 10-year labour market projection per broad skill level and per occupation at the national level, which focuses on the trends of labour supply and labour demand over the next ten years.

This occupation (Database Analysts and Data Administrators) is part of a larger occupational group called Computer and Information Systems Professionals (NOC 217).

Table on the demographic profile for your chosen occupation at the national level.
Occupations in this group Information Systems Analysts and Consultants (2171) 
Database Analysts and Data Administrators (2172) 
Software Engineers and Designers (2173) 
Computer Programmers and Interactive Media Developers (2174) 
Web Designers and Developers (2175) 
Employment (non-student) in 2010 372,786
Median Age of workers in 2010 40
Average Retirement Age in 2010 61

Occupation Projection for Canada

Over the 2008-2010 period, employment growth in this occupation was strong. The unemployment rate increased more quickly than for all occupations but still remained below 5% in 2010. According to key labour market indicators, the number of job seekers was sufficient to fill all job openings in this occupation.

Over the 2011-2020 period, an occupation will be in excess demand (a shortage of workers) if the projected number of job openings is significantly greater than the projected number of job seekers. An occupation will be in excess supply (a surplus of workers) if the projected number of job openings is smaller than the projected number of job seekers. For Computer and Information Systems Professionals, over the 2011-2020 period, job openings (arising from expansion demand and replacement demand) are expected to total 152,836 and 210,662 job seekers (arising from school leavers, immigration and mobility) are expected to be available to fill the job openings.

Although labour supply and demand in this occupation were recently balanced, projections indicate that the number of job seekers will be greater than the job openings over the 2011-2020 period. Job openings will mainly result from expansion demand. The majority of workers in this occupation are young so the need to replace workers who are retiring will be very small compared to the average. Although employment growth in this occupation will not reach the level of the 1990s, it will be one of the strongest over the projection period. This is because computer technology is now an integral part of the economy, which in general is increasingly knowledge-based. However, changes in technology that facilitate remote communication will increase competition in this industry since they will make it possible for Canadian companies to outsource information and communications technologies and development services to lower-cost countries. Although labour demand will be high, the number of job seekers is expected to be even higher. In fact, the number of computer science school leavers will continue to be high since this field of study continues to be very popular with young people. Immigration will also be an important source of job seekers since computer-related jobs remain one of the most attractive high-skilled occupations for immigrants, given that skills and knowledge acquired abroad in this field are easily transferable to Canada. Therefore, in spite of very strong growth in employment, the low replacement needs and the increase in the number of computer science graduates and immigrants will mean a surplus of workers in this occupation.

This Chart contains data for Projection of Job Openings vs. Job Seekers for Canada. Information is available in the following tables.

This Chart contains data for Projection of Job Openings vs. Job Seekers for Canada. Information is available in the following tables.
Table of job opening projections for the occupational group containing your chosen occupation.
Category Openings %
Expansion Demand 88,401 58%
Retirements 46,688 31%
Other Replacement Demand 8,950 6%
Emigration 8,797 6%
Projected Job Openings 152,836 100%
Table of job seeker projections for the occupational group containing your chosen occupation.
Category Seekers %
School Leavers 132,748 63%
Immigration 45,671 22%
Other 32,242 15%
Projected Job Seekers 210,662 100%

In which industry or sector do people in this occupation find jobs in Canada?

This table shows the industry and sectors employing the highest number of people in this occupation.

This table shows the industry sectors employing the highest number of people in this occupation.
Industry / Sector %
Professional, scientific and technical services 25.90
Public administration 17.20
Information and cultural industries 10.00
Finance and insurance 9.80
Manufacturing 5.10

What percentage of people in this occupation are self-employed?

The graph displays the percentage of people in this occupation who are “self-employed”, according to the 2006 Census, in comparison to the Canadian average across all occupations.

As shown in the graph, according to the 2006 Census, 6% of people in this occupation were self-employed, while the average for all occupations was 12%.

The Labour Force Survey also gives us some information about self-employment. This occupation (Database Analysts and Data Administrators) is part of a larger group called Computer and Information Systems Professionals (NOC 217). According to the Labour Force Survey (2009), 19% of workers in this group were self-employed, while the average for all occupations was 16%.

What proportion of men and women work in this occupation?

The graph displays the proportion of men and women in this occupation in comparison to the Canadian average across all occupations.

According to the Labour Force Survey (2009), women represented 37% of workers in this occupation, compared to the average of 48% for all occupations.

What percentage of people in this occupation are members of a union?

This occupation (Database Analysts and Data Administrators) is part of a larger group called Computer and Information Systems Professionals (NOC 217). According to the Labour Force Survey (2009), the unionization rate for this group was 20%, while the unionization rate for all occupations was 31%.

Please consult the Prince Edward Island and Prince Edward Island tabs for more useful information related to outlook.