Senior Oracle PL/SQL Developer – Healthcare Data & Integration
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 10+ years of experience in Oracle database development, particularly Oracle 12c, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Ref Cursors and Dynamic SQL.
- Posting language
- English
- Posted
Original 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.
Contract: December 2026 – March 2028
More about this job
Responsibilities
Develop and maintain Oracle database solutions, including PL/SQL components, data warehouse systems, and ETL processes. Translate business requirements into technical designs and deliver reliable solutions for complex, mission-critical healthcare applications.
Requirements
Requires 10+ years of Oracle database development experience, with strong skills in Oracle 12c, PL/SQL, advanced SQL, database design, performance tuning, and Informatica ETL. Healthcare IT, clinical systems integration, HL7/FHIR, Cognos, scripting, APIs, Agile, and DevOps experience are also relevant; healthcare integration experience is highly desirable.
Skills
- Oracle 12c
- PL/SQL
- Stored Procedures
- Advanced SQL
- Query Optimization
- Database Design
- Data Modeling
- Data Warehouse Design
- Database Performance Tuning
- Informatica ETL
- Cognos Reporting
- Unix/Linux Shell Scripting
- Healthcare IT
- HL7/FHIR
- Agile
- DevOps
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Healthcare
Keywords
- Oracle 12c
- PL/SQL
- Stored Procedures
- Packages
- Functions
- Triggers
- Ref Cursors
- Dynamic SQL
- Advanced SQL
- Query Optimization
- Database Design
- Data Modeling
- OLTP
- OLAP
- Data Warehousing
- Performance Tuning
- Automation
- Informatica ETL
- Cognos
- Unix/Linux Shell Scripting
- Java
- JSON
- XML
- REST APIs
- Web Services
- Healthcare IT
- Clinical Systems Integration
- HL7/FHIR
- Agile
- DevOps