Job OverviewWe 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 & ResponsibilitiesOracle / 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 focus including virtual yoga classes and wellness webinars
- RRSP Matching Program after 2 years of employment
- Experience in a rapidly growing, socially responsible corporation
