Sr. Database Engineer
at autoTRADERca
Toronto, ON, Canada -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 10 Aug, 2024 | Not Specified | 11 May, 2024 | 5 year(s) or above | Sql Tools,Working Experience,Microsoft Products,Github,Data Analysis,Functionality,Database Development,Stored Procedures,It,Solid Principles,Security,Jira,Software Industry,Computer Science,Software,Sql Server,Databases | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – Corp 2 Corp |
Contract to Hire – Corp 2 Corp |
Description:
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.
How To Apply:
Incase you would like to apply to this job directly from the source, please click here
Responsibilities:
Please refer the Job description for details
REQUIREMENT SUMMARY
Min:5.0Max:10.0 year(s)
Information Technology/IT
IT Software - DBA / Datawarehousing
Software Engineering
Graduate
Computer science or related subject
Proficient
1
Toronto, ON, Canada