Data administrator

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