About the role
Accelerate your career with the most awarded Air Cargo Airline in Canada!
Cargojet is Canada's leading provider of time-sensitive overnight air cargo services and carries over 1,300,000 pounds of cargo each business night. Cargojet operates its network across North America each business night, utilizing a fleet of all-cargo aircraft Cargojet has been awarded one of Canada’s 50 Best Managed Companies as well as being awarded the Shipper’s Choice Award for the best Air Cargo Carrier in Canada for the past number of years. Being part of Cargojet will allow you to become a part of a diverse and vibrant family at the leading edge of the air cargo industry both domestically and internationally. Cargojet team members are dedicated, hardworking, and have a strong sense of leadership and commitment.
Primary Objective of the Position:
Under the general direction of the VP, the Software Developer is responsible for creating and maintaining applications within Cargojet landscape. This involves in discussing the needs of the business, analyzing 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 safety-sensitive 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.
About Cargojet Airways Ltd.
Cargojet provides domestic and trans-border air cargo services in addition to aircraft handling and aircraft and airport equipment fueling services through its Fixed Base Operations business at the Hamilton Airport. It is Canada's leading provider of time sensitive overnight air cargo services.
About the role
Accelerate your career with the most awarded Air Cargo Airline in Canada!
Cargojet is Canada's leading provider of time-sensitive overnight air cargo services and carries over 1,300,000 pounds of cargo each business night. Cargojet operates its network across North America each business night, utilizing a fleet of all-cargo aircraft Cargojet has been awarded one of Canada’s 50 Best Managed Companies as well as being awarded the Shipper’s Choice Award for the best Air Cargo Carrier in Canada for the past number of years. Being part of Cargojet will allow you to become a part of a diverse and vibrant family at the leading edge of the air cargo industry both domestically and internationally. Cargojet team members are dedicated, hardworking, and have a strong sense of leadership and commitment.
Primary Objective of the Position:
Under the general direction of the VP, the Software Developer is responsible for creating and maintaining applications within Cargojet landscape. This involves in discussing the needs of the business, analyzing 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 safety-sensitive 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.
About Cargojet Airways Ltd.
Cargojet provides domestic and trans-border air cargo services in addition to aircraft handling and aircraft and airport equipment fueling services through its Fixed Base Operations business at the Hamilton Airport. It is Canada's leading provider of time sensitive overnight air cargo services.