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