Senior Database and Integration EngineerInsight Global • Toronto, ON, CA

No longer accepting applications

Senior Database and Integration Engineer

Insight Global • Toronto, ON, CA

22 days ago

Job type

Full-time

Job description

Job Description

The Senior Database and Integration Engineer is responsible for the oversight, optimization, and support of SQL database systems and all relevant integrations, including Azure-based and on-premises environments. This position ensures these systems deliver high performance, reliability, and security, directly contributing to the firm's strategic technological advancement and operational resilience.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity / affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and / or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy : https : / / insightglobal.com / workforce-privacy-policy / .

Skills and Requirements

Technical Leadership

Maintain accountability for Azure and on-premises SQL databases.
Provide technical leadership to ensure database availability, optimization, and security, including mentoring junior team members, defining technical standards, and leading key database and integration projects.
Design, implement, and maintain cloud-based and on-premises database systems.

Database Security

Implement and maintain robust security measures across Azure and traditional SQL databases, adhering to compliance standards and cloud security best practices.

Provisioning and Maintenance

Provision SQL servers, instances, databases, and user logins following best practices.

Apply best practices for maintaining, updating, and decommissioning database systems.

High Availability and Disaster Recovery

Design and implement High Availability (HA) and Disaster Recovery (DR) procedures, including SQL Always-on configurations and expertise in business continuity technologies, backups, and disaster recovery solutions.

Contribute to disaster recovery plans and ensure integration with business continuity strategies.

Data Integration Development

Design, develop, and maintain robust ETL (Extract, Transform, Load) processes and data pipelines using tools such as SSIS, Azure Data Factory, and Intapp Integration Builder.

Monitor, troubleshoot, and optimize ETL pipelines and integration processes for performance, scalability, and reliability, addressing any data quality or consistency issues.

Implement and enforce data governance, security, and compliance standards within all data integration solutions, particularly for cloud and on-premises environments.

Maintain detailed documentation of all data integration workflows, processes, and system architecture.

System Monitoring and Optimization

Proactively monitor database health, respond to alerts, and troubleshoot issues.

Conduct query tuning, performance analysis, and optimization.

Regularly review system capacity and ensure compliance.

Operational Support

Provide third-line application and database administration support.

Troubleshoot and resolve escalated issues in a 24x7 support environment.

Manage platform upgrades, patches, and updates.

Maintain detailed documentation of workflows, processes, and system architecture.

Skills and Competencies

Technical Skills

Expertise in Microsoft Azure SQL Database, SQL Managed Instances, and traditional SQL Server.

Proficiency in Azure IaaS and PaaS technologies (e.g., Virtual Servers, Logic Apps, Azure Monitor).

Advanced skills in query tuning, and performance troubleshooting.

Advanced knowledge of PowerShell scripting.

Knowledge of integration tools such as SSIS, Azure Data Factory, and Intapp Integration Builder.

Familiarity with Windows Server, Active Directory, Azure Entra ID, and related technologies.

Strong understanding of Cloud Security Best Practices, particularly within Azure environments.

Proficiency in Solution Architecture and Architectural Design Principles for scalable and resilient systems.

Expertise with business continuity technologies, including backups and disaster recovery.

Professional Skills

Strong analytical, problem-solving, and decision-making abilities.

Ability to build effective relationships with internal teams and external vendors.

Excellent written and verbal communication skills in English.

Proven ability to manage multiple priorities under tight deadlines.

Education, Experience, and Certifications

Bachelor’s degree in Computer Science, Information Systems, or a related field.

Minimum of 8 years of experience with SQL Server in enterprise production environments.

Azure Database Administrator Associate, DP-300.

ITIL certification and practical experience are highly valued.

Familiarity with Big Data and alternative databases (e.g., MongoDB, PostgreSQL) is a plus.

Experience supporting standard legal systems (e.g., iManage DMS, Elite, InterAction).

Knowledge of SOC2, ISO 27001, and Cyber Essentials standards.

#J-18808-Ljbffr

Create a job alert for this search

Integration Engineer • Toronto, ON, CA

Similar jobs

Senior Consultant, Database Infrastructure & Cloud Platforms

CIBC • Toronto, Canada

Full-time

We’re building a relationship‑oriented bank for the modern world.We need talented, passionate professionals who are dedicated to doing what’s right for our clients. At CIBC, we embrace your strength...Show more

Last updated: 2 days ago • Promoted

Senior Backend Engineer

Intellistack • Toronto

Full-time

Senior Backend Engineer at Intellistack.At Intellistack, we're committed to revolutionizing the way organizations collect information, automate workflows, and create seamless digital experiences.Fo...Show more

Last updated: 1 day ago • Promoted

Senior Data Engineer

Scene+ • Toronto, ON, Canada

Full-time

At Scene+, we foster an entrepreneurial spirit that drives our mission : making tomorrow even more rewarding for our members. As a unique joint venture between Cineplex, Empire, and Scotiabank, and a...Show more

Last updated: 30+ days ago • Promoted

Senior Data Engineer, Integrations

Queer Tech • Vancouver, Calgary, Toronto

Full-time

Summary : • •# • •What your team does : • • • •A day in the life might look like : • • • Implement data ingestion techniques (streaming and batch) using best practices in data modeling, ETL / ELT processes by lev...Show more

Last updated: 8 days ago • Promoted

Senior Mainframe & DataOps Engineer - 24x7 On-Call

Sun Life Financial • Toronto

Full-time

A leading financial services company located in Toronto is seeking a Senior Support Engineer to maintain and support its Data Warehouse and Business Intelligence systems. This role requires 5+ years...Show more

Last updated: 8 days ago • Promoted

Senior Analyst

Vaco by Highspring • Richmond Hill, Ontario, Canada

Temporary

Our client is sourcing a Senior Analyst for a 6-month contract.Responsible for month-end, quarter-end, and annual close process in accordance with company requirements. Responsible for expense reimb...Show more

Last updated: 21 days ago • Promoted

Senior Database Engineer

G Adventures • Toronto

Full-time

G Adventures is the world’s largest small-group adventure travel company and we’ve been making epic travel memories happen on all seven continents for over 30 years. Our mission is simple : to change...Show more

Last updated: 28 days ago • Promoted

Principal Engineer - Distributed Database

Huawei Canada • Markham

Full-time +2

Principal Engineer - Distributed Database.Be among the first 25 applicants.Principal Engineer - Distributed Database.Get AI-powered advice on this job and more exclusive features.Huawei Canada has ...Show more

Last updated: 28 days ago • Promoted

Staff Site Reliability Engineer, Database

Alpaca • Toronto, ON, Canada

Full-time

Alpaca is a US-headquartered self-clearing broker-dealer and brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, 24 / 5 trading, and more. Our recent Series C funding round broug...Show more

Last updated: 30+ days ago • Promoted

Senior Data Engineering Lead

CGI • Toronto, ON, Canada

Full-time

This role is hybrid and requires you to be at our / client office at a minimum of 5 days a month- subject to change at any time. CGI is seeking an experienced Senior Data Engineer Lead to join our B...Show more

Last updated: 6 days ago • Promoted

Senior Data Engineering Consultant

CGI • Toronto, ON, Canada

Full-time

Senior Data Engineering Consultant.This role is hybrid and requires you to be at our client office =at a minimum 3 days per week - subject to change at any time. Your future duties and responsibilit...Show more

Last updated: 6 days ago • Promoted

Database Architect

Hays • Richmond Hill, Ontario, Canada

Full-time

DBA functions, and solution architecture.Strong proficiency in SQL, CockroachDB, PostgreSQL.Strong performance-tuning expertise for distributed and high-throughput systems.Understanding of microser...Show more

Last updated: 7 hours ago • Promoted • New!

Senior ETL & Data Integration Engineer

Scotiabank • Toronto

Full-time

A leading bank in North America is seeking a Sr.Data Integration and Development Engineer to join their Toronto team.The role involves leading ETL processes, collaborating with technical teams, and...Show more

Last updated: 6 days ago • Promoted

Software Engineer - Distributed Database

Huawei Technologies Canada Co., Ltd. • Markham

Full-time +1

Huawei Canada has an immediate 12-month contract opening for a Software Engineer.The Distributed Data Storage and Management Lab leads research in distributed data systems, aiming to develop next-g...Show more

Last updated: 8 days ago • Promoted

Senior Azure Cloud Architect (MSP)

Venture Computers of Canada Inc. • Markham, ON, Canada

Full-time

We are seeking a Senior Azure Architect to join our Toronto-based Managed Service Provider team.In this role, you will lead the design, implementation, and management of Azure cloud environments fo...Show more

Last updated: 26 days ago • Promoted

Senior Database Infrastructure & Cloud Platforms Lead

Canadian Imperial Bank of Commerce • Toronto

Full-time

A leading financial institution in Toronto is seeking a Senior Consultant in Database Infrastructure & Cloud Platforms.This role involves providing technical leadership in database design, particul...Show more

Last updated: 7 days ago • Promoted

Senior Azure Cloud Engineer

Venture Computers of Canada Inc. • Markham, ON, Canada

Full-time

Venture is currently seeking a Senior Azure Cloud Engineer to join our growing MSP team.This high-level role is primarily focused on leading internal Azure initiatives (with some client-facing enga...Show more

Last updated: 30+ days ago • Promoted

Senior Database / Data Modelling Developer

Synechron • Toronto, On

Full-time

At Synechron, we believe in the power of digital to transform businesses for the better.Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital ...Show more

Last updated: 6 days ago • Promoted