SQL Server & SSIS ETL Engineer - Performance Optimizer

Apptoza Inc.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Apptoza Inc. is seeking a SQL Developer in Toronto to translate business requirements into technical specifications and implement robust database solutions using SQL Server and Oracle.

The role focuses on ETL development, query optimization, and maintaining data integrity for business applications and reporting. The candidate will design and optimize database objects, develop SSIS packages, and work closely with data teams to ensure efficient data retrieval and reliable transformations in a

Qualifications

• Experience with SQL Server/Oracle databases.
• ETL development experience with SSIS preferred.
• Ability to optimize complex SQL queries and analyze execution plans.
• Strong understanding of data modeling, indexing, and data integrity.

Responsibilities

• Develop, write, and maintain complex SQL queries, stored procedures, and functions.
• Perform query optimization and performance tuning.
• Design efficient database structures and indexing strategies.
• Collaborate with application and data teams to define data requirements.
• Document database designs and optimization techniques.

Skills

SQL

Query optimization

ETL

SSIS

Stored procedures

Functions

Indexes

Data integrity

Performance tuning

Tools

Oracle

SQL Server

Job description

Apptoza Inc. is seeking a SQL Developer in Toronto to translate business requirements into technical specifications and implement robust database solutions using SQL Server and Oracle.

The role focuses on ETL development, query optimization, and maintaining data integrity for business applications and reporting. The candidate will design and optimize database objects, develop SSIS packages, and work closely with data teams to ensure efficient data retrieval and reliable transformations in a