SQL Database Developer with Data Modelling Toronto, ON Fulltime opportunity

Zodiac Solutions

Not Interested
Bookmark
Report This Job

profile Job Location:

Toronto - Canada

profile Monthly Salary: Not Disclosed
Posted on: 3 hours ago
Vacancies: 1 Vacancy

Job Summary

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
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 data...
View more view more

Key Skills

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