Senior Database Engineer (1 Year Contract)

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 Developer 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.

• Analyze query performance and perform index tuning.

• Administration of SQL databases including security, backup, restore, upgrades, 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 and Azure SQL with expertise in stored procedures, functions, queries, views, and triggers.

• Cloud technology experience Azure and AWS.

• Experience with PostgreSQL.

• SQL Administration experience: upgrades, disaster recovery.

• Knowledge of Microsoft products including Azure Blog/Table storage, Document DB 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 and troubleshooting 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.

• Experience with database administration.

• PostgreSQL experience.