Senior Software Developer (Toronto)

Senior Software Developer (Toronto)

21 Nov
|
randstad canada
|
Toronto

21 Nov

randstad canada

Toronto

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 energetic 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.

📌 Senior Software Developer (Toronto)
🏢 randstad canada
📍 Toronto

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior software developer (toronto) / toronto

Subscribe to this job alert:

Get the latest job offers by email for: senior software developer (toronto) / toronto