MS SQL Server Database Programmer

Job Description

MS SQL Server Database Programmer:
On behalf of our Banking client, Procom is searching for a MS SQL Server Database Programmer for a 3 month contract role. This position is a hybrid position with 3-4 days onsite at our client’s Toronto office.

MS SQL Server Database Programmer - Job Description:
The project focuses on enhancing and expanding a Master Data Management (MDM) system using MS SQL Server programming. The existing MDM platform requires integration with an additional system and the introduction of new workflow functionality to support a multi-step metadata approval process. This role is fully backend-focused, responsible for designing the database layer and supporting end-to-end metadata workflow processing.

MS SQL Server Database Programmer - Responsibilities:
• 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

MS SQL Server Database Programmer - Mandatory Skills:
• 7+ years’ experience in Data Modeling, Data Architecture, Data Integration, Data Interfaces, or Database Design
• 4+ years SQL Server Database development and advanced T-SQL programming
• 4+ years hands-on Database/SQL performance tuning
• 4+ years’ experience working with data models in ERP, CRM, or other large OLTP applications

MS SQL Server Database Programmer – Nice-to-Have Skills:
• Experience with ETL or BI tools such as SSIS, SSAS, Informatica, or DataStage
• Experience with BI visualization tools: Power BI, Tableau, OBIEE
• Solid understanding of Web Services, .NET, XML, SOAP, REST, APIs, or Java
• Prior experience in financial services or banking

MS SQL Server Database Programmer – Assignment Length:
This is a contract position from ASAP to October 31, 2026, with the possibility of extension after FYE.

MS SQL Server Database Programmer - Start Date:
ASAP

MS SQL Server Database Programmer - Assignment Location:
Toronto, Ontario, Canada; hybrid role with 3-4 days in the office.

This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.