The Candidate will Be Working with: Solution Design, DB Engineering, Information Security teams and external vendors.
Daily Job Duties/Activities
Taking ownership of and leading technical resolutions for production incidents
Communicating clearly complex technical issues to stakeholders and Lines of Business partners
Complying with CIBC standards for change control and overall database security policies
Analysing recurring incidents and identifying service improvements where possible
Providing on-call rotational/pager support where required
Participating in Incidents and Changes as part of BAU Operational activities
Participating in Scheduled Disaster Recovery or SCM activities
Participating in post-mortems and RCAs (Root Cause Analysis) of critical incidents
Install, configure, and maintain Oracle and SQL Server databases.
Optimize database performance, including indexing, query tuning, and resource management.
Ensure database security by implementing best practices for user access control, encryption, and auditing.
Implement native security features in Oracle (TDE, Data Redaction, Database Vault) and SQL Server (TDE, Always Encrypted).
RAC, high availability (HA), and disaster recovery (DR) strategies.
Automate database monitoring and maintenance tasks.
Must Haves
5-7 years of experience in Azure Cloud database (Focus on MSSQL)
Experience with PostgreSQL – 2+ years
Setup/Installation and configuration of DB products
Experience in Tuning, Query Optimization, Monitoring and Troubleshooting database issues
Cloud migration experience
Exhibit knowledge of DB backup restore and recovery
Nice To Have
ServiceNow Ticketing System
SolarWind Performance Tool
Azure Certification
FI experience
Soft Skills
Strong critical thinking, problem solving and communication skills Demonstrated ability to work collaboratively in a team Demonstrated ability to deliver results and provide good customer experience Thrive in fast paced workplace Good integrity