Talent.com
Sr. Database Engineer

Sr. Database Engineer

AutoTrader.caToronto, ON
30+ days ago
Salary
CA$112,400.00–CA$156,100.00 yearly
Job description

Trader Corporation is the team behind Canada’s leading automotive marketplace, . 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-In addition to in-house training, we provide an annual lifestyle allowance of $1500 so you can grow your skills.-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

    Create a job alert for this search

    Sr. Database Engineer • Toronto, ON