Job Description
Location: 44 King Street W 10th Floor, Toronto, Ontario
Hybrid: 2 days in-office (will increase to 4 days in future)
Candidate Value Proposition
The successful candidate will gain experience with a top 5 Canadian bank on a dynamic and highly visible team.
Typical Day in Role:
• 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
• 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.
Candidate Requirements/Must Have Skills:
• 10+ Years as a Database Administrator or relevant experience.
• 5+ years of recent experience with Strong PostgreSQL skills from version 13 to current.
• 2+ years of Hands-on experience with MongoDB Enterprise and MongoDB Atlas.
• Previous experience with GCP AlloyDB is critical for this role
• 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
Nice-To-Have Skills:
• Prior Client experience
• Previous experience with Cassandra Database and Redis experience is nice to have
Soft Skills:
• Strong analytical and problem-solving skills.
• Ability to work independently with minimal supervision.
Best vs. Average Candidate:
The ideal candidate would have experience with PostgreSQL, GCP AlloyDB, and MongoDB. They should also be competent working with Linux and GCP or another Cloud Platform. Previous experience with top 5 Banks is very nice to have.
Degrees or certifications:
Bachelor's degree or related work experience
Certified with MongoDB or GCP is very nice to have