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...
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
View more
View less