SQL Database Developer with Data Modelling - Toronto, ON - Fulltime opportunity

The Role: SQL Database Developer with Data Modelling

Location: Toronto, ON (Need Onsite day 1, hybrid 4 days from office)

Duration: Fulltime opportunity

Job Description:

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.

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., PowerShell, 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.