Database Developer - Jobs in Edmonton

Job Description

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 websiteDesign, refine, and tune T-SQL stored procedures, functions, triggers, and other schema objects to ensure data integrity, scalability, and securityCollaborate with software developers and cross functional teams to translate intricate data requirements into robust and efficient database designsApply industry-leading practices in analyzing query plans, diagnosing performance bottlenecks, and optimizing both programmability and storage objects for maximum efficiencyCraft effective, high-performing, and streamlined SQL queries and related database objectsContribute 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 growthEnsure database architecture, procedures, and best practices is maintained and updatedKnowledge 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 DatabaseStrong proficiency in SQL, with an emphasis on the intricacies of the SQL Server engine and its performance tuningKnowledgeable in creating efficient Data Definition Language (DDL) and Data Manipulation Language (DML) SQL code for SQL ServerDemonstrable experience ensuring the security, integrity, and optimal performance of SQL Server databasesExcellent 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 systemsGit proficiencyAgile/Scrum methodologies experienceRelated Microsoft SQL Server CertificationEntity framework or ORM experienceWhy You Should Join the LawDepot team: Excellent total compensation packageComprehensive health and dental benefits, plus an additional Health Care Spending AccountGreat work life balance (37.5 hour work weeks, flexible schedules, ability to bank hours)Three weeks paid vacation, plus bonus personal daysContinuous learning opportunities, including LinkedIn Learning subscriptions and training budgetsCompany shares planFree catered lunches for the entire officeMonthly social events for team members to enjoy (think axe throwing, rock climbing, board games, food trucks, trivia contests, and charitable activities)Casual work environmentPersonal 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 parkingSouthgate Mall, Whyte Ave, and Calgary Trail restaurants are only minutes awayHow To Apply:Please submit a resume and cover letter by email to career@lawdepot.ca or submit online via our Careers page at https://www.lawdepot.ca/careerWe thank all applicants; however, only those selected for an interview will be contacted.