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