Oracle Database Developer

One Year Term

Reporting to the Business Performance Improvement Manager, the Oracle Database Developer will collaborate with colleagues to improve business performance. Typical assignments will enable specific outcomes by developing, supporting, and enhancing our business applications and systems, especially with respect to our Oracle ERP and related in-house systems.  This is a one-year term with potential for extension.

The successful candidate will:

  • contribute to a team working on development and enhancement requests related to our Oracle E-Business Suite (EBS R12) applications
  • develop functionality using Oracle databases to support business process automation and reporting
  • write and optimize Oracle SQL queries
  • develop, modify and maintain PL/SQL functions, procedures, and packages
  • develop solutions using various EBS Projects and Core Financial APIs, workflows, and forms
  • troubleshoot technical issues to identify root causes and perform appropriate remediation involving various Oracle database functions
  • develop solutions using related non-Oracle technologies such as Microsoft SQL Server
  • and, coordinate with the business and testing teams to ensure timely resolution for all minor enhancements, tickets, and defects

The following abilities are considered assets:

  • knowledge of Oracle E-Business Suite (12.1) application modules with respect to the nature of the underlying database objects, and how they function (specifically the Projects and Core Financial modules)
  • hands-on experience with the APIs associated with the Oracle Time & Labour, Projects and Core Financial modules
  • develop reports using SQL Server Reporting Services (SSRS) and similar tools and platforms
  • ability to write and optimize Microsoft SQL Server queries as well as develop, modify and maintain functions, procedures, packages, and related items
  • ability to develop Oracle Application Express (APEX) applications
  • create and deploy small scale applications based on Microsoft Office products and VBA such as forms, reports and data integration applications
  • develop Microsoft SharePoint sites including workflow and integration with external data sources

Knowledge and Skill Requirements:

  • relevant experience, education, and training, and relevant certification or progress towards certification
  • excellent analytical, problem-solving and decision-making skills
  • the ability to communicate and collaborate across all levels of the organization

Apply now at Itl%60oSdrntsbdrA@tunqsn/b%60

  • Calgary, AB