This role is for a Senior Software Developer with specialized experience in enterprise database management, data migration, and Azure-based ETL development. The work focuses on supporting the modernization of digital criminal justice services through the transformation of legacy systems. Responsibilities include end-to-end data migration from Or
...
acle to Azure SQL Server, database performance tuning, secure administration of high-sensitivity databases, and implementation of CI/CD processes. The role also involves continuous monitoring, optimization of data pipelines using Azure Data Factory, and the development of comprehensive documentation for data governance, migration, and system integration efforts.
Advantages
•Hands-on role in a large-scale digital modernization program
•Hybrid work setup with collaborative cross-functional teams
•Exposure to cutting-edge Azure cloud technologies and DevOps tools
•Opportunity to design and implement scalable, high-performance data solutions
•Experience working on sensitive and high-impact digital justice services
Responsibilities
•Analyze, design, and execute the migration of large volumes of sensitive data from Oracle to Azure SQL Server
•Design and build ETL pipelines using Azure Data Factory, SSMA, and Database Migration Services
•Perform data mapping, transformation, cleansing, validation, and reconciliation
•Optimize and monitor database performance, ensuring high availability and security
•Support and document DevOps-based CI/CD processes for data workflows and Azure environments
•Develop technical documentation, transformation logic, and data migration scripts
•Provide post-migration support and assist with production operations and data quality assurance
•Conduct testing, define KPIs, and support integration with applications such as Criminal Intake and DIR
Qualifications
•5+ years experience with RDBMS, Azure SQL Server, and database performance tuning
•5+ years in ETL development, data pipeline design, and Azure Data Factory implementation
•Proficiency in T-SQL, PL/SQL, scripting with PowerShell or Azure CLI
•Experience with CI/CD tools, Azure DevOps, Synapse workspaces
•Strong understanding of Azure data architecture, security, and resource configuration
•(Nice to have) Azure certifications such as Azure Data Engineer Associate or Azure Database Administrator Associate
•Familiarity with Oracle DB administration and tools like PowerDesigner or ERWIN
Summary
This Senior Software Developer role is an excellent opportunity to lead complex data migration and transformation efforts in a dynamic Azure-based environment. The position offers a chance to contribute to high-impact digital justice initiatives while applying advanced technical expertise in database architecture, ETL, and cloud data solutions.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
This role is for a Senior Software Developer with specialized experience in enterprise database management, data migration, and Azure-based ETL development. The work focuses on supporting the modernization of digital criminal justice services through the transformation of legacy systems. Responsibilities include end-to-end data migration from Oracle to Azure SQL Server, database performance tuning, secure administration of high-sensitivity databases, and implementation of CI/CD processes. The role also involves continuous monitoring, optimization of data pipelines using Azure Data Factory, and the development of comprehensive documentation for data governance, migration, and system integration efforts.
Advantages
•Hands-on role in a large-scale digital modernization program
•Hybrid work setup with collaborative cross-functional teams
•Exposure to cutting-edge Azure cloud technologies and DevOps tools
•Opportunity to design and implement scalable, high-performance data solutions
•Experience working on sensitive and high-impact digital justice services
Responsibilities
•Analyze, design, and execute the migration of large volumes of sensitive data from Oracle to Azure SQL Server
...
•Design and build ETL pipelines using Azure Data Factory, SSMA, and Database Migration Services
•Perform data mapping, transformation, cleansing, validation, and reconciliation
•Optimize and monitor database performance, ensuring high availability and security
•Support and document DevOps-based CI/CD processes for data workflows and Azure environments
•Develop technical documentation, transformation logic, and data migration scripts
•Provide post-migration support and assist with production operations and data quality assurance
•Conduct testing, define KPIs, and support integration with applications such as Criminal Intake and DIR
Qualifications
•5+ years experience with RDBMS, Azure SQL Server, and database performance tuning
•5+ years in ETL development, data pipeline design, and Azure Data Factory implementation
•Proficiency in T-SQL, PL/SQL, scripting with PowerShell or Azure CLI
•Experience with CI/CD tools, Azure DevOps, Synapse workspaces
•Strong understanding of Azure data architecture, security, and resource configuration
•(Nice to have) Azure certifications such as Azure Data Engineer Associate or Azure Database Administrator Associate
•Familiarity with Oracle DB administration and tools like PowerDesigner or ERWIN
Summary
This Senior Software Developer role is an excellent opportunity to lead complex data migration and transformation efforts in a dynamic Azure-based environment. The position offers a chance to contribute to high-impact digital justice initiatives while applying advanced technical expertise in database architecture, ETL, and cloud data solutions.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
