SQL Server / SSIS ETL Developer

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

Database and ETL Development Analyze business requirements and convert them into technical specifications, data mappings, ETL rules, and implementation tasks. Design, develop, and maintain SQL Server database objects including tables, stored procedures, functions, views, indexes, and scripts. Develop, enhance, and troubleshoot SSIS packages for data extraction, transformation, loading, validation

SQL Developer with strong expertise in writing and optimizing complex SQL queries. The candidate will be responsible for performance tuning, database development, and ensuring efficient data retrieval to support business applications and reporting needs.

Key Responsibilities

Develop, write, and maintain complex SQL queries, stored procedures, and functions Perform query optimization and performance tuning Analyze and improve slow-running queries and execution plans Design and implement efficient database structures and indexing strategies Work closely with application and data teams to understand data requirements Troubleshoot data-related performance issues Support ETL processes and data transformations (if applicable) Ensure data integrity, consistency, and security Document database designs, logic, and optimization techniques

Required Skills

Strong expertise in SQL (Oracle / SQL Server ) Hands-on experience in:

Complex joins, subqueries, and CTEs

Window functions (ROW_NUMBER, RANK, etc.) Stored procedures, triggers Experience in query optimization and performance tuning