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

• Sign In
• Create Account

Sign in

To continue your application

Sign in with Google

Sign in with Linkedin

---

or continue with email

Email address

Password

Forgot your password?

Resume or CV

Improve your chances of getting an interview

Drag & drop or browse

.pdf, .doc, .docx (Max 10MB)

Continue →

By continuing you agree to our Terms & Privacy Policy.