Senior Oracle PL/SQL Developer (Toronto)

Senior Oracle PL/SQL Developer (Toronto)

19 Nov
|
Russell Tobin
|
Toronto

19 Nov

Russell Tobin

Toronto

Russell Tobin & Associates is hiring on behalf of one of its esteemed clients.

Job Title: Senior Oracle PL/SQL Developer

Duration: 305 Business days with possible extension

Client: Public Sector

Pay Rate: $80 - $85/hour [CAD]

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

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.

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

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
- 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 D

📌 Senior Oracle PL/SQL Developer (Toronto)
🏢 Russell Tobin
📍 Toronto

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: senior oracle pl/sql developer (toronto) / toronto