Location: (Fully Remote)

Job Type: Full-Time Experience: 10+ Years

Work Authorization: Must be authorized to work in Canada. 8+ years of experience in Java application development.

8+ years of hands-on Oracle PL/SQL development experience.

Strong expertise in developing, debugging, and optimizing complex Oracle Stored Procedures, Packages, Functions, Triggers, and Views.

Extensive experience writing high-performance SQL queries and tuning PL/SQL code for large-scale enterprise applications.

Proven experience analyzing execution plans, query optimization, indexing strategies, and performance tuning.

Robust knowledge of transaction management, exception handling, cursors, collections, Bulk Collect, FORALL, and dynamic SQL.

Hands-on experience with Java 8/11/17, Spring Boot, Spring MVC, Spring Data JPA, and REST APIs.

Experience working with Oracle 12c/19c databases in production environments.

Experience with Git, Maven/Gradle, Jenkins, and CI/CD pipelines.





Strong understanding of Agile/Scrum methodologies.

Excellent communication and leadership skills with experience mentoring developers.

Key Responsibilities

Design, develop, and maintain complex Oracle PL/SQL stored procedures, packages, functions, and triggers for mission-critical applications.

Optimize existing stored procedures to improve performance and scalability.

Perform SQL and PL/SQL performance tuning using execution plans, indexing, and query optimization techniques.

Collaborate with Java developers to integrate PL/SQL components with enterprise Java applications.

Troubleshoot production database issues and perform root cause analysis.

Conduct code reviews focusing on Java and PL/SQL best practices.

Lead technical design discussions and provide guidance on database architecture and performance optimization.

📌 Java/PLSql Lead (Canada)
🏢 Carbonsoft
📍 Canada