database analyst

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

Job summary

A public sector organization in the Peel Region is looking for an IT professional with expertise in database management and a focus on improving IT infrastructure. The ideal candidate should have a college diploma and 2 to 3 years of relevant experience. Responsibilities include developing databases, collecting data, and documenting requirements. Strong communication and client-focused skills are essential for success in this fast-paced environment.

Qualifications

• 2 years to less than 3 years experience in IT.
• Experience with database management and data administration.

Responsibilities

• Collect data to identify areas for improvement.
• Develop and maintain computer databases.
• Document customers' requirements for projects.

Skills

Data Science

Database management

Excellent written communication

Client focus

Attention to detail

Education

College, CEGEP certificate or diploma

Tools

Database management systems

Job description

Overview

Languages: English

Education

• College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years
• or equivalent experience

Experience

2 years to less than 3 years

Work setting

• Consulting firm
• Private sector

Responsibilities

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

Supervision

• 1 to 2 people

Additional information

Work conditions and physical capabilities

• Fast-paced environment
• Work under pressure
• Repetitive tasks
• Attention to detail

Personal suitability

• Client focus
• Efficient interpersonal skills
• Excellent oral communication
• Excellent written communication
• Organized