PostgreSQL DBA

Delpath; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

A Canadian tech firm is seeking an experienced Database Administrator for a 6-month contract. The role involves managing PostgreSQL and MongoDB installations, ensuring database security, and supporting database upgrades. The ideal candidate should have over 10 years of experience, including expertise in PostgreSQL and MongoDB, particularly in cloud environments like GCP. Hybrid work is expected, with an increase in office days in the future. Opportunities for extension and conversion to full-time are possible based on performance.

Qualifications

• 10+ years as a Database Administrator or relevant experience.
• 5+ years of experience with PostgreSQL from version 13 to current.
• 2+ years of experience with MongoDB Enterprise and Atlas.

Responsibilities

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

Skills

PostgreSQL

MongoDB

Database Administration

Linux

GCP

Education

Bachelor's degree or related work experience

Tools

GCP AlloyDB

MongoDB Atlas

Job description

Location 44 King Street W 10th Floor, Toronto, Ontario

Hybrid: 2 days in-office (will increase to 4 days in future)

Contract Duration: 6 Months

Possibility of extension: Yes, based on performance and business needs

Conversion to FTE: May be, based on performance and business needs

Number of Positions: 2

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

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

Interview Process:

• 2 Rounds of interviews
• 1st- Video Interview (1 hour) with HM and team lead: Technical based questions based on previous experience
• 2nd with director (1 hour): Behavioral and Tech interview to gauge the team fit.