Database Administrator, PostgreSQL - Greater Toronto Area

Database Administrator, PostgreSQL (V13 to Current): · On behalf of our financial industry client, Procom is searching for a Database Administrator, PostgreSQL (V13 to Current) for a 6-month role. This position is a hybrid position with 4 days onsite at our client's Toronto offic ...

Job description

Database Administrator, PostgreSQL (V13 to Current):

On behalf of our financial industry client, Procom is searching for a Database Administrator, PostgreSQL (V13 to Current) for a 6-month role. This position is a hybrid position with 4 days onsite at our client's Toronto office.

Database Administrator, PostgreSQL (V13 to Current) - Job Description:

The project involves onboarding several large-scale new projects requiring additional support for a large database migration and upgrade. The candidate will work on the full end-to-end cycle of the upgrade, including installation, backup, and configuration.

Database Administrator, PostgreSQL (V13 to Current) - Responsibilities:

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

Database Administrator, PostgreSQL (V13 to Current) - Mandatory 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

• 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

Database Administrator, PostgreSQL (V13 to Current) – Nice-to-Have Skills:

• Prior Scotia experience

• Previous experience with Cassandra Database

• Redis experience

• Certified with MongoDB or GCP

Database Administrator, PostgreSQL (V13 to Current) – Assignment Length:

This is a 6-month contract position with the possibility of extension based on performance and business needs.

Database Administrator, PostgreSQL (V13 to Current) - Start Date:

ASAP

Database Administrator, PostgreSQL (V13 to Current) - Assignment Location:

Toronto, Ontario, Canada. This is a hybrid role requiring 4 days in the office.