Explore Careers - Job Market Report

in
Database Analysts and Data Administrators  (NOC 2172)
Annapolis Valley Region
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

Berwick, Bridgetown, Hantsport, Kentville, Middleton, Windsor, Wolfville

View a list of Service Canada offices in this area.

Outlook & Prospects for Database Analysts and Data Administrators in Annapolis Valley Region

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.

Local Employment Potential Information

Table on the employment potential for Database Analysts and Data Administrators in Annapolis Valley Region as well as in the rest of the Nova Scotia.
Location Employment Potential Release Date
Annapolis Valley Region Fair 2011-06-21

Currently the chances of qualified Database Analysts and Data Administrators finding employment are considered to be fair in the local area.

There is some opportunity for people in this occupation to be working as self-employed consultants but few job openings for full-time employment locally that is not project based.

University enrolment in computer science and computer engineering has been declining since 2001 which has lead to a decreased supply of new workers in this field. In Nova Scotia, a large percentage of employment in this field (80%) is found in the Halifax area and provincial reports from the information technology industry in Nova Scotia show anticipated job growth in all Information Technology (IT) sectors.

You must be detail-oriented, methodical and precise. Accuracy and good proofreading skills are required to detect, locate, and avoid errors in code. As more businesses use the internet as a means of doing business, skills in designing and maintaining databases using current applications will continue to be required. Network and system security skills are usually also a requirement for data administrators. As organizations find themselves inundated with a wealth of information, database analysts and database administers have become key to managing this information. A new trend among businesses is to outsource to information technology establishments that can gather data from various sources, process it and store it securely. This is being driven by a fear of identity and data theft, as hackers and cyber-thieves threaten information sources.

In addition to employment opportunities locally, opportunities may exist in other areas of the province or in other regions of the country. People who are able to work elsewhere may want to research opportunities for this occupation in other labour markets within Nova Scotia and across the country. The future employment outlook for Database Analysts and Data Administrators in Nova Scotia is expected to be good over the next 5 years.

Additional information on Database Analysts and Data Administrators (opportunities in other areas, training, who hires, current job openings, statistics and other information), is available on other parts of this web site.

Please consult the Nova Scotia and Canada tabs for more useful information related to outlook.