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