Government of Canada - Central

database analyst


Pay43.96 / hour
LocationToronto/Ontario
Employment typeFull-Time

What's your preference?

Apply with job updates
  • Job Description

      Req#: 43849008

      Overview

      Languages

      English

      Education

      • Bachelor's degree
      • Computer science
      • Computer software engineering
      • Business administration and management, general

      Experience

      5 years or more

      On site

      Work must be completed at the physical location. There is no option to work remotely.

      Responsibilities

      Tasks

      • Collect data to identify areas for improvement within an organization’s IT infrastructure
      • Develop and maintain computer databases
      • Document customers’ requirements for projects
      • Document reporting needs, queries, logic, results and recommendations to other information systems professionals
      • Enact measures to make sure unauthorized users cannot access the data
      • Liaise with staff on data requirements, collection and availability
      • Provide advice to other informatics professionals regarding database management tools
      • Setup the IT infrastructure to allow applications to access databases
      • Test data models and database management systems
      • Design and develop database
      • 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
      • Write scripts related to stored procedures and triggers
      • Design, develop and implement information systems business solutions

      Experience and specialization

      Computer and technology knowledge

      • PowerBuilder
      • Data Warehouse
      • Linux
      • MySQL
      • Word processing software
      • Project management software
      • Mapping and data visualization software
      • Database software
      • Data analysis software
      • MS Office
      • MS Windows
      • Spreadsheet
      • JavaScript
      • PHP
      • Python
      • SQL

      Benefits

      Health benefits

      • Dental plan
      • Health care plan
      • Vision care benefits
  • About the company