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.