Database Administrator, Oracle E-Business Suite
About the role
Your Opportunity
Stantec is currently seeking an Oracle E-Business Database Administrator to join our Global Database Services Team reporting to our Manager, Advanced Technology. Occasional on-call shifts will be required on a rotational basis. This position affords opportunity for working from home but will be based within commutable distance to one of our major Canadian office locations.
Your Key Responsibilities
- Providing support for Oracle Applications upgrades.
- Problem management [i.e., problem identification, management and resolution]
- Patch analysis and patch application
- Performance monitoring and tuning of Databases, Oracle Application Servers and E-business Software.
- Database Backup and Recovery.
- Planning, Testing and Performing software upgrades.
- Assisting with database loads and data conversion activities.
- Cloning and supporting environments.
- Service request resolution.
- Supporting and enhancing Stantec's High Availability Architecture and disaster recovery operations
Your Capabilities and Credentials
- Extensive Oracle and Oracle E-Business Suite application experience.
- Minimum of 8-10 years' experience providing Oracle DBA support in a LINUX/UNIX environment, of which 2 years must have been working with Oracle 19C.
- Minimum of 3 years providing Oracle E-Business Suite support in a UNIX environment of which 2 years must have been working with Oracle E-Business suite versions 12.2, OIDM12c, OEM 13C.
- Sound understanding of database fundamentals with Database Backup and Recovery, partitioning and security
- Experience with RHEL Linux is mandatory, experience working with other Operating systems such as Itanium, AIX or Solaris would be an asset
- Experience in shell scripting in a UNIX or Linux environment.
- Experience in Perl or Python programming will be considered an asset.
- Experience in using Oracle Enterprise Manager 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.
- Please note that this position will require after-hours.
- We are looking for team players that can work in a very dynamic and challenging environment.
- Experience with Azure will be an asset.
- SQL*Server experience will be an asset.
- Oracle Certified Professional certification will be an asset.
Education and Experience
- Minimum 8 years relevant experience.
- Related degree or diploma, or equivalent combination of
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.
About Stantec
Stantec empowers clients, people, and communities to rise to the world’s greatest challenges at a time when the world faces more unprecedented concerns than ever before.
We are a global leader in sustainable engineering, architecture, and environmental consulting. Our professionals deliver the expertise, technology, and innovation communities need to manage aging infrastructure, demographic and population changes, the energy transition, and more.
Today’s communities transcend geographic borders. At Stantec, community means everyone with an interest in the work that we do—from our project teams and industry colleagues to our clients and the people our work impacts. The diverse perspectives of our partners and interested parties drive us to think beyond what’s previously been done on critical issues like climate change, digital transformation, and future-proofing our cities and infrastructure.
We are designers, engineers, scientists, project managers, and strategic advisors. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible.
Stantec trades on the TSX and the NYSE under the symbol STN.
Database Administrator, Oracle E-Business Suite
About the role
Your Opportunity
Stantec is currently seeking an Oracle E-Business Database Administrator to join our Global Database Services Team reporting to our Manager, Advanced Technology. Occasional on-call shifts will be required on a rotational basis. This position affords opportunity for working from home but will be based within commutable distance to one of our major Canadian office locations.
Your Key Responsibilities
- Providing support for Oracle Applications upgrades.
- Problem management [i.e., problem identification, management and resolution]
- Patch analysis and patch application
- Performance monitoring and tuning of Databases, Oracle Application Servers and E-business Software.
- Database Backup and Recovery.
- Planning, Testing and Performing software upgrades.
- Assisting with database loads and data conversion activities.
- Cloning and supporting environments.
- Service request resolution.
- Supporting and enhancing Stantec's High Availability Architecture and disaster recovery operations
Your Capabilities and Credentials
- Extensive Oracle and Oracle E-Business Suite application experience.
- Minimum of 8-10 years' experience providing Oracle DBA support in a LINUX/UNIX environment, of which 2 years must have been working with Oracle 19C.
- Minimum of 3 years providing Oracle E-Business Suite support in a UNIX environment of which 2 years must have been working with Oracle E-Business suite versions 12.2, OIDM12c, OEM 13C.
- Sound understanding of database fundamentals with Database Backup and Recovery, partitioning and security
- Experience with RHEL Linux is mandatory, experience working with other Operating systems such as Itanium, AIX or Solaris would be an asset
- Experience in shell scripting in a UNIX or Linux environment.
- Experience in Perl or Python programming will be considered an asset.
- Experience in using Oracle Enterprise Manager 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.
- Please note that this position will require after-hours.
- We are looking for team players that can work in a very dynamic and challenging environment.
- Experience with Azure will be an asset.
- SQL*Server experience will be an asset.
- Oracle Certified Professional certification will be an asset.
Education and Experience
- Minimum 8 years relevant experience.
- Related degree or diploma, or equivalent combination of
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.
About Stantec
Stantec empowers clients, people, and communities to rise to the world’s greatest challenges at a time when the world faces more unprecedented concerns than ever before.
We are a global leader in sustainable engineering, architecture, and environmental consulting. Our professionals deliver the expertise, technology, and innovation communities need to manage aging infrastructure, demographic and population changes, the energy transition, and more.
Today’s communities transcend geographic borders. At Stantec, community means everyone with an interest in the work that we do—from our project teams and industry colleagues to our clients and the people our work impacts. The diverse perspectives of our partners and interested parties drive us to think beyond what’s previously been done on critical issues like climate change, digital transformation, and future-proofing our cities and infrastructure.
We are designers, engineers, scientists, project managers, and strategic advisors. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible.
Stantec trades on the TSX and the NYSE under the symbol STN.