RQ11901 - Software Developer - Senior

Description:

• 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.
  

Requirements

Experience and Skill Set Requirements:

Must Have:

• 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.
  
• Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
  
• Data Warehouse design and development, Database performance tuning, Automation
  
• 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
  

Skill Set Requirements:

Public Sector Experience:

• Experience working with federal/provincial/broader public-sector healthcare providers
  
• Knowledge of the provincial immunization system and OPS large complex IT Health related projects or equivalent
  
• Experience with integration of Clinical IT Systems such as Client and Provider Registries
  
• Knowledge of OPS 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 OPS Unified I&IT Project Methodology, OPS Enterprise Architecture and OPS Gating process, and OPS Standard Systems Development Methodologies.
  

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.
  

​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.
  

​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.