Senior Database Administrator

Scotiabank; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading financial institution in Toronto is seeking a seasoned Database Administrator with over 10 years of experience. The ideal candidate will excel in managing PostgreSQL and MongoDB databases, ensuring their security and integrity while working in a collaborative environment. This position offers a competitive rewards program and emphasizes diversity and inclusion.

Benefits

Diversity, Equity, Inclusion & Allyship

Tuition assistance

Flexible vacation

Community engagement opportunities

Qualifications

• 10+ years as a Database Administrator.
• Strong PostgreSQL skills from version 13 to current.
• Hands-on experience with MongoDB Enterprise and MongoDB Atlas.
• Experience with implementing multi-data center replica sets and sharded clusters.
• Knowledge of audit processes and security measures.

Responsibilities

• Implement PostgreSQL database clusters with replication.
• Manage database security, integrity, and backup procedures.
• Upgrade database instances from lower versions to current versions.
• Assist with database design, development, and query tuning.
• Independently manage MongoDB installations and configurations.

Skills

PostgreSQL

MongoDB

Linux

Analytical skills

Problem-solving

Education

Bachelor’s degree or related work experience

Tools

MongoDB Atlas

GCP

Job description

Overview

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. Location: Toronto, Ontario, Canada. Scotiabank is a leading bank in the Americas and values an inclusive environment across all roles.

Responsibilities

• Implement PostgreSQL database clusters with replication
• Manage database security, integrity, and backup procedures
• Upgrade database instances from lower versions to current versions
• Assist with database design, development, and query tuning
• Independently manage MongoDB installations and configurations in Linux environments and cloud (GCP)
• Implement multi-data center replica sets and sharded clusters across Linux platforms and MongoDB Atlas on GCP
• Ensure database security with knowledge of audit, security, backup/recovery, and encryption at rest
• Tackle complex problems through conceptualization and reasoning

Qualifications

• 10+ years as a Database Administrator
• Strong PostgreSQL skills from version 13 to current
• Hands-on experience with MongoDB Enterprise and MongoDB Atlas
• Proficient in configuring MongoDB in a Linux environment and cloud
• Experience with implementing multi-data center replica sets and sharded clusters
• Knowledge of audit processes, security measures, encryption at rest, and MongoDB version upgrades
• Prior Scotia experience
• Strong analytical and problem-solving skills
• Ability to work independently with minimal supervision
• The ideal candidate would have experience with PostgreSQL and MongoDB and be competent working with Linux and GCP or another Cloud Platform
• Bachelor’s degree or related work experience

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 employees to learn, grow & participate through our various Employee Resource Groups (ERGs).
• Accessibility and Workplace Accommodations – We value the unique skills and experiences each individual brings and are committed to an accessible environment.
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance
• Competitive rewards program including bonus, flexible vacation, personal, sick days and benefits from day one
• Community engagement opportunities across programs such as hackathons, contests, and more

Location

Canada: Ontario: Toronto