SQL Developer

Randstad Digital; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A recruitment firm is seeking an experienced SQL Developer in Toronto, Ontario. The role involves Oracle database development using TOAD, with responsibilities in performance tuning, PL/SQL design, and collaboration with other IT professionals. Candidates should have a Bachelor's degree and 5-10 years of relevant experience. This is an initial 3-month contract position.

Qualifications

• 5-10 years of experience as an Oracle SQL/PL/SQL Developer.
• Extensive experience with Oracle databases (versions 11g, 12c, 19c).
• Strong knowledge of database design principles and normalization.

Responsibilities

• Design and maintain complex PL/SQL stored procedures and functions.
• Optimize SQL queries using performance tuning techniques.
• Collaborate with developers and business analysts for project success.

Skills

TOAD proficiency

Oracle database development

SQL optimization

PL/SQL development

Troubleshooting skills

Strong communication skills

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

TOAD for Oracle

Oracle SQL Developer

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 configuration.
• Code review and adherence to coding standards, maintaining code quality.
• Troubleshooting and debugging within the database environment, including analyzing error logs.
• Documentation of database designs, procedures, and processes.
• Collaborating with other developers, business analysts, and DBAs to ensure project success.

Qualifications and Skills

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 5-10 years of experience as an Oracle SQL/PL/SQL Developer.
• Extensive experience with Oracle databases (versions such as 11g, 12c, 19c).
• Strong knowledge of database design principles, normalization, and data modeling.
• Expertise in TOAD for Oracle, and experience with Oracle SQL Developer.
• Strong analytical, problem-solving, and communication skills.
• Reinsurance, insurance, and finance knowledge/experience.

Job Function and Industries

• Job function: Information Technology
• Industries: IT Services and IT Consulting, Insurance, and Financial Services

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.