Lead Oracle database development in Toronto with PL/SQL expertise and advanced performance tuning across fully onsite enterprise systems.
This Senior Software Developer designs, develops, and sustains mission-critical OLAP and OLTP solutions. You will translate functional specifications with business analysts, build data warehouse pipelines, and support integrated application extensions. The work spans healthcare and clinical ecosystems.
Key Responsibilities
Design Oracle 12c+ OLAP and OLTP database solutions
Develop PL/SQL procedures, packages, functions, triggers, and energetic SQL
Optimize queries, schemas, automation scripts, and database performance
Build Informatica ETL workflows and warehouse structures
Provide Tier-3 support, troubleshooting, and incident resolution
Requirements
10+ years developing Oracle 12c+ and PL/SQL solutions
10+ years in advanced SQL and data architecture
Experience with data warehousing and performance tuning
Experience translating requirements into application and database designs
Informatica, Unix/Linux scripting, and Cognos experience
Apply senior Oracle development, PL/SQL, data warehousing, and performance tuning expertise to Toronto healthcare systems.