Database Analysts and Database Administrators

(NOC 2172)

in All Engineering, Math, Science, and Information Technology

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 work for information technology consulting firms and in information technology units throughout the private and public sectors.

Job Outlook

Average

Read more

  • Estimate Moderate growth employment change, 2019-2021
  • Estimate 10 openings due to growth and retirements, 2018-2020
  • Estimate Moderate rate of unemployment in 2019

Compared to: All Engineering, Math, Science, and Information Technology

  • Estimate 705 employment change, 2019-2021
  • Estimate 2585 openings due to growth and retirements, 2018-2020
  • Estimate rate of unemployment not available for these occupation.

The employment outlook over the next few years for this occupational group is “average”, which indicates the chances of a qualified individual finding work is comparable to the average for all occupations in Nova Scotia. This is not a large occupation in Nova Scotia so job opportunities may not be that frequent. The number employed in this occupation is expected to grow moderately over the next few years, which will likely provide some additional opportunities for employment. With a moderate percent of workers being 55 years of age and older, retirements are expected to contribute somewhat to employment opportunities over the coming years. Database Analysts and Data Administrators most commonly work full-time hours.

The median employment income for 70% of Database Analysts and Data Administrators who worked full-time, year-round in 2015 was $70,996. Across all occupations in Nova Scotia, 59% of those who worked full-time year round had a median employment income of $43,600.
(Source: 2016 Census)

Hourly Pay

$18.27

Minimum

$33.20

Median

$58.52

Maximum

Annual Pay

$23,608

Minimum

$65,882

Median

$93,625

Maximum

Compared to: All Engineering, Math, Science, and Information Technology

Hourly Pay

$18.00

Minimum

$37.80

Median

$48.46

Maximum

Annual Pay

$13,568

Minimum

$60,422

Median

$107,009

Maximum

About the job

Nature of work

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 work for information technology consulting firms and in information technology units throughout the private and public sectors.

Job duties

Database analysts:

  • Collect and document user requirements.
  • Design and develop database architecture for information systems projects.
  • Design, construct, modify, integrate, implement, and test data models and database management systems.
  • Research and provide advice to other informatics professionals about the selection, application, and implementation of database management tools.
  • Use database management systems to analyze data and perform data mining analysis.
  • May lead, coordinate, or supervise other workers in this group.

Data administrators:

  • 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.
  • Research and provide advice to other information systems professionals about the collection, availability, security, and suitability of data.
  • Write scripts related to stored procedures and triggers.
  • May lead and coordinate teams of data administrators to develop and implement data policies, standards, and models.

Sample job titles

  • data administrator
  • data miner
  • data processing specialist
  • data scientist
  • database administrator (DBA)
  • database analyst
  • database architect
  • database designer
  • information resource analyst
  • technical architect - database

Skills

You should enjoy helping your clients develop and implement solutions to meet their needs. You must be detail-oriented, methodical and precise. Accuracy and good proofreading skills are required to detect, locate, and avoid errors in code. You need the mathematical skills to develop data models and prepare financial plans and reports. Communication skills are necessary to work effectively with other professionals and clients. Data administrators need good research skills and may be required to lead and coordinate teams. As software and data management techniques are constantly being updated, you should be prepared to update your knowledge and skills on a regular basis.

Job requirements

  • A bachelor's degree, usually in computer science or in mathematics or completion of a college program in computer science is usually required.

Other considerations

Computer programming experience is usually required.

By the numbers

Quick look

410

employed in 2016

92.7%

employed full-time

2.4%

self employed

29.3%
Icons/female Created with Sketch.
70.7%
Icons/male Created with Sketch.
42.7

median age

Compared to: All Engineering, Math, Science, and Information Technology

25,875

employed in 2016

91.5%

employed full-time

7.6%

self employed

20.0%
Icons/female Created with Sketch.
80%
Icons/male Created with Sketch.
42.8

median age

Where will I likely work?

73.2%

Halifax

8.5%

Annapolis Valley

7.3%

Cape Breton

6.1%

North Shore

4.9%

Southern

Compared to: All NS Occupations

47.0%

Halifax

15.6%

North Shore

12.9%

Annapolis Valley

12.7%

Cape Breton

11.8%

Southern

Top Industries of Employment

23.4%

Professional, scientific and technical services

22.1%

Public administration

13.0%

Health care and social assistance

9.1%

Information and cultural industries

5.2%

Manufacturing

What is the age of Employment?

32.0%

35-44

26.0%

45-54

22.0%

25-34

15.0%

55-64

4.0%

15-24

2.0%

65+

Compared to: All Engineering, Math, Science, and Information Technology

24.2%

25-34

23.5%

45-54

23.4%

35-44

16.4%

55-64

7.7%

15-24

Top levels of education

45.8%

Bachelor

$70,992 median annual income
27.7%

College Diploma

$67,098 median annual income
9.6%

High school

$44,806 median annual income
9.6%

Master

$44,724 median annual income
3.6%

Diploma Below Bachelor

N/A

Compared to: All Engineering, Math, Science, and Information Technology

33.1%

College Diploma

$59,986 median annual income
29.8%

Bachelor

$63,965 median annual income
11.9%

High school

$45,835 median annual income
9.9%

Master

$65,105 median annual income
6.9%

Apprenticeship

$57,773 median annual income

Education & training

Computer and information sciences - General

This program may be offered at the college, trades, or university level.

This instructional program class includes any general program that focuses on computing, computer science, and information science and systems as part of a broad and/or interdisciplinary program. Such programs are undifferentiated as to title and content and are not to be confused with specific programs in computer science, information science, or related support services.

Institutions providing this program

Mount Saint Vincent University

166 Bedford Highway

Halifax, NS B3M 2J6

(902) 457-6117

Saint Mary's University

923 Robie Street

Halifax, NS B3H 3C3

(902) 420-5400

Computer programming - Specific applications

This program is typically offered at the trades/college level.

This instructional program class includes any program that prepares individuals to apply the knowledge and skills of general computer programming to the solution of specific operational problems and customization requirements presented by individual software users and organizational users. Includes training in specific types of software and its installation and maintenance.

Institutions providing this program

Academy of Learning Career College - Halifax

6960 Mumford Road, Suite 155-1st Floor Mumford Professional Centre

Halifax, NS B3L 4P1

(902) 455-3395

Dalhousie University

Office of the Registrar

Halifax, NS B3H 4R2

(902) 494-2450

Nova Scotia Community College - Institute of Technology Campus

5685 Leeds Street

Halifax, NS B3K 2T3

(902) 491-6722

Computer science

This program is typically offered at the college or university level.

This instructional program class includes any general program that focuses on computers, computing problems and solutions, and the design of computer systems and user interfaces from a scientific perspective. These programs include courses in the principles of computational science, and computing theory; computer hardware design; computer development and programming; and applications to a variety of end-use situations.

Institutions providing this program

Acadia University

15 University Avenue

Wolfville, NS B4P 2R6

(902) 542-2201

Dalhousie University

Office of the Registrar

Halifax, NS B3H 4R2

(902) 494-2450

University of King's College

6350 Coburg Road

Halifax, NS B3H 2A1

(902) 422-1271

St. Francis Xavier University

PO Box 5000

Antigonish, NS B2G 2W5

(902) 867-2219

Saint Mary's University

923 Robie Street

Halifax, NS B3H 3C3

(902) 420-5400

Nova Scotia Community College - Institute of Technology Campus

5685 Leeds Street

Halifax, NS B3K 2T3

(902) 491-6722

Nova Scotia Community College - Marconi Campus

PO Box 1042, 1240 Grand Lake Road

Sydney, NS B1P 6J7

(902) 563-2450

Data modelling/warehousing and database administration

This program is typically offered at the college or university level.

This instructional program class includes any program that prepares individuals to design and manage the construction of databases and related software programs and applications, including the linking of individual data sets to create complex searchable databases (warehousing) and the use of analytical search tools (mining). These programs include courses in database theory, logic, and semantics; operational and warehouse modelling; dimensionality; attributes and hierarchies; data definition; technical architecture; access and security design; integration; formatting and extraction; data delivery; index design; implementation problems; planning and budgeting; and client and networking issues.

Institutions providing this program

Dalhousie University

Office of the Registrar

Halifax, NS B3H 4R2

(902) 494-2450

Cape Breton University

PO Box 5300 1250 Grand Lake Road

Sydney, NS B1P 6L2

(888) 959-9995

Nova Scotia Community College - Institute of Technology Campus

5685 Leeds Street

Halifax, NS B3K 2T3

(902) 491-6722

Informatics

This program may be offered at the college, trades, or university level.

This instructional program class includes any program that focuses on computer systems from a user-centred perspective and studies the structure, behaviour and interactions of natural and artificial systems that store, process and communicate information. These programs include courses in information sciences, human computer interaction, information system analysis and design, telecommunications structure and information architecture and management.

Institutions providing this program

Dalhousie University

Office of the Registrar

Halifax, NS B3H 4R2

(902) 494-2450

University of King's College

6350 Coburg Road

Halifax, NS B3H 2A1

(902) 422-1271

Saint Mary's University

923 Robie Street

Halifax, NS B3H 3C3

(902) 420-5400

Nova Scotia Community College - Institute of Technology Campus

5685 Leeds Street

Halifax, NS B3K 2T3

(902) 491-6722

Information technology

This program may be offered at the college, trades, or university level.

This instructional program class includes any program that focuses on the design of technological information systems, including computing systems, as solutions to business and research data and communications support needs. These programs include courses in the principles of computer hardware and software components, algorithms, databases, telecommunications, user tactics, application testing, and human interface design.

Institutions providing this program

Acadia University

15 University Avenue

Wolfville, NS B4P 2R6

(902) 542-2201

Dalhousie University

Office of the Registrar

Halifax, NS B3H 4R2

(902) 494-2450

Nova Scotia Community College - Burridge Campus

372 Pleasant Street

Yarmouth, NS B5A 2L2

(902) 742-3501

Nova Scotia Community College - Strait Area Campus & Nautical Institute

226 Reeves Street

Port Hawkesbury, NS B9A 2A2

(902) 625-2380

Nova Scotia Community College - Ivany Campus

80 Mawiomi Place

Dartmouth, NS B2Y 0A5

(902) 491-1100

Information technology project management

This program may be offered at the college, trades, or university level.

This instructional program class includes any program that prepares individuals to design, develop, and manage information technology projects in a variety of companies and organizations. These programs include courses in principles of project management, risk management, procurement and contract management, information security management, software management, organizational principles and behaviour, communications, quality assurance, financial analysis, leadership, and team effectiveness.

Institutions providing this program

St. Francis Xavier University

PO Box 5000

Antigonish, NS B2G 2W5

(902) 867-2219

Knowledge management

This program is typically offered at the college or university level.

This instructional program class includes any program that focuses on the study of knowledge management in government agencies and corporations for the purpose of supporting stated organizational goals and objectives, and prepares individuals to function as information resource managers. These programs include courses in information technology, principles of computer and information systems, management information systems, applicable policy and regulations, and operations and personnel management.

Institutions providing this program

Dalhousie University

Office of the Registrar

Halifax, NS B3H 4R2

(902) 494-2450

Management information systems - General

This program is typically offered at the college or university level.

This instructional program class includes any program that generally prepares individuals to provide and manage data systems and related facilities for processing and retrieving internal business information; select systems and train personnel; and respond to external data requests. These programs include courses in cost and accounting information systems, management control systems, personnel information systems, data storage and security, business systems networking, report preparation, computer facilities and equipment operation and maintenance, operator supervision and training, and management information systems policy and planning.

Institutions providing this program

Maritime Business College

800 Sackville Drive

Lower Sackville, NS B4E 1R8

(902) 463-6700

Academy of Learning Career College - Halifax

6960 Mumford Road, Suite 155-1st Floor Mumford Professional Centre

Halifax, NS B3L 4P1

(902) 455-3395

Dalhousie University

Office of the Registrar

Halifax, NS B3H 4R2

(902) 494-2450

Saint Mary's University

923 Robie Street

Halifax, NS B3H 3C3

(902) 420-5400

Mathematics - General

This program is typically offered at the college or university level.

This instructional program class includes any general program that focuses on the analysis of quantities, magnitudes, forms, and their relationships, using symbolic logic and language. These programs include courses in algebra, calculus, functional analysis, geometry, number theory, logic, topology and other mathematical specializations.

Institutions providing this program

Dalhousie University

Office of the Registrar

Halifax, NS B3H 4R2

(902) 494-2450

University of King's College

6350 Coburg Road

Halifax, NS B3H 2A1

(902) 422-1271

Mount Saint Vincent University

166 Bedford Highway

Halifax, NS B3M 2J6

(902) 457-6117

St. Francis Xavier University

PO Box 5000

Antigonish, NS B2G 2W5

(902) 867-2219

Saint Mary's University

923 Robie Street

Halifax, NS B3H 3C3

(902) 420-5400

Cape Breton University

PO Box 5300 1250 Grand Lake Road

Sydney, NS B1P 6L2

(888) 959-9995

Employment requirements & contacts

No regulating bodies were found under this occupation profile

Contacts

Canadian Information Processing Society - Nova Scotia Chapter
PO Box 1612, Halifax Central
Halifax, NS B3J 2Y3
Information and Communications Technology Council
116 Lisgar Street, Suite 300
Ottawa, ON K2P 0C2
Tel: (613) 237-8551
Fax: (613) 230-3490

Additional resources

There are no additional resources for this occupation.

Job postings

There are currently no job postings for this occupation.