Senior IT Consultant- Oracle APEX

Role: Specialized IT Consultant- Senior
Location: Toronto, ON
Hybrid: 3 days on site and 2 days remote
Must Have

• Oracle developer with focus and deep experience with APEX (Oracle Application Express) min of 7 years of solid hands-on experience
• Demonstrated advanced level of knowledge of creating PL/SQL procedures, functions and package with at least 10 years' experience.

Technical Skills

• Demonstrated experience installing, configuring and developing applications using Oracle Application Express (APEX) with a minimum of 7 years of solid hands-on 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.
• Demonstrated experience integrating APEX with ODI.
• Demonstrated experience using BI Publisher reports in conjunction with APEX.
• Experience with at least one APEX application that is integrated with OAM (Oracle Single Sign-On).

General Skills:

• Acts as the technical advisor/expert on all aspects of a specific deliverable
• Provide the quality assurance/quality control of specific deliverables
• Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations
• Develops processes and procedures for implementing deliverables
• Prepares reports and presentations including options, recommendations, implementation plans, etc.
• Works with clients to define the scope of a project and to determine requirements
• Defines software, hardware and network requirements
• Analyzes I&IT requirements giving independent and objective advice on the use of I&IT
• Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems
• Familiar with change-management principles and methodology
• Knowledge and understanding of Information Management principles, concepts, policies and practices