Database Reliability Specialist

WIS International; Mississauga; On-site; CAD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a Director of Information Technology to lead the management and optimization of SQL databases within their organization. This pivotal role involves ensuring the performance, security, and reliability of database systems while collaborating with cross-functional teams to design scalable solutions. Candidates should have extensive experience with Microsoft SQL Server and Azure SQL, along with strong skills in performance tuning and disaster recovery planning. If you're passionate about IT strategy and infrastructure, this opportunity offers a chance to make a significant impact in a dynamic environment.

Qualifications

• 3+ years of experience with Azure SQL and Microsoft SQL Server.
• Strong understanding of relational database concepts and SQL.
• Excellent communication skills for cross-functional collaboration.

Responsibilities

• Manage and optimize Microsoft SQL Server and Azure SQL databases.
• Collaborate with developers to design scalable database structures.
• Implement backup and recovery strategies to safeguard data.

Skills

Microsoft SQL Server

Azure SQL

Performance Tuning

Backup and Recovery

PowerShell

SQL Query Language

Disaster Recovery Planning

ITIL

SDLC

Education

Bachelor's degree in Computer Science

Certifications in Azure Database Administration

Tools

Azure Data Factory

Azure Synapse

PostgreSQL

MySQL

Job description

3 weeks ago Be among the first 25 applicants

Direct message the job poster from WIS International

Director of Information Technology | IT Strategy | IT Infrastructure | Azure | AWS | Information Security | IT Service Management | ITIL | SDLC |…

The position is responsible for managing, maintaining, and optimizing Microsoft SQL Server and Azure SQL databases within an organization. They play a critical role in ensuring the performance, availability, security, reliability and automation of the database systems. Their duties include database design, installation, configuration, troubleshooting, backup and recovery, performance tuning, security management, and ensuring data integrity.

Responsibilities

• Collaborate with application developers and system architects to design and implement efficient and scalable database structures.
• Create and maintain database schemas, tables, indexes, views, and stored procedures.
• Deploy, manage, automate and secure Azure SQL databases
• Install, configure, and upgrade on prem Microsoft SQL Server instances, including applying patches and service packs.
• Configure database settings and options to optimize performance and ensure security.
• Monitor database performance using built-in tools and third-party monitoring solutions.
• Identify and resolve performance bottlenecks through query optimization, indexing strategies, and server configuration adjustments.
• Participate in rotating On-Call coverage or emergency response, as needed.
• Develop and implement backup and recovery strategies to safeguard critical data.
• Perform regular backups, test restores, and maintain backup integrity.
• Develop disaster recovery plans and participate in recovery drills.
• Implement and enforce security policies and access controls to protect sensitive data.
• Manage user permissions, roles, and privileges.
• Monitor for security vulnerabilities and apply security patches and updates.
• Diagnose and resolve database-related issues, including connectivity problems, performance degradation, and data corruption.
• Conduct root cause analysis and implement preventive measures to mitigate future incidents.
• Estimate future database growth and plan for scalability requirements.
• Optimize resource utilization to accommodate increasing workloads.
• Maintain accurate documentation of database configurations, procedures, and processes.
• Generate reports on database performance, availability, and security compliance.

Qualifications

·Bachelor’s degree in computer science, Information Technology, or a related field; a combination of training and experience may be considered in lieu of degree.

· A minimum of 3 years of experience in design, implementation and support of Azure SQL and proficiency in Azure services. Intermediate to advanced level knowledge of Microsoft Azure

·A minimum of seven (7) years of experience in design, implementation and support of Microsoft SQL Server in Windows Server environments

· Strong understanding of relational database concepts and SQL query language.

· Experience with performance tuning, indexing, and query optimization.

· Familiarity with backup and recovery procedures, disaster recovery planning, and high availability solutions (e.g., clustering, replication, AlwaysOn).

·Experience supporting production and pre-production environments across multiple locations and the technologies to support them.

· Ability to troubleshoot database-related issues and perform root cause analysis.

·Advanced knowledge of PowerShell working with database environments

· Excellent communication and collaboration skills for working with cross-functional teams.

· Understanding of ITIL and SDLC

Preferred Qualifications & Skills:

· Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Management and Analytics (SQL Server).

·Azure Data Factory (ADF) and Azure Synapse

·PostgreSQL, and MySQL are a plus.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Business Consulting and Services

Referrals increase your chances of interviewing at WIS International by 2x

Get notified about new Database Specialist jobs in Mississauga, Ontario, Canada.

Database Engineering - IT & Security Intern

Junior Application and Database Developer

Database Engineering - Master’s Level Internship

Data Analyst (Hybrid) - Foundation - Temporary Full-Time 2025-13164 (2025-13164)

RQ04205 - Database Administrator - Senior

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.