Database Administrator

Requisition ID: 267734 

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!