Senior SQL Database​/Data Modelling Developer

This range is provided by Synechron. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range
CA$/yr - CA$/yr

Direct message the job poster from Synechron

We are

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 solutions. Synechron’s progressive technologies and optimization strategies span end‑to‑end Artificial Intelligence, Consulting, Digital, Cloud & Dev Ops, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our Fin Labs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile‑first applications and more.

Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,500+, and has 58 offices in 21 countries within key global markets.

We are seeking a highly experienced Senior SQL Database Developer to design, develop, optimize, and maintain complex SQL databases across our organization. The ideal candidate will have a strong background in database architecture, data modeling, and query optimization, with a focus on delivering reliable and high‑performing data solutions to support business operations.

Additional Information
* The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Toronto, ON is CAD $110k – CAD $120k/year & benefits (see below).

The Role
Responsibilities:
Design, develop, and optimize complex SQL queries, stored procedures, functions, and triggers to support banking operations.

Develop and maintain database schemas, tables, indexes, and views for transactional and analytical systems.

Collaborate with business analysts and system architects to translate business requirements into robust database solutions.

Ensure database integrity, security, and compliance with banking regulations (e.g., GDPR, PCI DSS).

Perform data modeling, database normalization, and performance tuning.

Monitor, troubleshoot, and resolve database‑related issues to ensure high availability and performance.

Work with ETL tools and processes to support data migration and integration.

Write and optimize SQL scripts to streamline daily banking operations and reporting tasks.

Maintain thorough documentation of database architecture, processes, and change management.

Assist in implementing backup, recovery, and disaster recovery strategies.

Contribute to continuous improvement initiatives to automate data handling processes.

Requirements:

Bachelor's degree in Computer Science, Information Technology, or related field.

10+ plus years’ experience with SQL Server or similar databases.

Experience with database design, modelling etc .

Experience with Memsql , Gridgain or other Caching solutions a big plus

Experience with Unix scripting.

Fluent in Communication.

Ability to work in fast moving projects with a global team.

Experience with ETL processes and data warehousing concepts.

Proficiency in scripting (e.g., Power Shell, Python) is a plus.

Excellent analytical, problem‑solving, and communication skills.

Preferred, but not required:

Certifications such as Microsoft Certified:
Data Analyst Associate or Oracle Database SQL Certified.

Familiarity with banking systems like Core Banking, Payment Systems, or Fraud Detection platforms.

Knowledge of cloud‑based database services (Azure SQL, AWS RDS) is advantageous.

We offer:

A multinational organization with 58 offices in 21 countries and the possibility to work abroad.

15 days (3 weeks) of paid annual leave plus an additional 10 days of personal leave (floating days and sick days).

A comprehensive insurance plan including medical, dental, vision, life insurance, and long‑term disability.

Flexible hybrid policy.

RRSP with employer’s contribution up to 4%.

A higher education…