PL/SQL, API Developer

CMiC

Back-End Developer role at CMiC focusing on Oracle PL/SQL database and Java-based REST APIs. Contributing to the development of a platform for the construction industry.

Posted 5/13/2026full-timeToronto • 🇨🇦 CanadaMid-LevelSenior💰 CA$70,000 - CA$115,000 per yearWebsite

Tech Stack

Tools & technologies

JavaOracleSpringSpring BootSpringBootSQL

About the role

Key responsibilities & impact

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, SQL*Plus)
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 (Nice to have)
API documentation (Swagger/OpenAPI)
JSON/XML data handling
Secure API development (OAuth2, JWT, basic authentication)

Requirements

What you’ll need

**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
__**Analytical Skills**__
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
__**Attitudes and Aptitudes**__
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

Benefits

Comp & perks

Competitive benefits Package (including Health & Dental benefits)
Paid vacation and personal days
Townhall meetings where all employees are encouraged to participate in open discussions
Located on York University’s campus, easily accessible by transit (TTC, GO, etc.), walking distance to shopping and restaurants
Outdoor lunch space, including picnic tables
An active Social Events Committee (past events include annual seasonal parties, pool and bowling tournaments, karaoke nights, Game nights, BBQ’s, and more)
Health and Wellness focus including virtual yoga classes and wellness webinars
RRSP Matching Program after 2 years of employment
Experience in a rapidly growing, socially responsible corporation

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PL/SQL developmentSQLquery optimizationdata modelingbulk processingJava programmingRESTful API designSpring frameworkJSON handlingsecure API development

Soft Skills

analytical skillsproblem-solvingattention to detailownership mindsetcontinuous learningcollaborativeadaptabilityquality-focusedlogical reasoningdata-driven decision-making