database analyst

Government of Canada; Markham; On-site; CAD 60,000 - 80,000; Full time

Job summary

A public sector organization in Markham is looking for a Database Developer to enhance and secure computer databases. The ideal candidate will have 3-5 years of experience and knowledge in database management systems. Responsibilities include designing databases, implementing data policies, and analyzing data for reports. A college diploma is required, along with strong interpersonal skills and the ability to work on-site.

Qualifications

• 3 years to less than 5 years of experience in relevant field.

Responsibilities

• Develop and maintain computer databases.
• Enact measures to secure data from unauthorized access.
• Test data models and database management systems.
• Design and develop databases.
• Analyze data using database management systems.
• Implement data administration policies and standards.
• Research data collection and access rules.
• Develop procedures for network access and backup.
• Write related scripts for stored procedures.
• Analyze data and prepare reports.

Skills

Efficient interpersonal skills

Initiative

Judgement

Organized

Team player

Accountability

Education

College/CEGEP

Job description

Overview

Languages: English

Education

• College/CEGEP

Experience

3 years to less than 5 years

Location

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

Responsibilities

• Develop and maintain computer databases
• Enact measures to make sure unauthorized users cannot access the data
• 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
• Analyze data and prepare reports

Personal suitability

• Efficient interpersonal skills
• Initiative
• Judgement
• Organized
• Team player
• Accountability