PL​/SQL & API Developer

Job Overview
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.

Important Information

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

Duties & Responsibilities
Oracle / PL-SQL

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

API Development

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)

Nice to Have

IntelliJ experience

Oracle JDeveloper experience

CI/CD pipelines (Jenkins, Git Hub 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)

Qualifications

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

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

CMiC is an Equal Opportunity Employer. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, CMiC will provide accommodation to applicants with disabilities throughout the recruitment, selection and/or assessment process. If selected to participate in the recruitment, selection and/or assessment process, please inform Human Resources staff of the nature of any accommodation(s) that you may require.

#J-18808-Ljbffr