Primary Objective of the Position:
Under the general direction of the VP this position is responsible for creating and maintaining applications within Cargojet landscape. This involves in discussing the needs of the business analysing and developing solutions / applications.
Principal Duties and Responsibilities:
- Design develop and maintain Oracle APEX applications to meet business requirements.
- Write and optimize SQL and PL/SQL code to support application functionality.
- Design and maintain database objects such as tables views triggers packages and procedures.
- Create APEX pages including Master Detail Forms Tabular forms Apex Collections Interactive reports and Charts.
- Develop RESTful APIs for interfaces.
- Develop processes and scripts to load flat file data into Oracle databases.
- Design and develop reports using Jasper Reports Crystal Reports and Power BI.
- Provide ongoing maintenance and support for existing APEX applications.
- Improve performance and response times of APEX pages and reports.
- Perform SQL and PL/SQL performance tuning.
- Utilize HTML/CSS/JavaScript/JQuery for web/UI design.
- Follow best practices to document and track changes and synchronize development/production environments.
- Troubleshoot reporting issues trace data/logic and report back on root causes.
- Perform other duties as assigned.
Minimum Qualifications:
- Expertise in Oracle APEX (version 4.2 /19.2 or higher).
- Expertise with Oracle Database 11g/12c/18c/19c or higher).
- Experience in AWS environments
- Proficiency in Oracle 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.
- Web/UI design experience involving HTML JavaScript JQuery CSS and AJAX.
- Experience with Business Requirements capture Analysis and Documentation.
- Experience with reporting tools such as Jasper Reports Crystal Reports and Power BI.
Important to Know:
- Cargojet is an equal opportunity employer. We thank you for your interest. Only those candidates selected for an interview will be contacted.
- We are committed to providing accommodations for persons with disabilities. If you require accommodation we will work with you to meet your needs.
- At Cargojet we make safety the highest priority. Because of this priority and as we operate in a safetysensitive environment we require all employees to abstain from consuming Cannabis in and outside of the workplace. This is a critical element of our drug and alcohol policy that all employees must comply with at all times.
Required Experience:
Senior IC