Database Developer

Some of what you will do:

Responsibilities will include the design, creation and maintenance of moderate to complex databases and ensuring their stability, reliability, and performance. Should be able to understand and support cross platform interfaces and participate in cross-functional projects that include multiple business processes. May be called upon to lead and coordinate developer resources on assigned projects, meet with business users to determine requirements, and mentor more junior associates.   

Specifically, You Will:

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

Some of what you need:

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

• Certification is a plus; MCTS, MCITP, MVP.

• Knowledge of front/middle layer and/or CLR is a plus.

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

Physical demands/working conditions:

• Office environment – Hybrid, with 4 days onsite in Richmond Hill, subject to the hybrid policy.

Some of what you will get:

• Associate discount

• Health and Dental benefits

• RRSP/DPSP

• Performance bonuses

• Learning & Development programs

• And more...

We value transparency in our hiring processes. Please note, artificial intelligence may be used in certain stages to screen, assess, or select applicants, however, a human reviewer makes all final decisions. This posting is for an existing vacancy. About the Team 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.