Database Administrator

LanceSoft, Inc.; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading technology staffing firm in Toronto seeks an experienced Database Administrator. The successful candidate will manage PostgreSQL and MongoDB databases, ensuring security and efficiency across environments. Key responsibilities include implementing database clusters, managing cloud configurations, and solving complex database problems. The ideal candidate has over 10 years of experience and strong skills in GCP AlloyDB and Linux. This hybrid role will require 2 days in-office work, increasing to 4 days in the future.

Qualifications

• 10+ years as a Database Administrator or relevant experience.
• Strong PostgreSQL skills from version 13 to current.
• Hands-on experience with MongoDB Enterprise and MongoDB Atlas.

Responsibilities

• Implementing PostgreSQL database clusters with replication.
• Managing database security and integrity.
• Independently managing MongoDB installations in Linux.

Skills

PostgreSQL skills (version 13 to current)

MongoDB Enterprise and MongoDB Atlas

Linux environment configuration

Analytical and problem-solving skills

Experience with GCP AlloyDB

Education

Bachelor's degree or related work experience

Tools

PostgreSQL

MongoDB

GCP (Google Cloud Platform)

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

• 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