Job description Database Analyst in the Windsor-Sarnia Region

Find out what work is like for a database analyst in Canada. This work description is applicable to all Database analysts and data administrators (NOC 21223).

Database analysts and data administrators

Description

Database analysts design, develop and administer data management solutions. 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

Here are some of the main activities and tasks that Database analysts and data administrators have to perform, and some of the physical demands they involve:

  • 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
  • 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
  • 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.

Physical demands

Physical demands are the physical activities that the job requires the worker to do. Physical demands are selected according to the likeliness that workers will have to perform them for at least half of the time they spend at work.

Work environment

The work environment refers to the physical setting in which people work. The characteristics and conditions of the work environment are selected according to the likeliness that workers will be exposed to them at least once a week.

Physical proximity from others

Physical proximity from others refers to the physical distance between individuals in the workplace. The likeliness that the job requires to perform tasks while being physically close to other people is rated on a scale with 3 levels: "Somewhat close", "Close" and "Very close".

Related job titles

Here are some other related job titles that are found in the same occupational category (NOC 21223), and a list of similar occupations:

  • data administrator
  • database administrator (DBA)
  • database analyst
  • data custodian
  • data dictionary administrator
  • data warehouse analyst
  • technical architect - database

Similar occupations Help - Similar occupations

Similar occupations

This section lists other occupations that are part of the same broad occupational category as Database analysts and data administrators in the National Occupational Classification (NOC). These occupations involve similar core qualifications but involve different responsibilities. To see more similar occupations, use the Job Transition Tool.

Sources Occupational and Skills Information System & National Occupational Classification

Labour Market Information Survey
Date modified: