Cargojet is Canada's leading provider of time sensitive overnight air cargo services. Cargojet services 14 major city centers coast to coast each business night. Cargojet operates its network across North America carrying approximately 750,000 pounds of cargo each business night. Cargojet has a fleet of 22 aircraft consisting of B767-300ER, B767-200ER, B757-200ER and B727-200AF long range freighter aircraft.
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.
350 Britannia Road East, Units 5 & 6
Mississauga, ON L4Z 1X9
Terms of Employment: Permanent, Full-Time
-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.
Salary Range: $70,000 - $80,000 (depending on experience)
What Cargojet Offers:
-A great working environment.
-A comprehensive benefits package including disability benefits, dental/vision care benefits, life insurance and other medical benefits.
-Company RRSP program (with employer matching).
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.