Senior Oracle PL/SQL Developer – Healthcare Data & Integration

ThoughtStorm

Toronto

On-site

CAD 90,000 - 130,000

Full time

5 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

ThoughtStorm seeks a Senior Oracle PL/SQL Developer to lead Oracle database development on long-term projects. You will design and optimize complex SQL, PL/SQL code, and data models for mission-critical applications.

You will work with Informatica for ETL, Cognos reporting tools, and modern DevOps practices, including CI/CD, while aligning with healthcare IT standards such as HL7/FHIR. Strong SDLC and Agile experience is required.

Qualifications

  • 10+ years of Oracle database development experience.
  • Expertise in Oracle 12c, PL/SQL, and related objects.
  • Advanced SQL, query optimization, and data modeling skills.
  • Data Warehouse design, development, and performance tuning.
  • Informatica ETL experience required.
  • Cognos Reporting suite proficiency requested.
  • Unix/Linux shell scripting and familiarity with Java, JSON, XML.
  • REST APIs and Web Services experience; HL7/FHIR is a plus.
  • Strong SDLC, Agile, and DevOps familiarity.

Responsibilities

  • Translate business requirements into technical designs for complex systems.
  • Develop and optimize Oracle PL/SQL code, procedures, and data models.
  • Collaborate on ETL design with Informatica and BI reporting with Cognos.

Skills

Oracle PL/SQL
Oracle 12c
Stored Procedures
Packages & Functions
Triggers
Dynamic SQL
Advanced SQL
Query Optimization
Database Design
Data Modeling
OLTP/OLAP
Data Warehouse
Performance Tuning
Automation

Tools

Informatica ETL
Cognos Reporting
Framework Manager
Query Studio
Reports Studio
Unix/Linux
Java
JSON
XML
REST APIs
Web Services

Job description

We are hiring a Senior Oracle PL/SQL Developer for a long-term opportunity.

  • 10+ years of experience in Oracle database development, particularly Oracle 12c, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Ref Cursors and Dynamic SQL.
  • Strong expertise in Advanced SQL, Query Optimization, Database Design, Data Modeling, and OLTP/OLAP applications.
  • Hands-on experience in Data Warehouse Design & Development, Database Performance Tuning, and Automation.
  • Strong experience with Informatica ETL, data extraction, transformation, and loading.
  • Experience with Cognos Reporting, Framework Manager, Query Studio, and Reports Studio.
  • Knowledge of Unix/Linux Shell Scripting, Java, JSON, XML, REST APIs, and Web Services.
  • Experience in Healthcare IT, Clinical Systems Integration, HL7/FHIR, and Provincial Immunization Systems is highly desirable.
  • Strong understanding of SDLC, Agile methodologies, DevOps, Continuous Integration, and technical documentation.
  • Ability to translate business requirements into technical designs and deliver solutions for complex, mission-critical applications.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Oracle PL/SQL Developer
Senior Oracle PL/SQL Developer

Russell Tobin • Toronto

On-site
CAD 110,000 - 117,000
Sr. Oracle PL/SQL Application Developer
Sr. Oracle PL/SQL Application Developer

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 80,000 - 100,000
Senior Oracle Database Developer
Senior Oracle Database Developer

Bevertec • Toronto

On-site
CAD 124,000 - 138,000
Software Developer - Senior (Oracle/OLAP and OLTP)
Software Developer - Senior (Oracle/OLAP and OLTP)

Bevertec • Toronto

On-site
CAD 117,000 - 124,000
PL/SQL Developer
PL/SQL Developer

Acute Talent • Montreal

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

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
Senior Oracle Application Database Administrator
Senior Oracle Application Database Administrator

Epsilon Solutions Ltd. • Toronto

On-site
CAD 120,000 - 160,000
Senior Oracle PL/SQL Developer to Support Enterprise Applications for an insurance client
Senior Oracle PL/SQL Developer to Support Enterprise Applications for an insurance client

S.I. Systems Ltd. • Edmonton, Calgary

Hybrid
CAD 110,000 - 150,000
Senior Database Administrator (Oracle Application DBA / Cloud)
Senior Database Administrator (Oracle Application DBA / Cloud)

Astra-North Infoteck Inc. • Toronto

On-site
CAD 110,000 - 160,000
Senior Database Administrator (Oracle Application DBA / Cloud)
Senior Database Administrator (Oracle Application DBA / Cloud)

Astra-North Infoteck Inc. • Toronto

On-site
CAD 120,000 - 180,000