Software Developer(Oracle) - Senior Shweta (Winnipeg)

Software Developer(Oracle) - Senior Shweta (Winnipeg)

16 Nov
|
A.T. Consulting u0026 Recruiting
|
Winnipeg

16 Nov

A.T. Consulting u0026 Recruiting

Winnipeg

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

Start Date

2026-12-14

End Date

2028-03-07

# Of Openings

2

Organization

Business Days

305.00

Max Extension Term(s)

1 Time

Street

5700 Yonge Street

Title

IT26 32654FG Sr Software Dev (x2) Voluntary Mergers PHUs

NOTE

Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value, including any extension options set out in the original SOW.

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.

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⁢ Project Methodology, OPS Enterprise Architecture and OPS Gating process, and OPS Standard Systems Development Methodologies.

5 points

Technical Skills

Design and development of Oracle(12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedure, packages, functions, triggers, ref cursors, energetic 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

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

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

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.

📌 Software Developer(Oracle) - Senior Shweta (Winnipeg)
🏢 A.T. Consulting u0026 Recruiting
📍 Winnipeg

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: software developer(oracle) - senior shweta (winnipeg) / winnipeg

Subscribe to this job alert:

Get the latest job offers by email for: software developer(oracle) - senior shweta (winnipeg) / winnipeg