Senior MS Sql DBA

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