Job Details: Remote Full-time Experienced Sr. Software Developer (Oracle, SQL, Unix/Linux, Java, HL7/FHIR) 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' #Information Technology jobs