Oracle pl sql developer Jobs in North York, ON

We are seeking a highly accomplished Senior RACS Developer for an enterprise-level contract opportunity based in Toronto. In this role, you will take on a premier engineering capacity within the application development, integration, and data migration streams, specializing in the enhancement, modernization, and maintenance of mission-critical permit and operational management systems.

As a principal developer, you will bridge the gap between complex legacy application code bases and modern enterprise integration layers. Operating within a collaborative project environment, you will lead the implementation of software updates, design secure API endpoints, build complex database objects, and manage end-to-end data migration tasks to support platform integration with enterprise asset management systems. This position demands a seasoned technical authority who can independently modify shared components, enforce strict data quality rules, and deliver seamless system integration without disrupting daily operations.

Location: Toronto, ON

Contract Duration: 6 months (with a 6-month optional extension)

Advantages
Modernization & Integration Leadership: Replace legacy database links with secure, service-based REST/JSON APIs and modern integration patterns.

Full-Lifecycle Engineering Scope: Own application development end-to-end—from initial requirements analysis to code build, data migration, and deployment.

High-Impact Domain Relevance: Directly shape software frameworks supporting essential municipal permit workflows, data models, and enterprise platform integrations.

Complex Legacy & Cloud Modernization: Apply advanced PowerBuilder, Oracle PL/SQL, and ETL expertise in a highly integrated enterprise setting.

Responsibilities
Analyze approved business requirements, change requests, and interface workbooks to determine technical impacts, assumptions, dependencies, and effort estimates.

Design, build, unit test, and document application, database, batch, workflow, status, and reporting updates using PowerBuilder and Oracle PL/SQL.

Develop, expose, and maintain secure REST/JSON APIs, web services, and database views to facilitate real-time and scheduled data exchanges with enterprise integration platforms.

Implement authentication, authorization, logging, input validation, correlation identifiers, retry controls, and operational monitoring in compliance with security standards.

Profile, extract, cleanse, transform, and reconcile legacy permit, client, and status records to support data migration into target enterprise systems.

Develop repeatable ETL scripts, manage mock conversions, execute delta loads, and produce reconciliation control totals to ensure complete source-to-target data integrity.

Prepare unit and technical test cases covering positive, negative, boundary, volume, and error-recovery scenarios; support SIT, UAT, and end-to-end integration testing.

Investigate software defects, perform root-cause analysis, apply code fixes, and participate in peer code reviews and release planning sessions.

Author technical artifacts, including interface specifications, data mappings, deployment checklists, rollback procedures, and operational runbooks.

Provide active support during deployment cutovers, go-live verification, hypercare stabilization, and deliver comprehensive knowledge transfer to sustainment teams.

Qualifications
Core Technical & Software Engineering Requirements
Education: Post-secondary degree or diploma in Computer Science, Information Technology, Software Engineering, Data Management, or a related quantitative discipline (or equivalent professional experience).

Senior Engineering Tenure: Minimum of ten (10) years of progressive, hands-on experience developing, enhancing, and sustaining large-scale, business-critical, and heavily integrated IT solutions.

Domain & Application Expertise: Demonstrated working knowledge of the RACS application environment—including its business processes, data model, PowerBuilder components, Oracle database objects, batch jobs, and permit/status lifecycles—to contribute effectively with minimal onboarding.

PowerBuilder Mastery: Extensive hands-on experience leading the design, modification, enhancement, and sustainment of enterprise applications utilizing PowerBuilder 2019 or higher.

Database & PL/SQL Depth: Extensive experience using SQL and Oracle PL/SQL coding techniques on Oracle Database 19c or higher to develop complex queries, views, stored procedures, functions, packages, triggers, and controlled data-correction scripts.

API & Web Services Engineering: Direct experience designing, building, and supporting secure system integrations, RESTful web services, and JSON/XML payloads, including field mapping, error handling, retries, and idempotency controls.

ETL & Data Migration Experience: Extensive experience designing and executing ETL processes for data extraction, profiling, cleansing, transformation, loading, exception handling, and data reconciliation.

Full SDLC Proficiency: Proven background across all stages of the software development lifecycle, from requirements elicitation through architecture, design, testing, deployment, and operational sustainment.

Preferred Attributes & Soft Skills
Public Sector Context: Proven experience delivering enterprise software solutions within a municipal or public-sector environment under formal change-management, security, and accessibility frameworks.

Analytical Problem Solving: Superior diagnostic and troubleshooting capabilities to resolve complex application bugs, performance bottlenecks, and database constraints.

Collaborative Communication: Excellent verbal and written communication skills to collaborate effectively with project managers, solution architects, database administrators, QA leads, and sustainment teams.

Summary
If you're interested in the "Senior RACS Developer" role based in Toronto, we encourage you to apply online at www.randstad.ca.
Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.