Systems Analyst / SQL Server DBA

Company Profile: 

A leading regional Canadian business law firm with offices in Vancouver, Kelowna, Calgary and Yellowknife is currently recruiting for the position of Systems Analyst / SQL Server DBA in their Vancouver IT Department.

Responsibilities for this position include, but are not limited to:

• Database administration & maintaining/enhancing scripts for SQL Server databases

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security

• Development and maintenance of custom interfaces & jobs using T-SQL

• Perform scheduled maintenance and support release deployment activities after hours

• Application support for law firm systems, including Intranet Portal, document management system (iManage),

• Administration of the firm’s Intranet portal and support for associated interfaces


• Certificate or diploma in information technology or computer systems

• A minimum of 3-years’ experience in an IT environment, and specifically with MS SQL Server Administration (DBA)

• Very strong experience and skills with Microsoft Office applications & Adobe PDF • Basic skills and experience with Powershell commands and scripting

• Basic web development skills (HML, ASP, ASP.NET, CSS)

• Experience with Active Directory administration, especially for service accounts

• Strong technical and analytical skills

• Successful completion of a Canadian criminal records check

• Strong verbal and written communication skills in English

• Willing to work flexible hours when required

• This position is required to be on-site in our downtown Vancouver office.

• Ability to work in a cooperative group environment

• Good Interpersonal skills and a positive attitude

• Ability to be resilient when dealing with stressful situations or people

• Self-motivated and able to multi-taskNice to have

• MS Access development

• Experience with MS SharePoint administration

• Litigation discovery management software experience in either Summation or iPro Eclipse

• Experience working in a medium/large law firm

• Microsoft Certifications

If you are interested in becoming part of our dynamic environment and would like to apply for this position, please submit your resume with a covering letter to the attention to Chief Information Officer.