Senior Database Developer

Staples Canada•Richmond Hill, ON

2d•Hybrid

About The Position

At Staples Canada, we are dynamic, inspiring partners to our customers and the communities in which we live. As The Working and Learning Company, we inspire people to work smarter, learn more and grow every day. We’re looking for curious, approachable, and passionate individuals who love finding solutions. If that’s you, let’s work, learn, and grow together. We are building an inclusive and diverse team. Staples Canada is continuously working towards creating an inclusive and diverse work environment. We welcome, value and thrive on perspectives and contributions from backgrounds that vary by race, gender, sexual orientation, gender identity or expression, lifestyle, age, educational background, national origin, religion or physical ability. If you have a disability or special need that requires accommodation, please let us know. This posting is for an existing vacancy. Artificial intelligence may be used in certain stages to screen, assess, or select applicants, however, a human reviewer makes all final decisions.

Requirements

Post secondary education or equivalent work experience.
Skilled at optimizing large, complicated SQL statements.
Knowledge of indexes, index management, and statistics.
Proficient understanding of code versioning tools.
MS SQL Server 2005 and above.
Experience with development and database administration for MS SQL Server 2005 and above.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc.

Nice To Haves

Certification is a plus; MCTS, MCITP, MVP.
Knowledge of front/middle layer and/or CLR is a plus.

Responsibilities

Design, creation and maintenance of moderate to complex databases and ensuring their stability, reliability, and performance.
Understand and support cross platform interfaces.
Participate in cross-functional projects that include multiple business processes.
Lead and coordinate developer resources on assigned projects.
Meet with business users to determine requirements.
Mentor more junior associates.
Create database design.
Develop database objects: stored procedures, functions, triggers etc.
Ensure performance, security, and availability of databases.
Prepare documentation and specifications.
Handle common database procedures such as upgrade, backup, recovery, migration, etc.
Profile server resource usage and optimize and tweak as necessary.
Collaborate with other team members and stakeholders.