SQL Database Developer (Fintech)

TL;DR

SQL Database Developer (Fintech): Designing, developing, and optimizing complex SQL queries, stored procedures, and database schemas to support banking operations with an accent on database integrity, security, and compliance with banking regulations. Focus on data modeling, performance tuning, and resolving database-related issues for high availability.

Location: Hybrid in Toronto, ON, Canada

Salary: CAD $100,000–$110,000/year

Company

hirify.global is a global consulting firm specializing in digital transformation for financial services and technology firms.

What you will do

• Design, develop, and optimize complex SQL objects (queries, stored procedures, functions, triggers) for 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.
• Work with ETL tools and processes to support data migration and integration.

Requirements

• 9+ years of experience with SQL Server or similar databases.
• Experience with database design, modeling, and ETL processes and data warehousing concepts.
• Proficiency in Unix scripting.
• Fluent in English communication.
• Ability to work in fast-moving projects with a global team.
• Bachelor's degree in Computer Science, Information Technology, or a related field.

Nice to have

• Experience with Memsql, Gridgain, or other caching solutions.
• Proficiency in scripting (e.g., PowerShell, Python).
• 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).

Culture & Benefits

• Flexible hybrid work policy.
• Comprehensive insurance plan including medical, dental, vision, life insurance, and long-term disability.
• 15 days of paid annual leave plus an additional 10 days of personal leave.
• RRSP with employer’s contribution up to 4%.
• Higher education certification policy and free access to Udemy for Business courses.
• Coaching opportunities with experienced colleagues from FinLabs and Center of Excellences.
• Cutting-edge projects at world’s leading tier-one banks and financial institutions.