Job Description

Do you have experience in the design and development of Oracle (12c) for both OLAP and OLTP applications? Are you skilled in PL/SQL, stored procedures, packages, functions, triggers, ref cursors, dynamic SQL, and DBMS packages? Do you have strong SQL skills, and a solid background in database architecture, design, modeling, and query optimization? If so, this could be a great opportunity for you!

Our client is seeking a Senior Software Developer for a 9-month contract based in Toronto. This is a hybrid role—3 days onsite and 2 days remote each week are mandatory.

Advantages
- Hybrid Schedule – Balance your week with 3 days onsite and 2 days remote
- Long-Term Project – 9-month contract with strong potential for extension

Responsibilities
Develop coding, testing, and debugging to support existing extensions/tools such as IRT, De-Dup, OIA, Immunization Forecaster and PR Upload
Conduct technical analysis, preparation of detailed programming specifications, program design, writing and/or generating code, and conduct unit tests
Translate technical specifications for sustainment and upgrade into working, tested applications

Undertake proof of technology with test data to simulate application load and performance tuning related applications
Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
Provide impact analysis, effort estimate and solution design/development for supported solutions due to DHIR solution upgrades, software upgrades or any new requirements (e.g. Panorama 4.4 upgrades, PHU merge and more)
Provide application programming support for incident management, application functionality sustainment, performance tuning and technical documentation
Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services
Maintain Development environments and continue continuous Integration (CI) practice
Improve the quality and accuracy of the data collected for the approximately 34 PHUs and 2282 PHU users
Ensure availability of the DHIR extensions/tools for use by all Ontarians.

Qualifications
Must Haves:

15+ years of experience with:

· Design and development of Oracle(12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedure, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
· Demonstrated ability to create normalized database schemas utilizing data modeling discipline. Understanding of normalization, de-normalization, and the difference between the two. Ability to create schemas for both OLTP and OLAP databases.
· Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
· Data Warehouse design and development, Database performance tuning, Automation

Summary
If you're interested in the Senior Software Developer role in Toronto, please apply online at Only qualified candidates will be contacted.

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

Job Tags

Contract work, 2 days per week,

Similar Jobs