Senior Software Developer - North York

Randstad Canada

Toronto

On-site

CAD 150,000 - 190,000

Full time

5 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Long-term engagement
Onsite workspace in Toronto
Healthcare/enterprise impact
Collaborative team environment

Job summary

Randstad Canada is seeking an experienced Senior Software Developer to lead design, development, and sustainment of enterprise database and application solutions in Toronto. You will translate complex specifications into scalable Oracle OLTP/OLAP architectures, data warehouse pipelines, and integrated extensions.

The role focuses on performance tuning, ETL, and enterprise reporting, with onsite collaboration in Toronto for a 15-month contract.

Qualifications

  • Oracle/PLSQL development for OLAP/OLTP
  • Strong SQL, data modeling, and performance tuning
  • Design/architect normalized and de-normalized schemas
  • Translate business requirements into data/app designs
  • ETL workflows with Informatica and scripting
  • CI/DevOps and production support across SDLC

Responsibilities

  • Design, develop, and maintain Oracle DB solutions for OLAP/OLTP
  • Architect data models and optimize complex SQL queries
  • Build data warehouse structures and ETL workflows
  • Collaborate with business analysts to translate requirements
  • Develop, test, and sustain application extensions and integrations
  • Conduct impact analyses and estimations for upgrades/merges
  • Perform load testing and performance tuning exercises
  • Provide Tier-3 production support and incident resolution
  • Maintain CI and system documentation

Skills

Oracle Database & PL/SQL Development
Advanced SQL & Data Architecture
Data Warehousing & Performance Tuning
Requirements-to-Design Translation
ETL, Scripting & Reporting Tooling
Full-Lifecycle Software Engineering

Tools

Informatica
Unix/Linux shell scripting
Cognos

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.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Master of Environmental Science Internship Coordinator
Master of Environmental Science Internship Coordinator

University of Toronto • Toronto

Hybrid
CAD 100,000 - 156,000
Healthcare analytics
Cloud data stack
Data linkage
+1
Senior Oracle PL/SQL Developer
Senior Oracle PL/SQL Developer

Russell Tobin • Toronto

On-site
CAD 110,000 - 117,000
Senior Software Developer - CRM - Toronto
Senior Software Developer - CRM - Toronto

Randstad Canada • Toronto

On-site
CAD 110,000 - 150,000
Onsite in Toronto
4‑month contract
Collaborative project teams in Toronto
Senior Business Analyst - Toronto
Senior Business Analyst - Toronto

Randstad Canada • Toronto

On-site
CAD 83,000 - 131,000
Senior Cloud Development and Administration Specialist
Senior Cloud Development and Administration Specialist

Randstad Canada • Toronto

Hybrid
CAD 120,000 - 180,000
AI tool integration
Full-stack scope
DevOps leadership
+1
Software Developer - Senior (Oracle/OLAP and OLTP)
Software Developer - Senior (Oracle/OLAP and OLTP)

Bevertec • Toronto

On-site
CAD 117,000 - 124,000
Software Developer - Enhance Ontario
Software Developer - Enhance Ontario

Scarborough Health Network • Canada

Hybrid
CAD 73,000 - 84,000
IT - Solutions Developer III
IT - Solutions Developer III

Randstad Canada • Toronto

Hybrid
CAD 134,000 - 161,000
Hybrid work model
Enterprise exposure
Senior Oracle Database Developer
Senior Oracle Database Developer

Bevertec • Toronto

On-site
CAD 124,000 - 138,000
Specialized IT Consultant - Senior
Specialized IT Consultant - Senior

Randstad Canada • Toronto

On-site
CAD 95,000 - 130,000