PL/SQL, API Developer

Posted last week

Apply Now

Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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.

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, 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

  • **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

Job type

Full Time

Experience level

Mid levelSenior

Salary

CA$70,000 - CA$115,000 per year

Degree requirement

Bachelor's Degree

Tech skills

JavaOracleSpringSpring BootSpringBootSQL

Location requirements

HybridTorontoCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.