Database Administrator – SQL

Database Administrator – SQL

ProViso Consulting

Story Behind the Need

• Business group: GTS – Technology Operations & Engineering oversees security compliance within client’s internal Data Bases.
• Project: The team is currently working on a large data base upgrade and require additional assistance. The candidate will be working the full end to end cycle of the upgrade from Installation, back up and configuration.

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 Administer
• Strong PostgreSQL skills from version 12 to current.
• Hands-on experience with MongoDB Enterprise and MongoDB Atlas.
• 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 client experience

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 and MongoDB. They should also be competent working with Linux and GCP or another Cloud Platform

Degrees or certifications:

• Bachelor’s degree or related work experience

Candidate Review & Selection

• 2 Rounds of interviews:
o 1st- Video Interview (1 hour) with HM and team lead
o 2nd with director (1 hour)

Job Details



6 Months



Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

× Chat

Send this to a friend