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

Senior Database and Integration Engineer

Insight Global • Toronto, ON, CA

27 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

Manager, Database Engineering

Rogers Communications, Inc. • Toronto

Full-time +1

Looking to join a growing financial services team? Rogers Bank, a subsidiary of Canada's leading wireless, cable and media company, is expanding and seeking passionate individuals to develop and im...Show more

Last updated: 30+ days ago • Promoted

Manager, Database Engineering

Rogers Communications • Toronto

Full-time +1

Last updated: 30+ 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: 5 days ago • Promoted

Senior Database Lead : Raiser's Edge & Grants Management

Children's Aid Foundation of Canada • Toronto C6A, ON, Canada

Remote

Full-time

A charitable organization in Toronto is seeking a Senior Manager, Database to oversee data management, integrity, and reporting for fundraising efforts. The role requires strong leadership in managi...Show more

Last updated: less than 1 hour ago • Promoted • New!

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: 13 days ago • Promoted

Senior Software Engineer

VAST Data • Toronto C6A, ON, Canada

Full-time

VAST Data is looking for a Core Database Developer (Database Internals) to join our growing team.This is a great opportunity to be part of one of the fastest‑growing infrastructure companies in his...Show more

Last updated: 30+ days ago • Promoted

Senior MSSQL Database Architect & Performance Engineer

Jobility Talent Solutions • Toronto

Full-time

A staffing and recruiting firm is seeking a Senior Database Developer in Toronto, Ontario.This mid-senior level contract position requires strong hands-on experience in MS SQL Server and expertise ...Show more

Last updated: 1 day 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: 13 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: 30+ days ago • Promoted

Senior Software Engineer - Databases

Theory Ventures • Toronto C6A, ON, Canada

Remote

Full-time

From Fivetran’s founding until now, our mission has remained the same : to make access to data as simple and reliable as electricity. With Fivetran, customer data arrives in their warehouses, canonic...Show more

Last updated: 28 days ago • Promoted

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: 11 days ago • Promoted

Senior Oracle E-Business Suite DBA – Onsite Downtown Toronto

Nexus Systems Group Inc. • Toronto

Full-time

A technology solutions company in Toronto is seeking a Senior Database Administrator.The role involves expertise in Oracle E-Business Suite installation and migration to cloud infrastructure.Respon...Show more

Last updated: 22 hours ago • Promoted • New!

Senior Database Engineer for Global SaaS Platform

Telna • Toronto

Full-time

A leading telecommunications company is looking for an experienced Database Engineer to optimize data infrastructure for their Network as a Service platform. The role requires 5+ years of experience...Show more

Last updated: 13 days ago • Promoted

Senior Data Integration Engineer

Connor, Clark & Lunn Financial Group (CC&L) • Toronto

Full-time

Senior Data Integration Engineer.Connor, Clark & Lunn Financial Group (CC&L).About The Role : CC&LFG is building an AI Enablement Team to accelerate the responsible adoption of AI across the organiz...Show more

Last updated: 30+ 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: 13 days ago • Promoted

Senior Data Engineer

SRI Tech Solutions Inc. • Toronto

Full-time

Get AI-powered advice on this job and more exclusive features.This range is provided by SRI Tech Solutions Inc.Your actual pay will be based on your skills and experience — talk with your recruiter...Show more

Last updated: 30+ days ago • Promoted

Senior Consultant, Database Infrastructure & Cloud Platforms

CIBC • Toronto

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: 8 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: 12 days ago • Promoted