Database Analysts and Database Administrators
(NOC 2172)
in All Engineering, Math, Science, and Information TechnologyDatabase 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
Good
Read more
Compared to: All Engineering, Math, Science, and Information Technology
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 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. 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 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
$21.95
Minimum$33.70
Median$48.52
MaximumAnnual Pay
$23,608
Minimum$65,882
Median$93,625
MaximumCompared to: All Engineering, Math, Science, and Information Technology
Hourly Pay
$18.00
Minimum$37.80
Median$48.46
MaximumAnnual Pay
$13,568
Minimum$60,422
Median$107,009
MaximumAbout 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
employed in 2016
employed full-time
self employed
median age
Compared to: All Engineering, Math, Science, and Information Technology
employed in 2016
employed full-time
self employed
median age
Where will I likely work?
Halifax
$67,016 median annual incomeAnnapolis Valley
$77,735 median annual incomeCape Breton
$42,289 median annual incomeNorth Shore
N/ASouthern
N/ACompared to: All NS Occupations
Halifax
North Shore
Annapolis Valley
Cape Breton
Southern
Top Industries of Employment
Professional, scientific and technical services
Public administration
Health care and social assistance
Information and cultural industries
Educational services
What is the age of Employment?
35-44
45-54
25-34
55-64
15-24
65+
Compared to: All Engineering, Math, Science, and Information Technology
25-34
45-54
35-44
55-64
15-24
Top levels of education
Bachelor
$70,992 median annual incomeCollege Diploma
$67,098 median annual incomeHigh school
$44,806 median annual incomeMaster
$44,724 median annual incomeDiploma Below Bachelor
N/ACompared to: All Engineering, Math, Science, and Information Technology
College Diploma
$59,986 median annual incomeBachelor
$63,965 median annual incomeHigh school
$45,835 median annual incomeMaster
$65,105 median annual incomeTrade Certification
$57,773 median annual incomeEducation & training
Computer and Information Sciences
College, Trades, or University ProgramThese programs focus 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
Computer Programming - Specific Applications
College or Trades ProgramThese programs 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
Halifax, NS
Various, NS
Computer Science
College or University ProgramThese programs focus on computers, computing problems and solutions, and the design of computer systems and user interfaces from a scientific perspective. They 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
Wolfville, NS
Various, NS
Informatics
College, Trades, or University ProgramThese programs focus 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. They include courses in information sciences, human computer interaction, information system analysis and design, telecommunications structure and information architecture and management.
Institutions providing this program
Various, NS
Information Technology
College, Trades, or University ProgramThese programs focus on the design of technological information systems, including computing systems, as solutions to business and research data and communications support needs. They 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
Wolfville, NS
Various, NS
Information Technology Project Management
College, Trades, or University ProgramThese programs prepare students to design, develop, and manage information technology projects in a variety of companies and organizations. They 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
Knowledge Management
College or University ProgramThese programs focus 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. They 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
Management Information Systems
College or University ProgramThese programs prepare students 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. They 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
Lower Sackville, NS
Halifax, NS
Mathematics
College or University ProgramThese programs focus on the analysis of quantities, magnitudes, forms, and their relationships, using symbolic logic and language. They include courses in algebra, calculus, functional analysis, geometry, number theory, logic, topology and other mathematical specializations.
Institutions providing this program
Sydney, NS
Employment requirements & contacts
No regulating bodies were found under this occupation profile