PL/SQL & API Developer

CMiC • Toronto, ON

14h • Onsite

About The Position

We are seeking a Back-End Developer with deep expertise in Oracle PL/SQL and experience in Java-based REST API development. This role will focus primarily on database development with additional responsibilities in API development and integration. Strong analytical thinking and problem-solving skills are essential to succeed in this role. The overall hiring salary range for this position from Intermediate to Senior level, is $70,000 to $115,000 annually. This position is for an existing vacancy. We do not use AI to screen, assess, or select applicants.

Requirements

• 3–7+ years in backend development
• Significant hands-on experience with Oracle database development
• Proven experience developing and maintaining PL/SQL code in enterprise environments
• Experience building and consuming REST APIs in Java
• Exposure to system integration across multiple applications
• Experience in performance tuning and troubleshooting production issues
• Working in Agile/Scrum environments
• Detail-oriented, especially with data accuracy and integrity
• Ownership mindset with accountability for deliverables
• Continuous learning (especially evolving database and API technologies)
• Proactive in identifying issues and proposing improvements
• Collaborative team player with good communication skills
• Adaptable to changing priorities and requirements
• Quality-focused with emphasis on maintainability and scalability
• Logical reasoning and structured thinking
• Strong attention to detail (critical for database work)
• Ability to work with abstract data models and complex logic
• Capability to manage both deep backend processing and API layers

Nice To Haves

• Spring / Spring Boot framework
• IntelliJ experience
• Oracle JDeveloper experience
• CI/CD pipelines (Jenkins, GitHub Actions)
• Database design principles and data architecture
• Transaction management and concurrency control
• API lifecycle management and versioning strategies
• Software development lifecycle (SDLC)
• Secure coding practices
• Data integrity and validation techniques
• Version control systems (Git)

Responsibilities

• Advanced PL/SQL development (packages, procedures, functions, triggers)
• Strong SQL skills (complex joins, subqueries, performance tuning)
• Query optimization and execution plan analysis
• Data modeling (normalized/denormalized schemas)
• Bulk processing and efficient data handling techniques
• Use of Oracle development tools (PL-SQL Developer, TOAD, SQLPlus)
• Error handling, exception management, and logging
• Working with large datasets and high-volume transactional systems
• Object oriented programming
• Java programming
• RESTful API design and implementation
• Java backend development (Java 8+ preferred)
• Spring / Spring Boot framework
• API documentation (Swagger/OpenAPI)
• JSON/XML data handling
• Secure API development (OAuth2, JWT, basic authentication)
• Strong problem-solving and root-cause analysis abilities
• Ability to analyze complex data flows and system dependencies
• Debugging and troubleshooting complex database and API issues
• Translating business requirements into efficient technical solutions
• Identifying performance bottlenecks and optimizing solutions
• Data-driven decision-making mindset

Benefits

• Competitive benefits Package (including Health & Dental benefits)
• Paid vacation and personal days
• RRSP Matching Program after 2 years of employment

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed