Database Administrator

Job summary

The Database Administrator is responsible for the administration, security, performance, and availability of Microsoft SQL Server databases. This role also supports cloud-based data initiatives, enterprise integrations, and automated data pipelines within a hybrid environment.

Job details

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, escalate 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 firmadminrecruiting@torys.com. 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 jtavares@torys.com. 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.

What you’ll do

The Database Administrator is responsible for the administration, security, performance, and availability of Microsoft SQL Server databases. This role also supports cloud-based data initiatives, enterprise integrations, and automated data pipelines within a hybrid environment.

Requirements

Candidates must have at least 5 years of related experience and a Microsoft Certification in Database Administration. Strong proficiency in relational database concepts, TSQL, and cloud data services is required.

Listed skills

• Continuous Improvement · Preferred
• Microsoft Azure · Preferred
• SQL · Preferred
• Analytical · Preferred
• Recruitment · Preferred
• Microsoft · Preferred
• Client · Preferred
• Process · Preferred
• Integrations · Preferred
• Communication · Preferred
• Communication Skills · Preferred
• Configuration · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Microsoft SQL Server
• Database Administration
• Azure SQL Database
• Performance Tuning
• Backup and Recovery
• TSQL
• Powershell
• ETL/ELT
• Data Pipelines
• API Integration
• SSRS
• SSAS
• Cloud Migration
• Disaster Recovery
• Capacity Planning
• Database Security
• Ad Hoc Reporting
• Dell Boomi (Integration Platform)
• Backup and Recovery System
• Informatica
• Tactfulness
• Azure Data Factory
• Analytical Thinking
• Diplomacy
• Enterprise Integration
• Follow Through
• Microsoft Fabric
• Application Programming Interface (API)
• Artificial Intelligence
• Microsoft Azure
• Building Codes
• Business Continuity
• Communication
• Continuous Improvement Process
• Scientific Data Archiving
• Dataflow
• Extract Transform Load (ETL)
• Data Security
• Relational Databases
• Database Servers
• Database Tuning
• Help Desk Support
• Innovation
• Interpersonal Communications
• Log Shipping
• Microsoft Certified Professional
• Microsoft SQL Servers
• Windows PowerShell
• SQL (Programming Language)
• SQL Server Reporting Services

Job areas

• Technology
• Data & Analytics
• Software
• Administrative
• Database Administrator
• Database Designers and Administrators
• Database Administrators

More jobs from Torys LLP