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 robust 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.

Thanks,Sanjay [email protected]

📌 SQL Database Developer with Data Modelling - Toronto, ON - Fulltime opportunity
🏢 CareerBeacon
📍 Toronto