Database Administrator

Torys LLP

2d•$82,000 - $92,000•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

Experience with Intapp Integrate, Intapp Walls, Dell Boomi, Informatica is an asset.

Responsibilities

Managing and administering the MS SQL Servers, including installation, provisioning and configuration, maintenance, performance tuning, backup/recovery, and database security initiatives.
Monitoring performance, availability and capacity of database servers, related systems, and processes to ensure optimal performance. Taking appropriate action to minimize issues and outages.
Reviewing and tracking capacity, logs, and usage of database infrastructure.
Developing and providing ad hoc reports and metrics as required.
Working with internal and external project participants to design and build new SQL Servers.
Establishing and implementing new policies and procedures and communicating changes to appropriate participants.
Supporting 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.
Supporting hybrid database environments spanning on-premises and cloud platforms.
Assisting 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.
Supporting 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.
Providing second-level support to Helpdesk, escalating to vendors as needed, and following through to resolution.
Assisting in the development of procedures and creating supporting documentation.
Staying abreast of new technologies and techniques relating to MS SQL Server and other relevant data platforms.
Participating in various department projects and initiatives as assigned.
Providing on-call responsibility for 24/7 support, on a rotational basis.