Requisition ID: 262244

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Information Technology (IT) department manages the technology and computer infrastructure that drives Tangerine’s business systems.

The IT department supports the organization in these critical areas: End-User Technical Support, Desktop Management, Network Management, Voice and Data Communications, Business and Web Applications and Strategic Technical Planning.

The Senior Database Administrator’s role is to design, install, monitor, maintain and performance-tune databases while ensuring high levels of data and system availability. This individual is also responsible for developing, implementing and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. The Senior Database Administrator will report directly to the Director of Infrastructure Project and Database Systems.

Is this role right for you? In this role, you will:

Assess and develop long-term strategic goals for databases in conjunction with data owners and department managers

Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures

Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets

Configure and design database architecture to scale and adapt to changing Operational and platform technologies (e.g. automation, diverse platform, cloud, etc.)

Ensure that existing and planned implementations are consistent and compliant with applicable security and regulatory policies and directives.

Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts

Create models for new database development and/or changes to existing ones

Respond to and resolve database access and performance issues

Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements

Monitor, optimize and allocate physical data storage for database systems

Plan and coordinate data migrations between systems

Establish appropriate end-user database access control levels

Implement corporate policy and audits; develop, publish, enforce and maintain standards and procedures

Manage development, test and production environments; perform administrative functions; maintain documentation

Design, create and maintain database structures; review application design and SQL code

Design, test and implement backup/recovery strategies and contingency plans

Monitor, analyze and report on availability, performance and resource consumption

Assess capacity and make recommendations on disk and server sizing based on projected growth





Plan, test and implement software upgrades; monitor alerts; administer licenses; interface with vendors

Remain current with industry and product direction; evaluate new technologies and product features; make recommendations as to how Tangerine can benefit

Troubleshoot problems; provide database problem resolution assistance to IT staff

Provide day-to-day consultancy and support to IT staff; act as backup for other Database Systems staff

Monitor daily operations; log issues and ensure resolution

Other duties as assigned

Skills

University or College Degree or equivalent experience

8+ years of experience as a DBA

5+ years experience administering Oracle databases

3+ years of SQL coding experience

Experience working in a team-oriented, collaborative environment

Experience on Redis Enterprise will be an added advantage

Experience on Qlik Replicate (Attunity) will be an added advantage

Exposure to GCP database services such as AlloyDB or Cloud SQL is an added advantage

Superior working knowledge of Oracle database products and the SQL language

Proven experience designing, deploying, and administering highly available and resilient database systems including hands-on experience with Dataguard and Disaster Recovery administration.

Experience on database duplication and standby database with RMAN

Experience on migrating to multi-tenant architecture (CDB/PDB)

Strong working knowledge of Oracle wallet, SSL and TLS connections

Working knowledge on data encryption (i.e. TDE)

Knowledge on NO-SQL database and in-memory data store

Knowledge on different Redis deployment methods

Strong understanding of Redis clusters, cluster setup and operations

Working experience on Redis upgrade and certificate operations

GCP, AlloyDB, Terraform Experience

Strong understanding of database structures, theories, principles and practices

Expert technical experience with designing, building, installing, configuring and supporting database servers

Familiarity with client/server, operating system, storage and networking fundamentals

Experience working in Unix or Linux Operating environments

Proven analytical and problem-solving abilities

Experience with requirements gathering and database design

Strong technical documentation skills

Demonstrated ability in performance tuning and capacity management

Proven experience working with vendors and third-party providers

Ability to conduct research into database issues, standards and products as required





Ability to present ideas in user-friendly language

Ability to effectively prioritize and execute tasks in a high-pressure setting

Works well independently and in a hybrid working environment

Availability to carry a 24x7 production support “pager” on a scheduled basis

Good oral and written communication skills

Good interpersonal skills

Highly self-motivated and directed

Keen attention to detail

What's in it for you?

Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.

Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.

Upskilling through online courses, cross-functional development opportunities, and tuition assistance.

Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.

Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.

#J-18808-Ljbffr

📌 Senior Oracle Database Administrator (Ontario)
🏢 Tangerine
📍 Ontario