Senior Database Developer

Staples Canada; Richmond Hill; Hybrid; CAD 75,000 - 110,000; Full time

Benefits offered by this job

Associate discount

Health and Dental benefits

RRSP/DPSP

Performance bonuses

Learning & Development programs

Job summary

Staples Canada in Richmond Hill, ON, is seeking a Database Developer to design, implement and maintain moderate to complex databases, ensuring stability, reliability and performance. You will collaborate with cross-functional teams and mentor junior associates.

Responsibilities include creating database objects, optimizing queries, ensuring security and availability, and handling upgrades, backups and migrations.

Qualifications

• Post secondary education or equivalent.
• 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.

Responsibilities

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

Skills

Database design

SQL performance tuning

Cross-functional collaboration

Mentoring juniors

Education

Post-secondary education or equivalent

Tools

MS SQL Server

Code versioning

CLR knowledge

Job description

Job Description

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

#MakeAnImpact

About Us

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.