Original job description
We are seeking an experienced Senior Software Developer to lead the technical design, development, optimization, and ongoing sustainment of mission-critical enterprise database and application solutions. In this role, you will partner with business analysts and cross-functional technical teams to translate complex functional specifications into scalable OLAP and OLTP Oracle database architectures, automated data warehouse pipelines, and integrated application extensions. Leveraging deep expertise in Oracle (12c+), PL/SQL, performance tuning, ETL processes, and enterprise reporting platforms, you will support system upgrades, troubleshoot production incidents, maintain continuous integration workflows, and ensure high availability and data accuracy across large-scale healthcare and clinical ecosystems.
Location: Toronto, ON (Fully Onsite – 5 days/week required)
Duration: 15-month contract.
Advantages
Long-Term Engagement: Secure a stable 15-month contract leading high-impact enterprise database and software development.
Complex Data Architecture Scope: Own end-to-end Oracle OLTP/OLAP design, data warehousing, ETL pipelines, and performance tuning.
Mission-Critical Healthcare Impact: Directly enhance data integrity and availability for large-scale clinical and public health systems.
Collaborative Onsite Workspace: Partner closely with multidisciplinary developers, analysts, and QA specialists in Toronto.
Responsibilities
Design, develop, and maintain Oracle (12c+) database solutions for OLAP and OLTP environments, including complex PL/SQL code, stored procedures, packages, functions, triggers, ref cursors, and dynamic SQL.
Architect normalized and de-normalized database schemas, execute advanced SQL query optimization, and implement database performance tuning and automation scripts.
Design, build, and maintain data warehouse structures and ETL workflows using Informatica and Unix/Linux shell scripting.
Collaborate with business analysts to translate business requirements and functional specifications into comprehensive application designs, programming specifications, and data models.
Develop, test, debug, and sustain custom application extensions, data deduplication routines, and integration services supporting mission-critical health systems.
Conduct technical impact analyses, effort estimations, and solution designs for major software upgrades, system merges, and evolving operational requirements.
Perform proof-of-technology load simulations and performance tuning exercises to ensure system scalability and responsiveness.
Provide Tier-3 production application support, root-cause troubleshooting, incident management, and bug resolution alongside Quality Assurance (QA) teams.
Maintain development environments, adhere to Continuous Integration (CI) and DevOps best practices, and author clear technical system documentation.
Build and support enterprise reports and dashboards utilizing Cognos (Framework Manager, Report Studio, Query Studio) and related reporting tools.
Qualifications
Oracle Database & PL/SQL Development: 10+ years of hands-on experience designing and developing Oracle (12c+) solutions for OLAP and OLTP applications, including PL/SQL, stored procedures, packages, functions, triggers, ref cursors, dynamic SQL, and DBMS packages (Strictly Required).
Advanced SQL & Data Architecture: 10+ years of proven expertise in advanced SQL, query optimization, data architecture, database design, and normalized/de-normalized data modeling (Strictly Required).
Data Warehousing & Performance Tuning: Demonstrated experience in data warehouse design and development, database performance tuning, and process automation (Strictly Required).
Requirements-to-Design Translation: Proven track record collaborating with business analysts to translate business requirements and functional specifications into scalable application and database designs (Strictly Required).
ETL, Scripting & Reporting Tooling: Hands-on experience with Informatica for ETL workflows, Unix/Linux shell scripting, and Cognos report/dashboard development (Strictly Required).
Full-Lifecycle Software Engineering: Extensive experience working across the complete Software Development Life Cycle (SDLC), including multi-tier applications, RESTful web services, JSON/XML, Continuous Integration (CI), and production incident support (Strictly Required).
Nice-to-Have Assets:
Prior experience working with federal, provincial, or broader public-sector healthcare providers and clinical IT systems (such as client/provider registries or immunization platforms).
Familiarity with healthcare data exchange standards (HL7 / FHIR) and Java web service integrations.
Knowledge of digital accessibility standards (WCAG / AODA) and formal enterprise architecture governance processes.
Summary
If you're interested in the "Senior Software Developer" role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!
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.
This posting is for existing and upcoming vacancies.
