DBA x2

Nexus Systems Group Inc.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A technology solutions provider is seeking an experienced Database Administrator in Toronto, Ontario. The role involves managing PostgreSQL and MongoDB databases, ensuring security, and upgrading database instances. Candidates must have over 10 years of experience, including strong PostgreSQL and MongoDB skills, especially in cloud environments. This position supports independent work and requires analytical problem-solving skills.

Qualifications

• 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.

Responsibilities

• Implement PostgreSQL database clusters with replication.
• Manage database security/integrity and backup procedures.
• Upgrade Database instances from lower versions to current versions.

Skills

PostgreSQL

MongoDB

Database security

Analytical skills

Job description

Overview

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 Scotia 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.