Requisition id: 248717
join a purpose driven winning team, committed to results, in an inclusive and high‑performing culture.
purpose
contributes to the overall success of the department in globally ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives. Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures. Under the supervision of the manager database administration, manage and provide support for the banks oracle, mysql databases. As a member of the database administration group, the incumbent will assist in the team effort to maximize the availability, security, and performance of the databases. The incumbent is required to be on‑call on a rotational basis to support the banks databases. The incumbent must be prepared to do shift work as well as provide remote dial‑in support, or occasionally on‑site support in response to routine monitoring alerts, scheduled and unscheduled maintenance tasks occurring after hours and on weekends.
responsibilities
* champions a customer focused culture to deepen client relationships and leverage broader bank relationships, systems and knowledge.
* provide 24x7 production support (l1 & l2) – rotational shift. When on‑call you are required to be available afterhours, weekends, and holidays.
* implement new database/database components or enhancements.
* install, patch, upgrade oracle databases and components.
* remediate security vulnerabilities identified for oracle databases and components.
* perform database migrations.
* ensure adherence to bns database and security standards.
* provide root cause analysis for incidents.
* understand how the bank’s risk appetite and risk culture should be considered in day‑to‑day activities and decisions.
* actively pursues effective and efficient operations of his/her respective areas in accordance with scotiabank’s values, its code of conduct and the global sales principles, while ensuring the adequacy, adherence to and effectiveness of day‑to‑day business controls to meet obligations with respect to operational, compliance, aml/atf/sanctions and conduct risk.
* champions a high performance environment and contributes to an inclusive work environment.
education and experience
* minimum of 5 to 7 years of progressive technical working experience as a database administrator.
* experience with production database creation, upgrade and administration of oracle versions 11g, 12c, 19c.
* setup, configuration, and support of: oracle database on windows & linux; oracle rac+asm; oracle odbc, jdbc, heterogeneous connectivity.
* oracle data guard.
* performance tuning.
* oracle exadata.
* working knowledge of mysql.
* working knowledge of oracle enterprise manager (oem).
* strong problem solving, analytical, troubleshooting and automation skills.
* excellent negotiation, presentation, and time‑management skills.
* excellent oral and written communication skills.
* nice‑to‑have: database upgrade and migration experience, financial institution / banking industry experience, any experience with oracle olap, owb, oem, perl, shell scripting.
education and other requirements
* a degree in computer science, math, or related discipline.
* oracle dba ocp certification is desirable.
at scotiabank, we value the unique skills and experiences each person brings to the bank, and we are committed to creating and maintaining an inclusive and accessible environment for everyone. All employees must comply with the bank’s policies, standards, codes, and guidelines related to non‑discrimination and workplace accommodations.
if you require any accessibility accommodations during the process, please let our talent attraction team know.
under no circumstances should pregnancy or hiv tests be requested.
location(s): mexico : ciudad de méxico : miguel hidalgo
#j-18808-ljbffr