- Location
- Toronto, Ontario, Canada · published
- Type
- Full-time
- Department
- IT
- Source
- Workable
Description
About CMiC
Headquartered in Toronto, CMiC is a software company focused on the Construction industry. We have built a comprehensive platform for construction companies to manage their most important workflows. Our customers have their choice of a SaaS or Private Hosted platform that includes industry focused modules to manage everything from Financials and Payroll to Project Management and Budgeting. Our market share is very strong in North America and rapidly expanding internationally in regions like Europe, Southeast Asia and the Middle East.
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, 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)