Skills Database Administrator (DBA) in Ontario

National Occupational Classification update

We have updated this page to reflect the transition to the 2021 version of the National Occupational Classification (NOC). This means that the occupation "database administrator (DBA)" was moved from the group Database analysts and data administrators (NOC 2172) to the group Database analysts and data administrators (NOC 21223).

Find out what skills you typically need to work as a database administrator (DBA) in Canada. These skills are applicable to all Database analysts and data administrators (NOC 21223).

Tasks

  • Collect and document user's requirements
  • Data Science
  • Design and develop database
  • Design, construct, modify, 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
  • Develop and implement data administration policy, standards and models
  • Research and document data requirements, data collection and administration policy, and data access rules
  • Develop policies and procedures for network 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 and suitability of data
  • Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models
  • Write scripts related to stored procedures and triggers

Skills and knowledge

The following skills and knowledge are usually required in this occupation.

    Skills

  • Analysis Help -
    • Projecting Outcomes
    • Researching and Investigating
    • Planning
    • Examining and Diagnosing
    • Analyzing Information
    • Inspecting and Testing
  • Management Help -
    • Strategic Planning
    • Leading and Motivating
    • Allocating and Controlling Resources
    • Evaluating
    • Co-ordinating and Organizing
    • Recruiting and Hiring
    • Supervising
  • Communication Help -
    • Negotiating and Adjudicating
    • Liaising and Networking
    • Teaching and Training
    • Professional Communicating
    • Advising and Consulting
    • Promoting and Selling
    • Interviewing
  • Information Handling Help -
    • Managing Information
    • Processing Information
  • Creative Expression Help -
    • Designing
    • Writing
    • Performing and Entertaining
  • Working with Technological Equipment and Machinery Help -
    • Installing and Setting-Up Technical Infrastructure
    • Debugging and Reprogramming Technical Systems
    • Using Specialized Instrumentation and Equipment

    Knowledge

  • Law and Public Safety Help -
    • Law, Government, and Jurisprudence
    • Public Safety and Security
  • Engineering and Technology Help -
    • Engineering and Applied Technologies
    • Computer and Information Systems
    • Electricity (Electrical and Electronics)
    • Design
    • Building and Construction
    • Mechanics and Machinery
Labour Market Information Survey
Date modified: