Based out of our Mississauga head office, the Oracle Apex Developer will develop, support and optimize Airline Applications using an Oracle database back-end and an Apex front-end. The successful candidate will generate online reports and PDF files using Apex and SAP Crystal Reports, and create and support PL/SQL packages to implement complex business scenarios. This is a great opportunity in this growing organization to develop new systems and learn new technologies.
Reporting to and working closely with the Chief Information Officer, the successful candidate will:
-Write SQL queries and create PL/SQL functions/procedures/packages that are optimized for Apex;
-Create Apex pages, Master Detail Forms, Tabular Forms, Apex Collections, Interactive Reports, Charts, etc.;
-Create processes and scripts to load flat file data into the Oracle database;
-Revise PDF templates and source queries;
-Synchronize online reports and PDF reports;
-Provide production support for Apex applications;
-Improve performance and response times of Apex pages and reports;
-Execute SQL and PL/SQL performance tuning;
-Follow best practices to document and track changes;
-Synchronize development/production environments;
-Troubleshoot reporting issues; and
-Trace data/logic and report back on the root cause.
Desired Skills & Experience:
-3-5 years of experience as an Apex Developer;
-A Bachelor’s Degree in Computer Science or Computer Engineering;
-Development experience with Oracle 10g/11g and Apex 4.2;
-Experience in Oracle with SQL, PL/SQL, Performance Views, Data Dictionary, External Tables, Indexing, Cursors, Constraints, Job Scheduling and Materialized Views;
-Experience with Apex themes, templates, data upload tools, page/application items and processes, forms and reports;
-Experience with Glassfish Application Server and APEX Listener;
-Experience with Business Requirements Capture, Analysis and Documentation; and
-Experience with Crystal Reports.
We offer a competitive salary and a comprehensive benefits package. If you are ready to apply your skills and knowledge in this successful and growing organization, please forward your résumé along with a cover letter specifying your salary expectations.