Database Engineer

Altis Technology; Toronto; Hybrid; CAD 81,000 - 99,000; Part time

Job summary

A staffing agency is looking for a Senior Database Engineer to lead SQL Server data migration and maintain critical data systems. This hybrid role involves designing and optimizing databases to ensure high performance and security. Candidates should have over 5 years of experience with SQL Server, strong skills in SQL development and expertise in data migration tools like SSIS and SSRS. The position offers flexible compensation and opportunities for influence in database architecture.

Qualifications

• 5+ years of experience working with Microsoft SQL Server and database engineering.
• Strong expertise in SQL development including stored procedures and query optimization.
• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Responsibilities

• Design, develop, and maintain Microsoft SQL Server databases across on-premise and cloud environments.
• Build and optimize complex SQL queries, stored procedures, functions, and views.
• Monitor and tune database performance using indexing strategies and query optimization.
• Support data migrations, automated pipelines, and reporting infrastructure including SSIS and SSRS environments.
• Manage database security, backup procedures, and disaster recovery processes.

Skills

Microsoft SQL Server

SQL development

SSIS

SSRS

Troubleshooting

Problem solving

Collaboration skills

Job description

Job Title: Senior Database Engineer/ Senior Data Migration
Location: Toronto, Ontario (Hybrid, 2 days per week onsite)
Job Type: 9-12 month contract, with possible extension
Compensation: estimated $90,000/during the contract, with flexibility

About the Opportunity

Our client in the retail and loyalty sector is seeking a skilled Database Engineer to help design, optimize, and maintain critical data systems that power their business operations and customer engagement platforms. This role sits at the intersection of engineering, analytics, and infrastructure, ensuring data platforms are scalable, secure, and high performing.

This role will lead the migration of SQL Server data across borders, while designing the replication and reporting structure to support business reporting during the transition to ERP. You will work closely with the Senior Loyalty Manager and cross‑functional teams across analytics, infrastructure, and product. The work you do will directly support the organization’s ability to deliver data‑driven insights and maintain reliable systems that support customer loyalty programs and operational reporting.

What’s in it for You

This opportunity offers the chance to work on data platforms that directly support customer engagement and business intelligence. You will gain exposure to both on‑premise and cloud‑based environments while contributing to modern data infrastructure.

You will join a collaborative team environment that values technical ownership, innovation, and continuous improvement. The role provides strong opportunities to influence database architecture, optimize performance, and support evolving data initiatives.

Your Responsibilities

• You’ll design, develop, and maintain Microsoft SQL Server databases across on‑premise and cloud environments.
• You’ll build and optimize complex SQL queries, stored procedures, functions, and views to support reporting and operational systems.
• In this role, you’ll monitor and tune database performance through indexing strategies, query optimization, and system monitoring.
• You’ll support data migrations, automated pipelines, and reporting infrastructure including SSIS and SSRS environments.
• You’ll manage database security, backup procedures, and disaster recovery processes to ensure reliability and data integrity.

Skills and Qualifications

• 5+ years of experience working with Microsoft SQL Server and database engineering or administration.
• Strong expertise in SQL development including stored procedures, query optimization, and indexing.
• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Experience supporting databases in both on‑premise and cloud environments.
• Strong troubleshooting, problem solving, and collaboration skills.

Note from the Hiring Manager

“We’re looking for someone who enjoys solving complex data problems and takes pride in building systems that are reliable, scalable, and optimized. This role will play a key part in how our teams use data to support the business.”

Why Partner with Altis

If you’ve never worked with a staffing agency before, don’t worry, we make it easy. You’ll still engage directly with the client while we handle the logistics, provide guidance, and keep you informed every step of the way. We’ll represent your strengths, guide you through each stage of the process, and ensure the experience feels personal and transparent.

All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI‑assisted tools to help review applications.

Note: We’re aware of fraudulent recruitment messages being sent to job seekers via WhatsApp and SMS. This is impacting many staffing firms, including Altis. Please know we do not contact job seekers via WhatsApp. We do occasionally use SMS but will never ask for personal information. If in doubt, please contact us: 1-877-579-5808 or [e-mail]. Read more about recruitment scams HERE.