Database Programmer

Location Address: Hybrid - 44 King Street W 19th Floor, Toronto –2 days/week (Monday, Wednesday)

Subject to change: 3–4 days onsite may be required based on business needs

Contract Duration: ASAP to Oct 31, 2026 –approx. 6.5 months

Possibility of extension

Schedule Hours: 9am-5pm Monday-Friday;standard 37.5 hrs/week

Project: MS SQL Server Programming

The project focuses on MS SQL Server programming to enhance and expand a Master Data Management (MDM) system. The existing MDM stores and manages enterprise metadata. The team has recently developed the core MDM platform, and the next phase is to integrate an additional system and introduce new workflow functionality, specifically to support a multi step metadata approval process.

Two other teams manage the UI components;this role is fully backend-focused, responsible for designing the database layer, building backend logic, and supporting end to end metadata workflow processing.

When end users request changes to metadata, those changes move through a defined approval process involving multiple approval groups. Once approved, they are committed to the MDM system. Your work will enable and extend this workflow.

Typical Day in Role

• Conduct data, application, and workflow analysis
• Perform data modeling to define the appropriate structures for new requirements
• Design database objects (tables, views, functions, stored procedures)
• Develop and optimize T SQL code
• Ensure high-performance execution of queries and procedures
• Participate in meetings, requirement discussions, development, and debugging
• Work primarily in Microsoft SQL Server environments

Candidate Value Proposition

The successful candidate will gain hands-on experience with enterprise-level metadata management within a major Canadian bank. This system is central to key bank functions—including ERP platforms, data warehousing, and regulatory reporting—making this a high-impact opportunity within a critical domain.

Candidate Requirements/Must Have Skills

1. 8+ years SQL Server Database development and advanced T SQL programming

2. 7+ years experience in Data Modeling, Data Architecture, Data Integration, Data Interfaces, or Database Design

3. 7+ years hands-on Database/SQL performance tuning

4. 5+ years experience working with data models in ERP, CRM, or other large OLTP applications

Nice-To-Have Skills

1. Experience with ETL or BI tools such as SSIS, SSAS, Informatica, or DataStage

2. Experience with BI visualization tools: Power BI, Tableau, OBIEE

3. Solid understanding of Web Services, .NET, XML, SOAP, REST, APIs, or Java

4. Prior experience in financial services or banking

Education

• BSc degree in Computer Science or relevant information technology field

Best VS. Average Candidate

The ideal candidate is a strong SQL programmer who can go beyond querying data. They should be capable of designing backend database structures, developing stored procedures and functions, and architecting solutions that deliver the required functionality efficiently and with optimal performance.

Candidate Review & Selection –Interview Process

1 round: 1-hour MS Teams video interview with the Hiring Manager and Senior Manager, including technical SQL questions and a practical SQL programming test.