PL/SQL&APIDeveloper

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