Database Administrator

Torys LLP; Toronto; Hybrid; CAD 82,000 - 92,000; Full time

Benefits offered by this job

Hybrid work model (3 days in office)

Job summary

Torys LLP in Toronto is seeking a Database Administrator to lead the administration, security, performance, and ongoing improvement of MS SQL Server environments, including Azure-based services and cloud data integrations.

This hybrid role supports both on-premises and cloud deployments, requires 5 years of related experience and a Microsoft Database Administration certification, and offers 3 days in the office per week for onboarding and collaboration.

Qualifications

• 5 years of related experience in a professional services environment.
• Microsoft Certification in Database Administration is required.
• Strong understanding of relational database concepts and SQL Server administration.

Responsibilities

• Administer MS SQL Servers, including installation, provisioning, configuration, and security.
• Monitor performance, availability, capacity, and implement disaster recovery measures.
• Support cloud migrations and Azure SQL Database/Managed Instance with data pipelines and integrations.
• Provide second-level Helpdesk support and coordinate with vendors as needed.
• Design and build new SQL Servers and maintain data feeds, APIs, and ETL/ELT processes.

Skills

MS SQL Server

Database security

Performance tuning

Azure SQL/Cloud data services

ETL/ELT data pipelines

SSRS

SSAS

PowerShell

Intapp Integrate

Education

Post-secondary degree or diploma in Technology

Microsoft Certification in Database Administration

Tools

SSRS

SSAS

Intapp Integrate

Intapp Walls

Dell Boomi

Informatica

Azure Data Factory

Job description

Position Overview

The Database Administrator is responsible for the administration, security, performance, availability, and continuous improvement of the firm's databases (Microsoft SQL Server). This role also supports the firm’s data initiatives as it relates to Azure-based database services, enterprise data integrations, analytics platforms, and cloud data services.

Key Accountabilities

• Responsible for managing and administering the MS SQL Servers, including installation, provisioning and configuration, maintenance, performance tuning, backup/recovery, and database security initiatives.
• Monitor performance, availability and capacity of database servers, related systems, and processes to ensure optimal performance. Take appropriate action to minimize issues and outages.
• Review and track capacity, logs, and usage of database infrastructure. Develop and provide ad hoc reports and metrics as required.
• Work with internal and external project participants to design and build new SQL Servers.
• Establish and implement new policies and procedures and communicate changes to appropriate participants.
• Support Information Services team with implementing and modifying applications, systems, and automated processes, including managing data feeds, enterprise integrations, APIs, ETL/ELT processes, automated data pipelines, and secure data movement between internal and third-party systems.
• Support hybrid database environments spanning on-premises and cloud platforms. Assist with cloud migrations and database modernization initiatives including administration and support for Azure SQL Database, Azure SQL Managed Instance, Microsoft Fabric, Data Factory, and other cloud-based data services.
• Support the implementation of redundant systems, policies, and procedures for disaster recovery and data archiving to ensure the protection, integrity, and business continuity of data assets.
• Provide second-level support to Helpdesk, elevate to vendors as needed, and follow through to resolution.
• Assist in the development of procedures and create supporting documentation.
• Stay abreast of new technologies and techniques relating to MS SQL Server and other relevant data platforms.
• Participate in various department projects and initiatives as assigned.
• Provide on-call responsibility for 24/7 support, on a rotational basis.

Attributes & Experience

• Post-secondary degree or diploma in Technology or equivalent experience to successfully complete the essential requirements of the role.
• 5 years of related experience, preferably in a professional services environment.
• Microsoft Certification in Database Administration (MS SQL Server) is required.
• Strong understanding of relational database concepts, structures, theories, principles and practices.
• Experience with designing, building, installing, configuring and supporting SQL servers.
• Experience with SSRS and SSAS, log shipping and HA solutions.
• Experience with TSQL, Powershell, enterprise integrations, APIs, and data pipelines.
• Hands-on database tuning and troubleshooting experience.
• Experience with Intapp Integrate, Intapp Walls, Dell Boomi, Informatica is an asset.
• Proficient in MS Office product suite.
• Strong client service orientation combined with the ability to manage multiple client needs at the same time.
• Excellent communication skills (verbal and written) with the ability to interact with individuals at all levels within the organization with tact and diplomacy.
• Ability to plan, organize, schedule and complete concurrent tasks and projects within tight deadlines in a high-pressure environment with exceptional attention to detail.
• Strong interpersonal skills with the ability to work well both independently and collaboratively within a team environment.
• Ability to map, understand and build processes such as data flow, criticality and dependencies that are efficient and user intuitive.
• Sound judgment, including the ability to deal with confidential information with utmost discretion.
• Innovative approach to work, consistently looking at ways of upgrading the system to more efficient and effective new technologies.
• Strong analytical thinking skills.
• Flexibility to work overtime when required.

Additional information

HybridThis position is part of our hybrid work model with 3 days in the office per week. As part of our onboarding, new hires are required to be in the office more often for the first few months of employment to ensure they receive the requisite cross training.

This job posting is for an existing vacancy.

Salary will be determined based on the candidate’s skills, experience, and qualifications.

We are committed to leveraging innovative tools to enhance our recruitment process. As part of this, we use AI-powered tools to assist in the initial stages of candidate shortlisting and screening. These tools help us evaluate applications more efficiently and consistently by focusing on qualifications, experience, and skills relevant to our roles. Although we use this technology, all applications are reviewed, and decisions made by our Human Resources team to ensure fairness and alignment with our firm policies. If you have any questions or concerns about this process, feel reach out to us at [e-mail].

At Torys, we are committed to diversity in the recruitment, retention and advancement of our people. We believe that diversity of backgrounds, experience and perspectives enhances the quality of our work and enriches our lives. We are committed to fostering an inclusive and accessible work environment. Accommodations are available for applicants with disabilities. If you require immediate accommodation at any time during the recruitment process, please contact Jenny Tavares, Director, Human Resources at [e-mail].

All offers of employment are subject to background checks. This process includes criminal record checks, social media checks, and employment and educational background checks.

Posted Min Pay Rate

CAD $82,000.00/Yr.

Posted Max Pay Rate

CAD $92,000.00/Yr.