Job Title: Sr. Software Developer
Location: 5700 Yonge Street, Toronto ( Hybrid - Candidate MUST work 3 days onsite and 2 days remote)
Duration: 8 months with possible extension
 
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

 
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.

 
Skills
Experience and Skill Set Requirements

Public Sector Experience	Experience working with federal/provincial/broader public-sector healthcare providers Knowledge of the provincial immunization system and Public Sector large complex IT Health related projects or equivalent Experience with integration of Clinical IT Systems such as Client and Provider Registries Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices Knowledge of industry standard such as Project Management Institute (PMI) ·       Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies.	5 points
Technical Skills	10+ 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 Informatica for data extraction, transformation, and loading, initial setup and other data management purposes 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 ·       Knowledge of the provincial immunization system.	45 points
?Core Skills and Experience	10+ years of experience with: Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs Working with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications Analysis, design and development work on complex, multi-tier web-based applications, micro-services architecture, mobile, and off-the-shelf solutions Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions Designing, developing and implementing applications that work across modern browsers and various platforms, and mobile devices Using and applying extensive knowledge of User Interface (UI) design principles across a variety of applications, platforms and devices Technical analysis, program code, detailed programming and reports specifications, program design, writing and/or generating code, and conducting tests Developing and maintaining system design models, technical documentation and specifications Conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements/specifications/documentation Developing medical and clinical based systems Web performance optimization Various computing platforms, operating systems, database technology, communication protocols, middleware and gateways Conducting technical analysis, trouble-shooting, and issue resolutions for production operational support of reports, and other components and utilities Knowledge of recognized accessibility laws, regulations, and standards (e.g., W3C, WCAG) or other specific accessibility standards, and experience in usability, accessibility and compliance testing Ensuring compliance with architecture framework and system standards, and Agile Development Methodology Project management practices, and ability to contribute to design/development project plans, including work breakdown, resource estimates, and status reports Experience with Software Development Lifecycle (SDLC) Continuous Integration (CI) practice and DEVOPS methodologies and technologies Knowledge and experience with leading-edge technologies, design criteria including usability, security, and privacy for web and mobile applications.	20 points
?General Skills	Demonstrated strong leadership and people management skills Exceptional analytical, problem solving and decision-making skills Demonstrated strong interpersonal, verbal and written communication, and presentation skills Proven troubleshooting and critical thinking experience Demonstrated ability to apply strong listening skills to facilitate issue resolution Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.	30 points

 
  

About Us: SPECTRAFORCE is one of the fastest-growing workforce solutions firms in the United States. As a diversity-owned business, we place human connection at the heart of everything we do, building strong relationships with both clients and candidates to fill roles successfully. Our teams in North and Central America and India serve more than 150 Fortune clients globally, leveraging custom AI technology to provide direct hire, executive search, nearshoring, offshoring, and project staffing solutions.
 
Benefits: SPECTRAFORCE offers a Group Registered Retirement Savings Plan (RRSP) Program to all eligible employees. We also offer an Employee Assistance Program (EAP) and an employee discount program, which provides exclusive access to thousands of discounts on travel, entertainment, and more. SPECTRAFORCE offers unpaid leave as well as paid sick leave, paid holidays, and paid vacation as required by law.

Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant based on race, national or ethnic origin, colour, religion, age, sex, sexual orientation, gender identity or expression, marital status, family status, genetic characteristics, disability, conviction for an offence for which a pardon has been granted or in respect of which a record suspension has been ordered, or any other prohibited grounds as identified by provincial or territorial law. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation. 


At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $550.00/hr.