Talent.com
SQL Database Developer with Data Modelling Toronto, ON Fulltime opportunity
SQL Database Developer with Data Modelling Toronto, ON Fulltime opportunityZodiac Solutions • Toronto, Ontario, Canada
SQL Database Developer with Data Modelling Toronto, ON Fulltime opportunity

SQL Database Developer with Data Modelling Toronto, ON Fulltime opportunity

Zodiac Solutions • Toronto, Ontario, Canada
17 days ago
Job type
  • Full-time
Job description

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 :

  • Bachelors 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 Kumar

    Key Skills

    Databases,SQL Server Management Studio,SQL,.NET,Microsoft SQL Server,ssrs,TFS,Database Design,Performance Tuning,SSIS,T Sql,Data Warehouse

    Employment Type : Full Time

    Experience : years

    Vacancy : 1

    Create a job alert for this search

    Database Developer • Toronto, Ontario, Canada

    Similar jobs
    Senior Java Developer with SQL

    Senior Java Developer with SQL

    Jay Analytix • Toronto, ON, Canada
    Full-time
    Design and develop large-scale applications.Developing and testing, working on software analysis, troubleshooting, and debugging. System designing and Financial Industry Software development.Ensure ...Show more
    Last updated: 30+ days ago • Promoted
    Senior Database Architect & Data Modeling Lead

    Senior Database Architect & Data Modeling Lead

    Scotiabank • Toronto
    Full-time
    A leading bank in the Americas is seeking a Database Architect in Toronto.This role involves designing and maintaining scalable database solutions and data modeling to enhance business performance....Show more
    Last updated: 9 days ago • Promoted
    MSSQL Database Administrator

    MSSQL Database Administrator

    NPO USA • Toronto, ON, Canada
    Full-time
    Senior DBA (Microsoft SQL Server).Lead installation, configuration, maintenance, performance tuning, and troubleshooting of SQL Server instances. Design and operate HA / DR solutions (Failover Cluster...Show more
    Last updated: 21 days ago • Promoted
    Technical Lead, Data & Analytics - ETL & SQL Expert

    Technical Lead, Data & Analytics - ETL & SQL Expert

    CGI • Toronto
    Full-time
    A leading technology consulting firm is seeking an experienced Technical Lead in Toronto.This hybrid role involves data extraction and analysis, with responsibilities including managing complex dat...Show more
    Last updated: 22 hours ago • Promoted • New!
    Hybrid Cloud & Data Engineer (GCP, Spark, SQL)

    Hybrid Cloud & Data Engineer (GCP, Spark, SQL)

    TransUnion • Toronto
    Full-time
    A global information solutions firm is seeking an experienced Data Engineer for its hybrid role in Toronto.Candidates should possess strong expertise in data engineering, cloud platforms like Googl...Show more
    Last updated: 14 days ago • Promoted
    Database Engineer

    Database Engineer

    Pixomondo • Toronto, ON, Canada
    Full-time
    We’re looking for a seasoned Database Engineer to join our.In this role, you will be responsible for ensuring performance, reliability, and scalability of our data layer, as well as contribut...Show more
    Last updated: 30+ days ago • Promoted
    Sr. Data engineer KATDC5697872

    Sr. Data engineer KATDC5697872

    Compunnel Inc. • markham, on, ca
    Full-time
    Deep expertise in relational databases (Snowflake, PostgreSQL, Amazon Aurora), big data platforms (Hadoop), and NoSQL databases (MongoDB). Advanced proficiency in data visualization tools such as Sn...Show more
    Last updated: 4 days ago • Promoted
    Data Warehouse Developer

    Data Warehouse Developer

    Celestica • Toronto
    Full-time
    The Data Warehouse Developer is responsible for designing, developing, and maintaining scalable and efficient data warehousing solutions. This role is crucial for enabling data-driven decision-makin...Show more
    Last updated: 14 days ago • Promoted
    Senior Java Developer with SQL

    Senior Java Developer with SQL

    Jay Analytix INC. • Toronto, Canada
    Full-time
    Responsibilities : Design and develop large-scale applications.Develop and test software, including analysis, troubleshooting, and debugging. System design and development of Financial Industry Softw...Show more
    Last updated: 30+ days ago • Promoted
    Senior NoSQL Data Engineer — High-Volume Pipelines

    Senior NoSQL Data Engineer — High-Volume Pipelines

    Theory Ventures • Toronto
    Full-time
    A leading data solutions company is hiring a Senior Software Engineer to improve the performance of their NoSQL data pipeline services in Toronto. The role requires Java expertise and experience wit...Show more
    Last updated: 22 hours ago • Promoted • New!
    Senior ETL Architect : Azure Data Factory & Oracle PL / SQL

    Senior ETL Architect : Azure Data Factory & Oracle PL / SQL

    Maarut Inc • Toronto, Canada
    Full-time
    An innovative IT services firm is seeking a talented data integration specialist to join their dynamic team.In this mid-senior level role, you will leverage your extensive experience in ETL process...Show more
    Last updated: 30+ days ago • Promoted
    Senior SQL Database / Data Modelling Developer

    Senior SQL Database / Data Modelling Developer

    Synechron • Toronto, Canada
    Full-time
    This range is provided by Synechron.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Direct message the job poster from Synechron.At Synechron, w...Show more
    Last updated: 21 days ago • Promoted
    Data Engineer (Python, GCP) - Contract - Toronto

    Data Engineer (Python, GCP) - Contract - Toronto

    CorGTA • Toronto, ON, Canada
    Full-time
    Role : Data Engineer (Fortune 1000 Client).Structure : Contract (6months initially then extension options).Location : Toronto, ON (Hybrid 2-3days in office per week). We currently have an opportunity f...Show more
    Last updated: 19 days ago • Promoted
    Sr. Data engineer KATDC5697872 - markham

    Sr. Data engineer KATDC5697872 - markham

    Compunnel Inc. • markham, on, ca
    Full-time
    Deep expertise in relational databases (Snowflake, PostgreSQL, Amazon Aurora), big data platforms (Hadoop), and NoSQL databases (MongoDB). Advanced proficiency in data visualization tools such as Sn...Show more
    Last updated: 4 days ago • Promoted
    Senior SQL Engineer

    Senior SQL Engineer

    SuperAnnotate • Newmarket, Ontario, CA
    Remote
    Full-time
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Show more
    Last updated: 20 hours ago • New!
    Senior SAP Basis & Oracle DBA Consultant

    Senior SAP Basis & Oracle DBA Consultant

    Capgemini • Toronto
    Full-time
    A leading global consulting firm is seeking a Senior Applications Consultant specializing in SAP Basis with a strong Oracle DBA skillset. This role involves daily support of SAP Systems and proactiv...Show more
    Last updated: 14 days ago • Promoted
    Data Architect with AWS Data Lake & Redshift

    Data Architect with AWS Data Lake & Redshift

    Ward Technology Talent • Toronto
    Full-time
    Data Architect with AWS Data Lake & Redshift.Contract | Toronto / GTA, ON | February 14, 2025.As a member of the Applied Architecture group and working for the Data Hub project as a Data Architect, p...Show more
    Last updated: 14 days ago • Promoted
    Senior Data Scientist | SQL / Python Data Analytics Contract

    Senior Data Scientist | SQL / Python Data Analytics Contract

    VySystems • Toronto, Canada
    Full-time
    A global investment firm is seeking a Data Scientist based in Toronto, Ontario, to drive data-driven insights.The ideal candidate must have over 6 years of experience in data analytics, strong SQL ...Show more
    Last updated: 3 days ago • Promoted