Job Title: Senior Oracle Database Developer/Data Engineer
Location: Toronto 5 days on site
Contract Rate: $90 - $100 / hour
Duration: 15 month contract
We are seeking an experienced Senior Oracle Database Developer to design, build, and optimize high-performance database solutions for complex OLAP and OLTP applications. In this hands-on role, you will work closely with business analysts to translate technical requirements into robust database architectures, ensuring peak performance and automation across our data pipelines.
Key Responsibilities
- Database Development & PL/SQL: Design and develop Oracle (12c+) database components for OLAP and OLTP environments, including complex PL/SQL, stored procedures, packages, functions, triggers, ref cursors, and dynamic SQL.
- Data Architecture & Design: Write advanced, highly optimized SQL queries and lead database design, modeling, and data warehouse development.
- Performance Tuning & Automation: Drive database performance tuning, resource optimization, and workflow automation.
- Requirements Translation: Collaborate directly with Business Analysts to translate functional specifications and business needs into scalable technical and application designs.
What We’re Looking For
- 5+ years of experience in design and development of Oracle (12c) development experience supporting OLAP and OLTP applications.
- Expert-level proficiency in PL/SQL, stored procedures, packages, functions, and dynamic SQL.
- Proven background in Data Warehouse design, database modeling, and complex schema architecture.
- Strong track record of database performance tuning and process automation.
- Excellent communication skills with a history of partnering with Business Analysts and IT stakeholders.
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.
