PL/SQL Developer

About CMiC

Job Overview

Important Information

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)

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