Senior Database Administrator

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

Benefits offered by this job

Diversity & inclusion

Accessible workplace

Tuition assistance

Performance bonus

Community events

Job summary

Scotiabank is seeking a seasoned Database Administrator to oversee PostgreSQL and MongoDB environments across on-premises Linux and Google Cloud Platform. The role emphasizes replication, security, backup, and upgrades along with performance tuning for CloudSQL PostgreSQL and Atlas clusters.

The ideal candidate will have 5+ years in DBA roles, strong PostgreSQL expertise (v14+), and hands-on CloudSQL/MongoDB experience in a cloud setting. Bachelor's degree or equivalent work history preferred.

Qualifications

• 5+ years of experience as a Database Administrator.
• Strong PostgreSQL skills from version 14 to current.
• Hands-on experience with GCP CloudSQL for PostgreSQL incl. HA, backups, IAM access, monitoring, patching & performance.
• Experience with GCP networking concepts incl. private IP connectivity & secure application connectivity patterns.
• Hands-on experience with MongoDB Enterprise and MongoDB Atlas.
• Proficient in configuring MongoDB in a Linux environment and cloud.
• Experience implementing multi-data center replica sets and sharded clusters.
• Knowledge of audit processes, security measures, encryption at rest, and upgrades.
• Prior Scotia experience.
• Bachelor's degree or related work experience.

Responsibilities

• Implement PostgreSQL database clusters with replication.
• Manage database security, integrity, and backup procedures.
• Upgrade database instances to current versions.
• Assist with database design, development, and query tuning.
• Administer and support GCP CloudSQL for PostgreSQL environments, incl. configuration, maintenance, monitoring, backups, and performance tuning.
• Support CloudSQL PostgreSQL connectivity, IAM/database access, private networking, and operational readiness for application teams in GCP.
• 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 audit, security, backup/recovery and encryption at rest.
• Tackle complex problems through conceptualization and reasoning.

Skills

PostgreSQL

MongoDB

CloudSQL

Linux

Replication

Networking

Education

Bachelor's degree

Tools

MongoDB Atlas

GCP

Linux

Job description

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

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

• Implementing 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 and development and tuning queries
• Administer and support GCP CloudSQL for PostgreSQL environments, including instance configuration, maintenance, monitoring, backup/recovery, and performance tuning.
• Support CloudSQL PostgreSQL connectivity, IAM/database user access, private networking, and operational readiness for application teams in GCP.
• 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.

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

• 5+ Years as a Database Administrator
• Strong PostgreSQL skills from version 14 to current.
• Hands-on experience supporting GCP CloudSQL for PostgreSQL, including high availability, backups, IAM/database access, monitoring, patching, and performance troubleshooting.
• Experience with GCP networking concepts relevant to CloudSQL PostgreSQL, including private IP connectivity and secure application connectivity patterns.
• 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, MongoDB version upgrades
• Prior Scotia experience
• Google Cloud Platform certification or hands-on experience with CloudSQL PostgreSQL operations in an enterprise environment.
• Strong analytical and problem-solving skills.
• Ability to work independently with minimal supervision.
• The ideal candidate would have experience with PostgreSQL, GCP CloudSQL PostgreSQL, and MongoDB. They should also be competent working with Linux and GCP or another
• 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 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.