Database analysts and data administrators
High opportunity occupation
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
Job Titles
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.
Work Environment
# Workers Employed
2,400% Employed Full Time
79%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.
Related Careers
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:
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
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!
Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
Understanding written sentences and paragraphs in work-related documents.
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.
Talking to others to share information effectively.
Being able to solve novel, ill-defined problems in complex, real-world settings.
Communicating effectively in writing as appropriate for the needs of the audience.
Considering the relative costs and benefits of potential actions to choose the most appropriate one.
Determining how a system should work and how changes in conditions, operations and the environment will affect outcomes.
Understanding how new information could be used to solve current and future problems in making decisions.
Keeping track of and assessing your performance, other individuals, or organizations to make improvements or take corrective action.
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,400Employment by Region
| 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% |
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 (2024-2034)
1,380Forecasted Job Openings
Forecasted Employment Growth Rate
Composition of Job Openings
Job Openings by Region (2024-2034)
| Region | Job Openings | Avg. Annual Employment Growth |
|---|---|---|
| Cariboo | Not available | Not available |
| Kootenay | Not available | Not available |
| Mainland/Southwest | 1,050 | 2.2% |
| North Coast and Nechako | Not available | Not available |
| Northeast | Not available | Not available |
| Thompson-Okanagan | 80 | 2.0% |
| Vancouver Island/Coast | 260 | 1.5% |
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
| Industry | Job Openings (2024-2034) |
|---|---|
| Professional, Scientific and Technical Services | 650 |
| Public Administration | 150 |
| Finance, Insurance and Real Estate | 100 |
| Information, Culture and Recreation | 90 |
| Educational Services | 80 |
Resources
Resource information is currently not available.
