Job Description :
RQ00785 - Specialized IT Consultant Senior Toronto, ON Start Date 2021-04-26 End Date 2022-01-31 Rate: CAD $ 525/Day Assignment Type: Hybrid Security Level: No Clearance Required # Business Days: 180.00 Description Shortlisting Date: Friday, April 9th at 2:00 pm EST Maximum number of Candidate Submissions: 1 (One) Must Haves: Demonstrated experience installing, configuring and developing applications using Oracle Application Express (APEX) with a minimum of 7 years of solid experience This should not be confused with other applications called "APEX" Demonstrated advanced level of knowledge of creating PL/SQL procedures, functions and package with at least 10 years' experience Nice to Have: Experience within healthcare industry would be an asset Public Sector Experience RESPONSIBILITIES This RFS is for a a specialized IT consultant with a specific mix of required development and technical skills with a particular emphasis upon APEX and PL/SQL Experience as an Oracle DBA is desirable along with a knowledge of ODI, BI Publisher some experience working with Essbase/Hyperion Planning. This resource will be required to provide daily support for these business critical systems, to make any necessary enhancements that are improvement by the business and provide leadership in carrying out any medium to large projects that may be approved during the dates defined by this RFS. Specific responsibilities include: Complete the second phase of a major enhancement project involving the redesign of a core data extraction and data sharing module. Support and enhance a number custom-built APEX applications that manage and execute billions of dollars of payments annually and that manage the Essbase/Planning metadata which includes a batch ODI component. Ensure the integration of APEX components with Oracle Access Manager as implemented within the Government of Ontario including integration with PKI. Develop and maintain any required custom extensions to APEX such as JavaScript or Java routine Assist and support the upgrade and migration of all of the in-scope application components to a new version of EPM on a new Operating System (Solaris to Linux Provide any necessary data base administrator support required by these applications including making changes to existing ETL routines written in ODI/PL-SQL. Work with business analyst and business partners to provide estimates and design options for any changes. Provide tier 2 and tier 3 support for all applications noted above (for the APEX and ODI modules Conduct unit testing and support system integration testing for any changes that are made. Provide guidance and expertise for ensuring that all applications components within the scope of this RFS are written to comply with the WCAG 2.0 standards as defined in AODA legislation. Skills Experience and Skill Set Requirements Price will be 30& of the evaluation. The remaining 70% will be apportioned as follows: Core Technical Skills: 35% Demonstrated experience installing, configuring and developing applications using Oracle Application Express (APEX) with a minimum of 7 years of solid experience. Demonstrated experience developing APEX applications using Java/JavaScript and similar development tools to extend basic functionality. Demonstrated experience (at least one upgrade) upgrading Oracle APEX including involvement in migrating APEX applications across operating systems. Demonstrated experience performing the basic functions of a database administrator. Demonstrated advanced level of knowledge of creating PL/SQL procedures, functions and package with at least 10 years experience. Demonstrated knowledge of techniques for optimizing the performance of SQL queries DML and APEX applications. Experience with at least one APEX application that is integrated with OAM (Oracle Single Sign-On Application-Specific Skills: 35% Demonstrated experience working with applications that perform transfer payments or similar financial transaction management functionality. Demonstrated experience working with applications that allocate funding. Some experience working with APEX in a Hyperion Planning or Essbase environment. Demonstrated experience providing and delivering Oracle-based solutions that are GO-ITS compliance and familiarity with GO-ITS standards and processes would be an asset Demonstrated experience with public sector financial applications, ideally in a Hyperion Planning context and ideally related to the education or post-secondary education sectors would be an asset
             

Similar Jobs you may be interested in ..