Senior MS Sql DBA

Raise; Toronto; Hybrid; CAD 90,000 - 130,000; Part time

Benefits offered by this job

Hybrid work model

Job summary

Raise is seeking a seasoned SQL Server DBA to join our Toronto-based team on a 6-month contract with potential conversion to FTE. The role is hybrid, requiring in-office Tuesdays, and focuses on Azure MSSQL and PostgreSQL workloads, high-availability, security, and disaster recovery.

You will own incident resolution, performance tuning, and database maintenance, collaborating with Solution Design, DB Engineering, and Information Security teams to deliver reliable data services.

Qualifications

• 5-7 years of Azure SQL Server experience.
• 2+ years PostgreSQL experience.
• Setup/Installation and configuration of DB products.
• Experience in Tuning, Query Optimization, Monitoring and Troubleshooting database issues.
• Cloud migration experience.
• DB backup, restore, and recovery knowledge.

Responsibilities

• Lead production Incident resolutions.
• Communicate complex issues to stakeholders.
• Follow change control and DB security policies.
• Analyze recurring incidents for improvements.
• Provide on-call pager support.
• Participate in BAU incidents and changes.
• Participate in scheduled DR/RCAs.
• Install, configure, and maintain SQL Server databases.
• Optimize performance via indexing and query tuning.
• Implement native SQL Server security features.
• Support HA/DR strategies.
• Automate monitoring and maintenance tasks.

Skills

Azure MSSQL

PostgreSQL

Performance tuning

Cloud migration

Database security

Incident management

On-call support

Tools

ServiceNow

SolarWinds

Job description

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