Rq11901 - Software Developer(Oracle) - Senior Shweta (Winnipeg)

Rq11901 - Software Developer(Oracle) - Senior Shweta (Winnipeg)

17 Nov
|
A.T. Consulting & Recruiting
|
Winnipeg

17 Nov

A.T. Consulting & 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 modelingData Warehouse design and development, Database performance tuning, AutomationWorking with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needsStart Date
2026-12-14End Date
2028-03-07# Of Openings
2Organization
Business Days305.00Max Extension Term(s)
1 TimeStreet
5700 Yonge StreetTitle
IT26 32654FG Sr Software Dev (x2) Voluntary Mergers PHUsNOTE:
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 UploadConduct technical analysis, preparation of detailed programming specifications, program design, writing and/or generating code, and conduct unit testsTranslate technical specifications for sustainment and upgrade into working,



tested applicationsUndertake proof of technology with test data to simulate application load and performance tuning related applicationsProvide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gatewaysProvide 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 documentationWork with Quality Assurance (QA) to code, test, and debug extensions/tools integration servicesMaintain Development environments and continue continuous Integration (CI) practiceImprove the quality and accuracy of the data collected for the approximately 34 PHUs and 2282 PHU usersEnsure availability of the DHIR extensions/tools for use by all Ontarians.
Public Sector Experience
Experience working with federal/provincial/broader public-sector healthcare providersKnowledge of the provincial immunization system and OPS large complex IT Health related projects or equivalentExperience with integration of Clinical IT Systems such as Client and Provider RegistriesKnowledge of OPS Enterprise Architecture artifacts (or similar), processes and practices,



and ability to produce technical documentation that comply with industry standard practicesKnowledge 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 pointsTechnical 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 modelingData Warehouse design and development, Database performance tuning, AutomationInformatica for data extraction, transformation, and loading, initial setup and other data management purposesCognos 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 ObjectsKnowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web servicesKnowledge of the provincial immunization system.45 pointsCore 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 needsWorking with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applicationsAnalysis, design and development work on complex,

📌 Rq11901 - Software Developer(Oracle) - Senior Shweta (Winnipeg)
🏢 A.T. Consulting & 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: rq11901 - software developer(oracle) - senior shweta (winnipeg) / winnipeg

Subscribe to this job alert:

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