Senior oracle developer - (RV-939)

Senior oracle developer - (RV-939)

25 Aug
|
2iSolutions Inc.
|
Toronto

25 Aug

2iSolutions Inc.

Toronto

This role is for a senior oracle developer with experience developing in APEX



oThis is a developer role, will not be accepting DBAs or infrastructure candidates.



Must haves:



In depth complex Oracle application development, must have experience in Oracle APEX (Application Express).



oThe main review will be for in depth development abilities in APEX, they must have developed applications, not simply used this tool for upgrades/enhancements. Current program is using version 18.2



Must have excellent SQL PL/SQL development skills, must have demonstrated experience developing customized Oracle modules in SQL and PL/SQL



Javascript API experience required





Must have experience developing on a migration/upgrade project and be able to complete full stack development



Experience with Data Manipulation Language in the APEX platform (update, insert, delete etc.)



Assets:



Experience developing with financial applications (transfer payments, invoices etc)



Experience in a Hyperion Planning Environment



Responsibilities:



Support and enhance a custom-built APEX applications that manages and executes billions of dollars of payments annually and that provide electronic notices of payment via email.



Ensure the smooth migration of APEX application from FMA to CFIS server.



Run AODA compliance software against any altered code and make any required changes to ensure full compliance of the upgraded software.



Upgrade APEX to most current version and perform whatever changes are required to applications to adapt to new version and test functionality.



Support the migration of ODI scripts from FMA server to CFIS server.



Make changes/fixes/enhancements to ODI scripts as required.



Enhance, modify and debug PL/SQL scripts and procedures.



Support and enhance a customized metadata and ETL management solution built using Oracle Application Express .



Install, configure and upgrade APEX configurations on the FMA and CFIS applications. This may also include support of EFIS TP application.



Plan, manage and support the migration of application applications and any necessary upgrades to the software including assisting with DB upgrade or migration from Solaris to Linux.



Make any changes required to the APEX applications as required either by user needs or as required or suggested by the upgrade to the development tool



Technical Experience - 35%



Demonstrated experience installing, configuring and developing applications using Oracle Application Express (APEX).



Demonstrated experience (at least one upgrade) upgrading Oracle APEX



Demonstrated advanced level of knowledge of creating PL/SQL procedures, functions and packages.



Demonstrated advanced level of knowledge of Oracle SQL.



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 Experience - 30%



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



Sector Knowledge - 5%



Demonstrated experience providing and delivering Oracle-based infrastructure 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

The original job offer can be found in Kit Job:
https://www.kitjob.ca/job/15479434/senior-oracle-developer-rv-939-toronto/?utm_source=html

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:
Enter Your E-mail address to receive the latest job offers for: senior oracle developer - (rv-939)
Publish a new Free Offer
Need to publish an offer? With more than 1 million unique users per month, you will find the ideal candidate for your company instantly, what are you waiting for!
Publish Now

Subscribe to this job alert