Oracle pl sql developer Jobs in Mississauga, ON

Job Summary

The City of Mississauga is seeking a passionate, energetic, and talented Developer to join our team. In this role, you will collaborate with the development team to ensure IT applications meet client needs by delivering new or enhanced functionality and providing ongoing maintenance and support.
As part of our team, you will develop solutions that have a meaningful impact on the lives of Mississauga residents.The role operates in a hybrid work environment, with office presence required at Mississauga City Hall, 300 City Centre Drive, Mississauga.

Duties and Responsibilities

The Successful Candidate will:

• Support, enhance, and maintain existing Oracle Forms and Reports applications used in enterprise and municipal business processes.
• Support and maintain Oracle Forms and Reports applications, and develop PL/SQL packages, procedures, and functions to implement business logic and transaction processing for enterprise and municipal systems.
• Design, develop, test, and support TypeScript-based web applications that provide a modern user interface for enterprise business systems.
• Participate in the design and implementation of API-first and microservices-based architectures, ensuring clean separation between frontend, service, and data layers.
• Develop and maintain TypeScript-based frontend applications (React or Angular) and backend APIs to support form-based user interfaces, data processing, workflows, and reporting functions
• Deploy and support applications using containerized environments on AWS ECS Fargate, ensuring scalability, availability, and performance.
• Troubleshoot and resolve application issues across frontend, API, and infrastructure layers in a cloud-hosted environment.
• Design, develop and implement clean, simple, testable and scalable applications.
• Utilize established development tools, guidelines and conventions yet keeping an open mind for possible improvements.
• Revise, refactor and update codes periodically and proactively.
• Keep up with appropriate technical documentation.
• Comply with relevant City policies.

Skills and Qualifications

• Bachelor’s degree in computer science, engineering or a related field.
• 5+ years of experience in development with Oracle Forms & Reports, PL/SQL, APEX, .NET, and C# development with expert level knowledge of language and developing environments.
• Experience with Oracle Middleware, Oracle Database, Microsoft SQL Server and MySQL, designing and optimizing complex queries.
• Hands-on experience with relational database objects such as tables, stored procedures, triggers, and DTS/SSIS packages
• Fluency with source control, branching strategies and release management (Git).
• Strong hands-on experience developing TypeScript-based web applications.
• Experience with modern frontend frameworks such as React or Angular.
• Experience designing and consuming RESTful APIs using TypeScript.
• Understanding of microservices and service-oriented architectures.
• Experience deploying or supporting applications in containerized environments (e.g., AWS ECS Fargate or equivalent).
• Familiarity with cloud-native application patterns, scalability, and high availability.
• Experience working with relational databases (e.g., PostgreSQL or Oracle) from application services.

Additional Assets

• Oracle Developer certification (e.g., Oracle Forms, Reports, PL/SQL, or Oracle Database) is considered an asset.
• TypeScript and frontend framework certification (e.g., React or Angular) is considered an asset.
• AWS certification related to application development or containerized environments (e.g., ECS, cloud-native development) is considered an asset.
• Experience working in municipal or public-sector IT environments.
• Strong documentation