We are looking for a Junior to Intermediate SQL Developer for a 6 months contract with high possibility of extension. Role is hybrid with 3 days a week on site in Downtown Toronto.
The successful candidate will take ownership of database reliability, performance, security, and availability while working closely with development, infrastructure, and business teams. We are seeking someone who enjoys investigating complex technical challenges, improving existing systems, and exploring new technologies to support evolving business needs.
While SQL Server is the primary focus, experience with cloud data platforms, scripting, and other enterprise database technologies will be considered a strong asset.
Key Responsibilities
- Manage the day-to-day operation, maintenance, and health of Microsoft SQL Server databases across enterprise environments.
- Analyze and resolve complex database issues, including performance degradation, connectivity problems, and data-related errors.
- Design, troubleshoot, and refine SQL queries, stored procedures, and database processes to improve efficiency and reliability.
- Establish and maintain effective backup, recovery, security, and data integrity practices.
- Perform database installations, upgrades, configuration changes, migrations, and ongoing maintenance.
- Identify performance trends and capacity concerns, recommending and implementing solutions to support system growth.
- Create and maintain scripts and automated processes that reduce manual effort and improve operational consistency.
- Work with developers, infrastructure specialists, and business partners to support applications and resolve technical challenges.
- Contribute to database design decisions, operational standards, technical documentation, and continuous improvement initiatives.
- Assist with cloud-based data solutions and other database technologies as business requirements evolve.
Required Qualifications
Candidates must meet the following minimum requirements:
- At least 5 years of professional experience in database administration.
- A university degree in Computer Science from a recognized institution.
- Demonstrated hands-on experience administering Microsoft SQL Server databases, including maintenance, configuration, troubleshooting, and performance tuning.
- Advanced SQL skills, with the ability to develop, analyze, and optimize complex queries, stored procedures, and database operations.
Preferred Technical Experience
Experience with the following technologies is an asset, with preference given in the order listed:
- Google Cloud Platform (GCP) – BigQuery: Experience with cloud data warehousing, large-scale data processing, and query optimization.
- Python: Ability to develop scripts and automate routine database tasks or data processing activities.
- SAP HANA: Familiarity with database administration, performance management, or production support.
- SAP IQ: Experience supporting or maintaining SAP IQ database environments.
- Korn Shell (ksh): Proficiency in shell scripting for automation, system operations, and database support.
Note: We use AI tools to: obtain basic information, detect plagiarism, false employment history or references, categorize your skills, and do an initial match with job posting.
