PL/SQL & API Developer

CMiCToronto, ON
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
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service