Grow with the best. Join a smart, creative, and inspired team that accomplishes operational excellence. Bringing together individuals with diverse backgrounds, talents, and expertise, our 22,000 team members in over 350 locations worldwide are vital to making our Company stronger.
We have an immediate need for a senior level Database Administrator on our Advanced Technology team within Stantec. This position will have some management functions but will primarily be a technical position. This person will be expected to plan and execute complex technical tasks and will provide technical leadership and guidance to team members.
Your Key Responsibilities
Providing support and implementation of Oracle Applications upgrades.
Work independently to problem solve [i.e., problem identification, management and resolution]
Conduct patch analysis and patch application
Performance monitoring and tuning of Databases, Oracle Application Servers and E-Business Software.
Database backup, recovery and security.
Planning, testing and performing software upgrades.
Assisting with database loads and data conversion activities.
Database application cloning and supporting different application environments.
Resolving and responding to service requests.
Supporting and enhancing Stantec's High Availability Architecture and disaster recovery operations using Dataguard technology.
Provide mentoring and guidance to other team members.
Your Capabilities and Credentials
Strong database fundamentals with Database Backup and Recovery, partitioning and security.
Extensive Oracle database (11g, 12c) and Oracle E-Business Suite application patch analysis and application experience.
Ability to use Oracle E-Business suite versions 12.1 with OID SSO, Oracle 19c
Experience with RHEL Linux, experience working with other Operating systems such as Itanium, AIX or Solaris would be an asset.
Experience in using Oracle Enterprise Manager 12c/13c for managing environments will be considered an asset.
Excellent verbal and written communication skills; this position requires a high degree of involvement leading meetings and regularly communicating to various stakeholders.
Experience in shell scripting, PL/SQL. Perl or Python programming will be considered an asset.
Please note that this position may require after-hours and on-call work.
Education and Experience
Minimum of 8 years’ experience providing Oracle Database Administrator support in a UNIX environment
Minimum of 4 years providing Oracle E-Business Suite support in a UNIX environment
Post-secondary degree in Information Technology or related field. Equivalent education and experience will be considered.
Oracle Certification would be an asset.
This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.
Stantec is a place where the best and brightest come to build on each other’s talents, do exciting work, and make an impact on the world around us. Join us and redefine your personal best.
Job: Database Administration
Primary Location: Canada-Alberta-Edmonton
Employee Status: Regular
Job Level: Individual Contributor
Req ID: 2000010K