Senior MS Sql DBA

Position Title: DBA - Expert - (MSSQL)

No. of Positions: 2

Duration: 6 months- Potential for this contract to be extended or converted to FTE

Work location: Toronto, ON, Hybrid - in office every Tuesday for the time being.

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

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

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

• Good integrity