Senior Oracle DBA - 12c/19c (Hybrid)

Is this role right for you?

• You are eager to plan, design, build, test, & support database systems.
• You thrive on providing technical analysis and recommendations.
• You want to be challenged with complex problem solving in time sensitive situations to reduce system downtime and customer impact.
• You are a wizard in writing scripts to enhance performance & tuning.
• You are interested in being the beacon of Oracle technical knowledge & sharing it.

Do you have the skills that will enable you to succeed in this role?

• You can demonstrate very good communication (verbal / written) skills.
• You have at least 5+ years of hands-on technical working experience as an Oracle DBA in a medium to large production environment.
• You can demonstrate hands-on technical working experience with the creation, installation, configuration, back-up & recovery, upgrades AND the migration from Oracle 12c TO Oracle 19c .
• You have at least 5+ years of hands-on technical working experience in the set-up, configuration & support of Oracle Real Application Cluster (RAC) for clustering & high availability (HA).
• You have at least 5+ years of hands-on technical working experience in the set-up, configuration & support of Oracle Automatic Storage Management (ASM) for storage management.
• You have at least 5+ years of hands-on technical working experience in the set-up, configuration & support of Oracle Data Guard (single instance) to ensure HA, data protection & disaster recovery for enterprise data.
• You have at least 2+ years of hands-on technical working experience with Oracle Enterprise Manager (OEM 12 & 13).
• You have at least 5+ years of hands-on technical working experience in applying SQL for database performance & tuning.
• You have at least 3+ years of hands-on technical working experience in the use of Red Hat® Ansible® Automation.
• You have strong awareness & knowledge around database security & auditing practices.
• An asset to have hands-on technical working experience with Oracle Golden Gate; setting up databases in a Cloud environment + familiarity with Oracle Exadata.
• You have hands-on technical working experience in responding to production incidents that cross application and technology boundaries.
• You can demonstrate the ability to conduct root cause analysis of application incident and implement recommendations to improve the situation, while focusing on permanent solutions.
• You have completed a post-secondary education in Computer Science, Engineering or in a related field.

What's in it for you?

• You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world.
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success! We also foster an environment of innovation and continuous learning.
• We care about our people, allowing them to design how they work to deliver amazing results.
• We offer a competitive total rewards package, including a performance bonus, company matching programs (pension & Employee Share Ownership), generous vacation;

health / medical / wellness benefits; employee banking privileges.

• As a part of the hybrid work model, when required to be onsite, the downtown Toronto worksite is :
• Renovated with a design focus on enabling collaboration through both environment and technology.
• Located near the TTC’s Line 1 King subway station & is located minutes from GO Transit / VIA Rail hub at Union Station;

as well as the TTC’s King 504 streetcar line.

• Just minutes from the Gardiner Expressway & the DVP.
• Home to The Commons, a dining space at Scotia Plaza for employees where breakfast & lunch are served. Also, The Bean serves hot / cold beverages & snacks.
• Directly accessible to The PATH & its many food courts, restaurants, grocery stores, LCBO, hairdressers, pharmacies, gyms, clothing stores & services.

scotiatechnology

LI-Hybrid