Database Administrator, PostgreSQL

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.