Software Developer - Senior (Oracle/OLAP and OLTP)

Bevertec

Toronto

On-site

CAD 117,000 - 124,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Bevertec in Toronto, ON seeks a Senior Software Developer to lead Oracle 12c OLAP/OLTP development, PL/SQL, and complex SQL. This onsite contract role runs through December 14, 2026 to March 7, 2028.

The ideal candidate will design data warehouses, tune performance, and implement automation. Experience with Informatica ETL and Cognos reporting (Framework Manager, Query Studio, Reports Studio) is highly desirable, along with dashboards and BI tools such as Crystal Reports or Business Objects.

Qualifications

  • Oracle 12c OLAP/OLTP development with PL/SQL and stored procedures.
  • Advanced SQL skills and data architecture design.
  • Data Warehouse design, performance tuning, and automation.
  • translate business requirements into application design.
  • Informatica for ETL/ELT data extraction, transformation and loading.
  • Cognos reporting and dashboard development; familiarity with Crystal Reports/BO.

Skills

Oracle 12c OLAP/OLTP
PL/SQL
Advanced SQL
Data Warehouse design
Informatica
Cognos
Framework Manager
Query Studio
Reports Studio
Crystal Reports
Business Objects
Dashboard development

Tools

Informatica ETL
Cognos reporting tools
Crystal Reports
Business Objects
Framework Manager
Query Studio
Reports Studio

Job description

Job Role: Software Developer - Senior (Oracle (12c)/OLAP and OLTP)

Location : Toronto, ON/Onsite

Position Type : Contract Role

Start Date

2026-12-14

End Date

2028-03-07

5 Days Onsite

Ideal Candidate Rate: CAD 85-90 (Depending on the experience)

Must Have:

  • Design and development of Oracle(12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedure, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
  • Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
  • Data Warehouse design and development, Database performance tuning, Automation
  • Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
  • Informatica for data extraction, transformation, and loading, initial setup and other data management purposes
  • Cognos report design and development, Framework manager, Query Studio, Reports Studio, creation of dashboards, etc. Other reporting tools would also be an asset, particularly Crystal Reports and Business Objects

Note: AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Oracle Database Developer
Senior Oracle Database Developer

Bevertec • Toronto

On-site
CAD 124,000 - 138,000
Business Intelligence Specialist – Senior (OBIEE experience)
Business Intelligence Specialist – Senior (OBIEE experience)

Bevertec • Toronto

On-site
CAD 130,872 - 137,760
Software Developer - ETL - Senior - RQ11635
Software Developer - ETL - Senior - RQ11635

Analyst Technical Solutions • Toronto

On-site
CAD 90,000 - 120,000
RQ08204 - Sr. Software Developer
RQ08204 - Sr. Software Developer

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
RQ11579 - Software Developer - Junior
RQ11579 - Software Developer - Junior

Analyst Technical Solutions • Toronto

On-site
CAD 83,000 - 90,000
Senior Technology Architect – Oracle Database & Middleware
Senior Technology Architect – Oracle Database & Middleware

ThoughtStorm Inc. • Toronto

Hybrid
CAD 120,000 - 150,000
RQ11532 - Software Developer - Junior
RQ11532 - Software Developer - Junior

Source Code • Toronto

On-site
CAD 115,000 - 123,000
Database Administrator - Senior (SQL)
Database Administrator - Senior (SQL)

Bevertec • Toronto

On-site
CAD 110,208 - 117,096
RQ11508 - Software Developer - Senior I 1+ Year I Toronto ON
RQ11508 - Software Developer - Senior I 1+ Year I Toronto ON

Analyst Technical Solutions • Toronto

On-site
CAD 131,000 - 139,000
IT - Database Analyst V-Oracle
IT - Database Analyst V-Oracle

Skillhub Solutions Inc. • Toronto

Hybrid
CAD 85,000 - 95,000
Hybrid work