Sr. Database Engineer

Toronto, ON
Digital – 1 Source /
Full-Time /
Hybrid
TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of AutoTrader.ca, AutoSync and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500 subscribers and counting, AutoSync is the largest and fastest growing dealer and OEM software provider in Canada. The platform's suite of connected automotive software solutions brings advertising, conversion and operational support together, synchronizing the entire retail process. AutoSync's diverse range of offerings includes: vAuto, EasyDeal, xtime, Motoinsight, Activix, TAdvantage and TRFFK. Dealertrack is Canada’s largest automotive financing portal, enhancing efficiency and profitability for all major segments of the automotive, marine, recreational vehicle, motorcycle and powersport retail industries. Over 6.5 million credit applications are submitted via the Dealertrack Canada portal each year. Visit tradercorporation.com to learn more..

Trader Corporation is the team behind Canada’s leading automotive marketplace, autoTRADER.ca. We are a technology driven company that creates world class solutions for our users and dealer customers. We are expanding and need a Senior Database Engineer to join one of our teams.

Key Areas of Responsibility 
•Design and develop elegant database solutions which are end-to end: from technical analysis and data implementation/architecture, through to unit testing, development, and integration testing.
•Create and maintain schema objects, including complex store procedures, indexes, triggers, and scripts.
•Participate in thorough code-reviews and use your eye for clean data structures to support maintenance and extensibility.
•Perform root cause analysis on defects, identify corrective action, and liaise with production support to resolve issues.
•Analyse query performance and perform index tuning.
•Administration of SQL databases including security, backup, restore, auditing and replication.
•Work with the rest of the team to evaluate the suitability of 3rd party packages and solutions.
•Maintain continuous integration and continuous deployment for data apps, while keeping data environments synchronize.
•Participate in paid on-call rotation schedule to respond to alerts, as well as prioritize system improvements identified as part of monitoring.

Required Skills
•Extensive knowledge of SQL Server, Azure SQL, and data analysis with expertise in stored procedures, functions, queries, views, and triggers.
•Knowledge of Microsoft products including Azure Blog/Table storage, DocumentDB, Azure SQL, and Azure Data Factory.
•Knowledgeable in SQL tools like SSRS & SSIS.
•Strong experience with XML-based data design.
•Working experience on high-traffic websites and databases, while leveraging techniques to enable performance availability, security, and monitoring.
•Ability to deliver non-relational data stores when appropriate.
•Able to conceptualize a technical solution and relay it to other team members and stakeholders.
•Work with Trader’s architecture group to implement software against reference specification.
•Experience in building unit, component, and integration tests and knowledge of how to use this as a system contract between other system end points.
•Know how to work with source code management and delivery platforms like Github, Azure Dev Ops, and JIRA in a distributed team environment.
•Some exposure to C# development, including an understanding of SOLID principles.
•Excellent problem-solving skills.
•Able to work with a team.

Required Experience
•University Degree (or equivalent) in Computer Science or related subject.
•5+ years of experience in the online software industry; strong knowledge of data design, functionality, and scaled architectures.
•Expert level experience with Microsoft database development.

What’s in it for you…
-We understand that there is life at work and life outside of work. Here are a few benefits we all benefit from that support us to be our creative best.
 
Fitness and wellness
-We provide discounts to nation-wide gyms, onsite gyms (when we’re in the office), an Employee and Family Assistance Program, as well as a virtual wellness program.
 
Benefits from Day 1
-Gym discounts
-Local in-office free gyms
-Employee and Family Assistance program
-Weekly virtual wellness events
-Conferences & training budget
-Regular internal training programs
 
Financial planning
-Let us help you invest in your future with 3% matching towards your pension and multiple forms of income protection.
 
Competitive salary
-Annual bonus structure
-3% CPP matching