Database Analyst/Information Management Administrator

Database Analyst/Information Management Administrator
Hybrid, Ottawa, Ontario, Canada
Security clearance is required.
Contract

The Database Analyst/Information Management Administrator will be responsible for, but not limited to, the following tasks:
a.      Analyze data and identify areas for processing time improvement when querying and analyzing large amounts of data.
b.      Design and implement changes to reduce the runtime of stored procedures, thereby reducing the risk of timeouts with key features.
c.      Develop and implement strategies to reduce the memory footprint of large processes and updates on databases.
d.      Optimize processes that run calculations on large datasets.
e.      Optimize processes that retrieve data from multiple sources to aggregate calculations.
f.        Conduct performance and regression testing of the system.
g.      Develop learning materials and provide user support to facilitate knowledge transfer.

Skills needed:
The contractor must demonstrate a minimum of 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.
The consultant must demonstrate 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 a minimum duration of 6 months.
The consultant 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).
Should demonstrate you have experience with optimizing processes that retrieve data from multiple sources to aggregate for calculations.
You also need to demonstrate that the proposed resource has experience with various MS SQL server versions (2016, 2017, 2019, 2022 versions), and you should have experience, within the last five years, in working with Entity Framework and/or LINQ.

Please send your resume to jim.nickolson@normatec.com. Only candidates selected to be moved forward in the recruitment process will be contacted by a member of the recruitment team to schedule a conversation