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