Canada DBA Job




Oracle Application Administrator - Stantec

Oracle Application Administrator

Job ID: 


# Positions: 




Experience (Years): 


Posted Date: 



IT Services

More information about this job:   Overview:
Stantec's Support Teams provide Finance, Information Technology, Human Resources, Marketing & Communications, Risk Management, and Shared Services administrative support services to over 9,500 employees operating out of more than 150 locations in North America. Through this support infrastructure, we are poised to help Stantec reach its vision of becoming and remaining a top 10 global design firm.

Reporting to the Team Lead, Application Operations, responsible for the application administration tasks for the Oracle e-Business Suite (Financials, Projects, & HRMS) production environment. This primary involves operating, monitoring and troubleshooting components of the core application technology underpinning the functional modules including application security/responsibilities, batch processing, workflow, etc.


  • Perform application security administration activities pertaining to aligning business roles to application access through roles, responsibilities, approvals, menus, functions, request groups, and profile options.
  • Perform batch process administration activities including defining, sequencing, scheduling and monitoring the execution of concurrent programs.  
  • Perform primary workflow administration activities including monitoring, diagnosing and either resolving or escalating incidents/problems to appropriate support analysts.
  • Diagnose incidents/problems involving core application technology and configurations.
  • Collaborate with functional and technical support analysts to address module-specific issues.
  • Define and document operating procedures for application administration activities that specify support requirements, service levels, known problems\workarounds, roles/responsibilities and incident\problem management procedures.
  • Develop operational solutions to prevent/detect application incidents/problems and respond to service requests to optimize application service levels.
  • Provide primary after-hours support on evenings and weekends to respond to application incidents/problems (i.e., batch processing failure) and either resolve or escalate incidents/problems as appropriate.
  • Adhere to policies and procedures to support IT access and change management controls in support of ITIL best practices and Sorbanes Oxley.


  • Good understanding of the application architecture underpinning Oracle e-Business Suite.
  • Strong attention to detail with a very methodical/procedural approach to work activities.
  • Good communication and documentation skills.
  • At least 3 years experience in an application support role involving a complex batch orientated ERP environment, preferably with Oracle e-Business Suite.
  • Experience with supporting and developing maintenance solutions for Oracle-based applications involving SQL, PLSQL, Oracle Forms, BI Publisher, Discoverer, etc.
  • Experience supporting or developing web applications, portals, Java, application servers, and XML would be an asset.
  • Knowledge of ITIL best practices.
  • Previous experience performing Oracle Database Administrator tasks would be an asset

Working Conditions

  • Ability to monitor batch processing and provide on-call response to application incidents during evenings and weekends.

Last updated on February 13, 2011