Log In
Sign Up
Company Profile:
Join one of the fastest growing companies in Canada! LawDepot is proud to be a seven-time Growth 500 ranked organization and a major player in the Global legal solutions industry. Our mission is to modernize the legal document creation experience by empowering people with fast, easy-to-use, and professional solutions. With over ten million satisfied customers worldwide, over two million monthly website visitors, and billions of dollars saved on legal fees, you will be joining a team that is truly making a difference. At LawDepot, we foster a collaborative and inclusive learning culture that values excellence and diversity. Apply today and become a part of our exciting journey!
Position Overview:
LawDepot.com is currently expanding and looking to recruit a talented Database Developer with a strong emphasis on Microsoft SQL Server and T-SQL expertise in Edmonton, Alberta. Working with the Information Systems team, you will play a critical role in enhancing current company databases and contributing to the development of innovative future database projects. This is a full-time permanent position, working 37.5 hours per week.
Primary Responsibilities:
- Create, develop, manage, and optimize SQL Server-based database solutions for a large scale, eCommerce website
- Design, refine, and tune T-SQL stored procedures, functions, triggers, and other schema objects to ensure data integrity, scalability, and security
- Collaborate with software developers and cross functional teams to translate intricate data requirements into robust and efficient database designs
- Apply industry-leading practices in analyzing query plans, diagnosing performance bottlenecks, and optimizing both programmability and storage objects for maximum efficiency
- Craft effective, high-performing, and streamlined SQL queries and related database objects
- Contribute to database administration tasks, such as monitoring and troubleshooting performance issues, disaster recovery planning, system configurations, and strategic planning for long-term database stability and growth
- Ensure database architecture, procedures, and best practices is maintained and updated
Knowledge and Skill Requirements:
- Post-Secondary education in Computing Science or equivalent (ex. Information Systems Technology)
- 2+ years of professional/academic experience developing T-SQL for Microsoft SQL Server or Microsoft Azure SQL Database
- Strong proficiency in SQL, with an emphasis on the intricacies of the SQL Server engine and its performance tuning
- Knowledgeable in creating efficient Data Definition Language (DDL) and Data Manipulation Language (DML) SQL code for SQL Server
- Demonstrable experience ensuring the security, integrity, and optimal performance of SQL Server databases
- Excellent interpersonal, verbal, and written communication skills
- The following knowledge would be considered an asset:
- ETL development and support (ex. SSIS package development or custom ETL solutions)
- Microsoft development languages and tools for use with database systems
- Git proficiency
- Agile/Scrum methodologies experience
- Related Microsoft SQL Server Certification
- Entity framework or ORM experience
Why You Should Join the LawDepot team:
- Excellent total compensation package
- Comprehensive health and dental benefits, plus an additional Health Care Spending Account
- Great work life balance (37.5 hour work weeks, flexible schedules, ability to bank hours)
- Three weeks paid vacation, plus bonus personal days
- Continuous learning opportunities, including LinkedIn Learning subscriptions and training budgets
- Company shares plan
- Free catered lunches for the entire office
- Monthly social events for team members to enjoy (think axe throwing, rock climbing, board games, food trucks, trivia contests, and charitable activities)
- Casual work environment
- Personal offices for focused work and to have your individual space (plus collaborative workspaces for when you want to meet with the team)
- Free and easily accessible parking
- Southgate Mall, Whyte Ave, and Calgary Trail restaurants are only minutes away
How To Apply:
Please submit a resume and cover letter by email to [email protected] or submit online via our Careers page at https://www.lawdepot.ca/career
We thank all applicants; however, only those selected for an interview will be contacted.
