← Back

Data administrator

  • Durée de l'emploi: Permanent
  • Langue de travail: Anglais
  • Heures de travail: 30 hours per week
  • Education:
  • Expérience:

Education

  • Bachelor's degree
  • Information technology
  • Computer science
  • Computer technology/computer systems technology

Tasks

  • Collect data to identify areas for improvement within an organization's IT infrastructure
  • Develop and implement a strategic blueprint to follow when deploying databases within their organization
  • Develop and maintain computer databases
  • 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
  • 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

Computer and technology knowledge

  • MS SQL Server
  • Servers
  • MySQL
  • Data analysis software

Work conditions and physical capabilities

  • Attention to detail

Personal suitability

  • Accurate
  • Efficient interpersonal skills
  • Excellent written communication
  • Initiative
  • Judgement
  • Organized
  • Team player
  • Adaptability
  • Accountability
  • Quick learner

Screening questions

  • Do you have experience working in this field?

Experience

  • 2 years to less than 3 years

Support for persons with disabilities

  • Offers mentorship, coaching and/or networking opportunities for persons with disabilities
  • Provides awareness training to employees to create a welcoming work environment for persons with disabilities
  • Applies accessible and inclusive recruitment policies that accommodate persons with disabilities

Support for newcomers and refugees

  • Supports social and labour market integration of newcomers and/or refugees (for example: facilitating access to community resources, language training, skills training, etc.)
  • Recruits newcomers and/or refugees who were displaced by a conflict or a natural disaster (for example: Ukraine, Afghanistan, etc.)
  • Supports newcomers and/or refugees with foreign credential recognition
  • Offers mentorship programs that pair newcomers and/or refugees with experienced employees
  • Provides diversity and cross-cultural trainings to create a welcoming work environment for newcomers and/or refugees
  • Does not require Canadian work experience

Support for youths

  • Offers on-the-job training tailored to youth
  • Offers mentorship, coaching and/or networking opportunities for youth
  • Provides awareness training to employees to create a welcoming work environment for youth

Support for Indigenous people

  • Offers mentorship, coaching and/or networking opportunities for Indigenous workers
  • Develops and maintains relationships with indigenous communities, indigenous-owned businesses and organizations

Support for mature workers

  • Applies hiring policies that discourage age discrimination
  • Provides staff with awareness training to create a welcoming work environment for mature workers
  • Offers mentorship, coaching and/or networking opportunities for mature workers

Supports for visible minorities

  • Applies hiring policies that discourage discrimination against members of visible minorities (for example: anonymizing the hiring process, etc.)
  • Offers mentorship programs that pair members of visible minorities with experienced employees
  • Provides diversity and cross-cultural training to create a welcoming work environment for members of visible minorities