Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

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

Responsibilities

• Manage and administer MS SQL Servers, including installation, provisioning, configuration, maintenance, performance tuning, backup/recovery, and security.
• Monitor performance, availability, and capacity of database servers and related systems to ensure optimal performance and minimize issues.
• Review and track capacity, logs, and usage of database infrastructure, providing ad hoc reports and metrics.
• Collaborate with internal and external participants to design and build new SQL Servers.
• Establish and implement new policies and procedures, communicating changes effectively.
• Support the Information Services team with application and system implementations, including managing data feeds, integrations, APIs, ETL/ELT processes, and data movement.
• Support hybrid database environments spanning on-premises and cloud platforms, assisting with cloud migrations and modernization initiatives.
• Support the implementation of redundant systems, policies, and procedures for disaster recovery and data archiving.
• Provide second-level support to Helpdesk, escalating to vendors as needed and ensuring resolution.
• Assist in developing procedures and creating supporting documentation.
• Stay updated on new technologies and techniques related to MS SQL Server and other data platforms.
• Participate in various department projects and initiatives.
• Provide on-call responsibility for 24/7 support on a rotational basis.

Requirements

• Post-secondary degree or diploma in Technology or equivalent experience.
• 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 with the ability to manage multiple client needs.
• Excellent communication skills (verbal and written) with the ability to interact with individuals at all levels.
• Ability to plan, organize, schedule, and complete concurrent tasks and projects within tight deadlines.
• Strong interpersonal skills with the ability to work independently and collaboratively.
• Ability to map, understand, and build efficient and user-intuitive processes.
• Sound judgment, including the ability to handle confidential information with discretion.
• Innovative approach to work, seeking opportunities to upgrade the system with new technologies.
• Strong analytical thinking skills.
• Flexibility to work overtime when required.

Skills

• Microsoft SQL Server
• Azure-based database services
• Enterprise data integrations
• Analytics platforms
• Cloud data services
• SSRS
• SSAS
• Log shipping
• High Availability (HA) solutions
• TSQL
• Powershell
• APIs
• Data pipelines
• Database tuning
• Troubleshooting
• Intapp Integrate
• Intapp Walls
• Dell Boomi
• Informatica
• MS Office

Location

• Hybrid

Work Type

• Hybrid
• Full-time

Experience Level

• 5 years of related experience

Education Level

• Post-secondary degree or diploma in Technology or equivalent experience
• Microsoft Certification in Database Administration (MS SQL Server)

Salary/Compensations

• CAD $82,000.00/Yr. - CAD $92,000.00/Yr.

About the Company

• Torys is 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.

Equal Opportunity

• Accommodations are available for applicants with disabilities.