Key skills
JavaOracleSpringSpring BootSpringBootSQLGoJWTSwaggerOpenAPIRESTfulAgileScrumCommunication
About this role
Role Overview
- 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
Tech Stack
- Java
- Oracle
- Spring
- Spring Boot
- SpringBoot
- SQL
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