Database Developer

Descartes Unites the People and Technology that Move the World
The need for efficient, secure, and agile supply chains and logistics operations has become ever more critical and complex. By combining innovative technology, powerful trade intelligence and the reach of our network, Descartes helps get goods, information, transportation assets, and people where they’re needed, when they’re needed.

We’re one of the most broadly deployed logistics and supply chain technology companies in the world. More than 26,000 customers around the globe use our cloud-based solutions to transform the way they move inventory and information to enhance productivity, better serve customers, thrive competitively, keep pace with evolving regulations, and respond to rapidly changing market conditions. Descartes is publicly traded (Nasdaq:DSGX, TSX:DSG) with headquarters in Waterloo, Ontario, Canada, and offices and partners around the world. With record financial performance for more than 16 years, we lead the industry in innovation investment. Every day, logistics service providers, manufacturers, retailers, distributors, and other logistics-intensive businesses of all sizes rely on our scale, stability, and comprehensive solution footprint to move what’s most important to them. Learn more at www.descartes.com.

We’re growing fast and invite you to join our amazing team.

Descartes Systems is seeking an experienced SQL Database Developer. The successful candidate will thrive in a fast-paced Agile/Scrum environment, possessing excellent database analysis, development, and deployment background. Reporting into the R&D function, the candidate will join our Global Trade Intelligence development team supporting cutting edge web-based and client-server multi-platform applications.

Responsibilities:

1. Analysis, design, and support databases in Microsoft SQL server database environment.
2. Responsible for designing and implementing applications using the ASP .NET framework and SQL.
3. Design, develop, code review, bug-fix and test the application.
4. Development and maintenance of SQL and PL/SQL scripts.
5. Expertise in Data Extract, Transform and Loading (ETL) using SSIS packages.
6. Provide consulting and support to other developers in the following areas:
7. Effective utilization of data and database resources.
8. Optimization of stored procedures and SSIS packages.
9. Proficient in creating indexes, views, appropriate SQL functions and triggers.
10. Tuning SQL queries and improving query performance.
11. Create and maintain data dictionaries and database documentation.
12. Troubleshoot database and SQL problems.
13. Taking ownership and understanding business requirements.

Required Skills and Qualifications:

1. University degree in Computer Science, Computer Engineering, or equivalent work experience of 5+ years in an SQL Server DB Developer role and in ASP .NET.
2. Strong verbal and written communication skills, interpersonal, analytical, and troubleshooting skills.
3. Applied knowledge of MS SQL Server tools, SSIS, Performance Tuning and Optimization.
4. Demonstrated ability to create normalized database schemas utilizing data modeling discipline. Understanding of normalization, de-normalization, and the difference between the two.
5. Strong TRANSACT – SQL and PL/SQL skills.

Nice to have:

1. Familiarity with the practical application of JSON and XML in SQL Server.

Location: This is a remote opportunity, open to applicants authorized to work in Canada or the US, with preference given to residents of Canada.

Salary Range: $80,000 to $85,000 CAD “Compensation information provided is a good faith estimate for this position only. Factors that may be used to determine your actual salary may include your specific skills as well as the years of experience you have. Similar positions located in different geographic regions will not necessarily receive the same compensation.”

Join Us
As we scale, we’re looking for new doers, collaborators and innovators to join Descartes in uniting the people and technology that move the world as the Global Leader in Logistics and Supply Chain Technology. We’re entrepreneurial, hardworking, geeky-in-a-good way problem solvers. Guided by our values, we nurture a TEAM focused culture that invests in people and creates opportunities for advancement across a broad spectrum of career paths. We prioritize work-life balance and foster an environment with the space to take ownership, to be heard, and to carve a path for your individual accomplishments to help drive our success. At Descartes, everyone has a voice and the best idea wins, regardless of who makes it. We offer competitive compensation, great benefits, remote and flexible work hours, and the opportunity to join a company on an awesome mission with a great existing team and trajectory.

Environmental Responsibility: Descartes also has a deep sense of environmental responsibility. Learn more about how we helped our customers save over 552,000 metric tons of CO2 in 2020 by reducing fuel and paper consumption: https://www.descartes.com/who-we-are/social-responsibility-sustainability/environmental-impact. Join a team that’s committed to working with customers to conserve resources and enhance sustainability.

If you feel you have 70% of the qualifications we are looking for, and Descartes sounds like the team and the mission you want to be part of, apply now. We can’t promise it will be a fit, but we do promise to consider your experience.

We are an Equal Employment employer. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected status, or any other characteristic protected by federal, provincial, or local law. For more information about our commitment to equal employment opportunity, please review our Code of Business Conduct and Ethics at Descartes.com.