SQL Developer

Location: Toronto, ON, CA

Must be eligible to work in Canada

Employment details

• Number of Positions: 1
• Duration: 3 months initial contract to start

Responsibilities

• The SQL Developer with TOAD proficiency, focusing on Oracle database development and management, leveraging TOAD as a primary tool.
• Designing, developing, and maintaining complex PL/SQL stored procedures, functions, packages, triggers, and views for various business functionalities.
• SQL querying, optimization, and performance tuning using techniques such as EXPLAIN PLAN, SQL*TRACE, AUTOTRACE, and query hints.
• Database object management including creating/modifying tables, indexes, materialized views, and other schema components.
• Data manipulation and ETL tasks, potentially using PL/SQL scripts, SQL Loader, or other tools.
• Performance tuning to resolve bottlenecks and optimize indexing, queries, and database co...