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