Senior Oracle Database Developer
- Toronto, ON, Canada
- Greater Toronto Area, Canada, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 5+ years of experience in design and development of Oracle (12c) development experience supporting OLAP and OLTP applications.
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
Design, develop, and optimize Oracle database components and data warehouse solutions for OLAP and OLTP applications, including complex PL/SQL and advanced SQL. Tune database performance, automate workflows, and collaborate with business analysts to translate requirements into scalable technical designs.
Requirements
Requires at least five years of Oracle 12c database development experience supporting OLAP and OLTP applications, with expert-level PL/SQL and dynamic SQL proficiency. Candidates should have experience in data warehouse design, database modeling, complex schema architecture, performance tuning, process automation, and stakeholder communication.
Skills
- Oracle Database Development
- PL/SQL
- SQL
- Stored Procedures
- Database Packages
- Functions
- Triggers
- Dynamic SQL
- Ref Cursors
- Data Warehouse Design
- Database Modeling
- Schema Architecture
- Performance Tuning
- Process Automation
- OLAP
- OLTP
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Oracle 12c
- Oracle Database
- PL/SQL
- SQL
- Stored Procedures
- Packages
- Functions
- Triggers
- Ref Cursors
- Dynamic SQL
- OLAP
- OLTP
- Data Warehouse
- Database Design
- Data Modeling
- Schema Architecture
- Performance Tuning
- Resource Optimization
- Workflow Automation
- Data Pipelines
- Business Analysis
- Functional Specifications
- Technical Design
- Application Design
- Database Development
- Data Engineering