5700 Yonge Street, Toronto (Yonge Street & Finch Avenue, close to Finch Subway Station)

Hybrid (3 days onsite, 2 days remote)

Contract (9 months)

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
• Unix/Linux Shell Scripting
• Cognos report design and development, Framework manager, Query Studio, Reports Studio, creation of dashboards, etc. Other reporting tools would also be an asset, particularly Crystal Reports and Business Objects
• Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web services'