Zodiac Solutions - 34 Jobs
Toronto, ON
Posted today
Job Details:
Remote
Full-time
Experienced
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.
Share This Job:
Frequently Asked Questions
This role is based in Toronto, ON and requires onsite day 1 with a hybrid arrangement of 4 days from the office.
This is a full-time opportunity.
Responsibilities include designing, developing, and optimizing SQL queries, maintaining schemas and indexes, collaborating with analysts and architects, ensuring security and compliance, performing data modeling and performance tuning, and supporting ETL and data migration.
A bachelor's degree and 10+ years of experience with SQL Server or similar databases, along with experience in database design, modeling, and ETL concepts.
Experience with Memsql, Gridgain or other caching solutions is a big plus, along with Unix scripting, ETL tools, data warehousing concepts, and scripting like PowerShell or Python.
The role requires ensuring database integrity, security, and compliance with banking regulations such as GDPR and PCI DSS.
