Database Analyst

Turtle Island Staffing; Ontario; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in Ontario seeks a Database Analyst/Information Management Administrator with significant experience in database optimization and data analysis. The successful candidate will implement strategies to enhance performance and reduce processing times, contributing to various projects. Ideal applicants will possess a strong background in working with MS SQL Server and have proven experience in improving scalability and performance efficiency.

Qualifications

• Minimum 5 years experience in database architectures.
• Experience in three projects focused on memory footprint reduction.
• Proficiency with MS SQL Server 2016 or later.

Responsibilities

• Analyze data to identify areas for processing time improvement.
• Design changes to reduce runtime of stored procedures.
• Conduct performance and regression testing of the system.

Skills

Data Analysis

Database Optimization

Performance Testing

User Support

Job description

1. Tasks and Deliverables

The Database Analyst/Information Management Administrator, Level 3, will be responsible for, but not limited to, the following tasks:

1. Analyze data and identify areas for processing time improvement when querying and analyzing large amounts of data.

1. Design and implement changes to reduce runtime of stored procedures, thereby reducing the risk of timeouts with key features.

1. Develop and implement strategies to reduce memory footprint of large processes and updates on databases.

1. Optimize processes that run calculations on large datasets.

1. Optimize processes that retrieve data from multiple sources to aggregate for calculations.

1. Conduct performance and regression testing of the system.

1. Develop learning materials and provide user support to facilitate knowledge transfer.

M1	The Bidder must demonstrate that the proposed resource has a minimum 5 years of experience, within the last 10 years, analyzing database architectures, data access and retrieval methods, and proposing solutions to improve processing times when querying and analyzing data.
M2	The Bidder must demonstrate that the proposed resource has experience in a minimum of three projects within the last 5 years, developing and implementing strategies to reduce memory footprint and improve scalability of processes and databases. Each project must have been a minimum duration of 6 months.
M3	The Bidder must demonstrate that the proposed resource has a minimum of 5 years of experience, working with any of the active versions of MS SQL server that are currently within Microsoft's support lifecycle (2016 or more recent).