Position Title: DBA - Expert - (MSSQL)

Hybrid - in office every Tuesday for the time being.

Line of Business: Capital Market, PBBT, and Retail Banking

Potential for this contract to be extended or converted to FTE: Possibility for both but depends on budget and performance

Work Schedule: Monday - Friday, 9:00 am – 5:00 pm. A little flexibility with work hours. 37.5hours/week. Overtime may be required; weekends may be required (on call) *1 person each week is on standby - this will be a rotating person each week.

Interview Process: maximum 2 rounds of technical interview possible with HM + team members; MS Teams and 2nd will be in person on a Tuesday. 2PM to 4PM ideally

Decisioning process: extending offer within a business day based on the Director's decision.

Project the contractor will be working on: providing database support related to Oracle build, migration, performance tuning and incident resolutions.

Group information: 20 DBAs on the team, team is sub divided in 2 teams and support database for various lines of business, doing complex trouble shooting, code deployment, BAU activities

EVP (Employee Value Proposition): Close-knit team, great technical team to learn from. Very independent role where strong initiative is required in this role. Team consists of strong leadership that support career growth and providing mentorship throughout. This is a great opportunity to grow skills and learn. Core values of this team is teamwork, trust, and accountability. Lastly, conversion is very likely.

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

- Analyzing 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:

Solid 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 environment

Good integrity

Job Types: Full-time, Fixed term contract, Freelance

Pay: $80.00-$82.00 per hour

Experience:

- Focus on MSSQL: 5 years (required)

Work Location: Hybrid remote in Toronto, ON

📌 MS SQL Server DBA (MSSQL) (Toronto)
🏢 Alliance Search Partners
📍 Toronto