careers.novascotia.ca

Database Analysts and Data Administrators

print
NOC:2172
Occupation:Database Analysts and Database Administrators
Category:Engineering, Math, Science, and Information Technology

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

Job duties:
Database analysts perform some or all of the following duties:
  • 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.
  • 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, coordinate 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 coordinate teams of data administrators in the development and implementation of data policies, standards and models.
Sample job titles:
  • data administrator
  • data miner
  • data processing specialist
  • database administrator (DBA)
  • database analyst (DBA)
  • database architect (DBA)
  • database designer
  • database manager
  • electronic data processing (EDP) specialist
  • information resource analyst
Skills:

To work in one of these jobs, 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 will require the mathematical skills to develop data models and prepare financial plans and reports. Communication skills are required to work effectively with other professionals and clients. Data administrators require 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.

Labour Market Information

Work Prospects:Good

The employment outlook over the next few years for this occupational group is “good”, which indicates the chances of a qualified individual finding work is better than average when compared to other occupations in Nova Scotia. This is not a large occupation in Nova Scotia so job opportunities may not be that frequent. However, competition for positions may be low due to few qualified jobseekers. The number employed in this occupation is expected to grow significantly over the next few years, which will provide additional opportunities for employment. With a large percent of workers being 55 years of age and older, retirements are expected to be a key contributor to employment opportunities over the coming years. Database Analysts and Database Administrators most commonly work full-time hours. Furthermore, the jobs are typically permanent positions. With employment conditions being somewhat seasonal, periods of downtime or layoff throughout the year affect some workers.

The median employment income for 75% of Database Analysts and Database 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)

OccupationEstimated employment in 2018Estimated change in employment between 2017 and 2019Estimated openings due to growth and retirements, 2017-2019Estimated rate of unemployment in 2018 Estimated hourly earnings in 2015 (learn more)Estimated annual earnings in 2015
Database Analysts and Data Administrators365Strong growth65Moderate
Minimum: $19.00
Median: $31.25
Maximum: $45.67
Minimum: $23,608
Median: $65,882
Maximum: $93,625
Occupations in Engineering, Math, Science, and Information Technology25,875Strong growth3,095Low
Minimum: $17.69
Median: $31.35
Maximum: $47.18
Minimum: $13,568
Median: $60,422
Maximum: $107,009
Database Analysts and Data AdministratorsCompared to: Occupations in Engineering, Math, Science, and Information Technology
Percent employed full-time96%94%
Percent self-employed10%7%
Where will I likely work?
Area of EmploymentDatabase Analysts and Data AdministratorsCompared to: All NS Occupations
% EmployedMedian Annual Income% EmployedMedian Annual Income
Southern5%x12%$30,581
Northern6%x16%$33,660
Cape Breton7%x13%$32,974
Halifax73%$54,92447%$41,209
Annapolis Valley9%x13%$32,958
What are the workers like?
AgeDatabase Analysts and Data AdministratorsCompared to: All Engineering, Math, Science, and Information Technology
% Employed% Employed
15-247%x
25-3424%14%
35-4431%33%
45-5428%32%
55-647%18%
65+x4%
Median Age4343
GenderDatabase Analysts and Data AdministratorsCompared to: Occupations in Engineering, Math, Science, and Information Technology
% Employed% Employed
Female28%20%
Male72%80%
EducationDatabase Analysts and Data AdministratorsCompared to: All Engineering, Math, Science, and Information Technology
% EmployedMedian Annual Income% EmployedMedian Annual Income
Less than high schoolN/Ax0.7%$28,107
High school8.9%$65,26312.1%$35,125
Trades certificateN/Ax6.8%$54,923
College certificate or diploma29.1%$63,36633.7%$52,476
University certificate or diploma5.1%$67,4723.7%$52,446
Bachelor's degree48.1%$67,95429.7%$58,011
University advanced certificate or diplomaN/A$71,5872.0%$54,917
Master's degreeN/A$62,2479.7%$37,706
Doctorate8.9%x1.7%$65,565
Medicine, dentistry, veterinary, optometryN/Ax0.1%$57,566
Total100%100%
Wage Disclaimer

Hourly earnings data are from the Labour Force Survey by Statistics Canada. Data are not available for all occupations. Hourly earnings are calculated based on usual hours worked per week. This is how an annual salary, for instance, gets converted to an hourly rate. The data include full and part-time workers along with new and experienced workers. Self-employed workers are excluded.

Annual employment income data reported in the Work Prospects section, are from the 2011 National Household Survey by Statistics Canada. Much of the data (around 70%) came directly from tax records. The data relates to the year 2010 and includes total wages and salaries and net income from self-employment.

Sources

Employment Requirements & Contacts

Regulations:
No regulating bodies were found under this occupation profile
Useful contacts:
Canadian Information Processing Society - Nova Scotia Chapter
PO Box 1612, Halifax Central
Halifax, NS B3J 2Y3
CIPSNS@cips.ca
Information and Communications Technology Council
116 Lisgar Street, Suite 300
Ottawa, ON K2P 0C2
Tel: (613) 237-8551
Fax: (613) 230-3490
info@ictc-ctic.ca 

Training Paths & Education

Program Name:Computer and information sciences - General
Education Level:This program may be offered at the college, trades, or university level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Mount Saint Vincent University
166 Bedford Highway
Halifax, NS B3M 2J6
(902) 457-6117
admissions@msvu.ca
Saint Mary's University
923 Robie Street
Halifax, NS B3H 3C3
(902) 420-5400
admission.status@smu.ca
Program Name:Computer programming - Specific applications
Education Level:This program is typically offered at the trades/college level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Nova Scotia Community College - Annapolis Valley Campus
50 Elliott Road
Lawrencetown, NS B0S 1M0
(902) 825-3491
avc.info@nscc.ca
Nova Scotia Community College - Institute of Technology Campus
5685 Leeds Street
Halifax, NS B3K 2T3
(902) 491-6722
it.info@nscc.ca
Program Name:Computer science
Education Level:This program is typically offered at the college or university level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Acadia University
15 University Avenue
Wolfville, NS B4P 2R6
(902) 542-2201
agi@acadiau.ca
Dalhousie University
Office of the Registrar
Halifax, NS B3H 4R2
(902) 494-2450
admissions@dal.ca
University of King's College
6350 Coburg Road
Halifax, NS B3H 2A1
(902) 422-1271
admissions@ukings.ca
St. Francis Xavier University
PO Box 5000
Antigonish, NS B2G 2W5
(902) 867-2219
admit@stfx.ca
Saint Mary's University
923 Robie Street
Halifax, NS B3H 3C3
(902) 420-5400
admission.status@smu.ca
Program Name:Data modelling/warehousing and database administration
Education Level:This program is typically offered at the college or university level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Nova Scotia Community College - Institute of Technology Campus
5685 Leeds Street
Halifax, NS B3K 2T3
(902) 491-6722
it.info@nscc.ca
Program Name:Informatics
Education Level:This program may be offered at the college, trades, or university level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Dalhousie University
Office of the Registrar
Halifax, NS B3H 4R2
(902) 494-2450
admissions@dal.ca
Saint Mary's University
923 Robie Street
Halifax, NS B3H 3C3
(902) 420-5400
admission.status@smu.ca
Program Name:Information technology
Education Level:This program may be offered at the college, trades, or university level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Success College
800 Sackville Drive
Lower Sackville, NS B4E 1R8
(902) 865-8283
Acadia University
15 University Avenue
Wolfville, NS B4P 2R6
(902) 542-2201
agi@acadiau.ca
Dalhousie University
Office of the Registrar
Halifax, NS B3H 4R2
(902) 494-2450
admissions@dal.ca
Mount Saint Vincent University
166 Bedford Highway
Halifax, NS B3M 2J6
(902) 457-6117
admissions@msvu.ca
St. Francis Xavier University
PO Box 5000
Antigonish, NS B2G 2W5
(902) 867-2219
admit@stfx.ca
Nova Scotia Community College - Annapolis Valley Campus
50 Elliott Road
Lawrencetown, NS B0S 1M0
(902) 825-3491
avc.info@nscc.ca
Nova Scotia Community College - Burridge Campus
372 Pleasant Street
Yarmouth, NS B5A 2L2
(902) 742-3501
burridge.info@nscc.ca
Nova Scotia Community College - Institute of Technology Campus
5685 Leeds Street
Halifax, NS B3K 2T3
(902) 491-6722
it.info@nscc.ca
Nova Scotia Community College - Marconi Campus
PO Box 1042, 1240 Grand Lake Road
Sydney, NS B1P 6J7
(902) 563-2450
marconi.info@nscc.ca
Nova Scotia Community College - Truro Campus
36 Arthur Street
Truro, NS B2N 1X5
(902) 893-5385
truro.info@nscc.ca
Nova Scotia Community College - Waterfront Campus & Aviation Institute
80 Mawiomi Place
Dartmouth, NS B2Y 0A5
(902) 491-1100
waterfront.info@nscc.ca
Program Name:Knowledge management
Education Level:This program is typically offered at the college or university level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Dalhousie University
Office of the Registrar
Halifax, NS B3H 4R2
(902) 494-2450
admissions@dal.ca
Program Name:Management information systems - General
Education Level:This program is typically offered at the college or university level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Maritime Business College - Dartmouth
45 Ochterloney Street, Suite 100
Dartmouth, NS B2Y 2N6
(902) 463-6700
admissions@maritimebusinesscollege.ca
Eastern College - Halifax
6940 Mumford Road, Suite 111
Halifax, NS B3L 0B7
(902) 423-3933
Academy of Learning - Halifax
6960 Mumford Road, Suite 155-1st Floor Mumford Professional Centre
Halifax, NS B3L 4P1
(902) 455-3395
careers@aolhrm.com
Dalhousie University
Office of the Registrar
Halifax, NS B3H 4R2
(902) 494-2450
admissions@dal.ca
Saint Mary's University
923 Robie Street
Halifax, NS B3H 3C3
(902) 420-5400
admission.status@smu.ca
Nova Scotia Community College - Cumberland Campus
PO Box 550, 1 Main Street
Springhill, NS B0M 1X0
(902) 597-3737
cumberland.info@nscc.ca
Nova Scotia Community College - Kingstec Campus
236 Belcher Street
Kentville, NS B4N 0A6
(902) 678-7341
kingstec.info@nscc.ca
Nova Scotia Community College - Lunenburg Campus
75 High Street
Bridgewater, NS B4V 1V8
(902) 543-4608
lunenburg.info@nscc.ca
Nova Scotia Community College - Waterfront Campus & Aviation Institute
80 Mawiomi Place
Dartmouth, NS B2Y 0A5
(902) 491-1100
waterfront.info@nscc.ca
Program Name:Mathematics - General
Education Level:This program is typically offered at the college or university level.
Program Description:
This instructional program class comprises 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.
See all institutions providing this program+
Dalhousie University
Office of the Registrar
Halifax, NS B3H 4R2
(902) 494-2450
admissions@dal.ca
University of King's College
6350 Coburg Road
Halifax, NS B3H 2A1
(902) 422-1271
admissions@ukings.ca
Mount Saint Vincent University
166 Bedford Highway
Halifax, NS B3M 2J6
(902) 457-6117
admissions@msvu.ca
St. Francis Xavier University
PO Box 5000
Antigonish, NS B2G 2W5
(902) 867-2219
admit@stfx.ca
Saint Mary's University
923 Robie Street
Halifax, NS B3H 3C3
(902) 420-5400
admission.status@smu.ca
Cape Breton University
PO Box 5300 1250 Grand Lake Road
Sydney, NS B1P 6L2
(888) 959-9995
registrar@cbu.ca
Additional resources:

There are no additional resources for this occupation.