20 Nov
|
randstad canada
|
Toronto
20 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 agile 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 /
📌 Senior Software Developer (Toronto)
🏢 randstad canada
📍 Toronto