Who Can Apply
- Candidates must be legally authorized to work in Canada
Job Description
The Software Developer is responsible for designing, developing, testing, and maintaining back-end Oracle PL/SQL software applications, primarily focusing on creating robust and scalable solutions. This role involves taking on larger, more complex development tasks while contributing to the architecture and coding of software projects. The Software Developer will work closely with product management, senior developers, and cross-functional teams, participating in the complete Software Development Life Cycle (SDLC). They must apply the best coding, testing, and software maintenance practices to meet project timelines and deliver quality results. This team is robust and extremely process oriented to where they have defined tasks for this developer, and need them to be the go-to person when it comes to the PL/SQL environment
Duties and Responsibilities:
• Lead the design, architecture, and development of Java and PL/SQL-based applications that align with business and system requirements.
• Implement and optimize business logic using PL/SQL packages, procedures, and triggers alongside Pension’s proprietary tools.
• Translate functional requirements into robust, scalable technical designs and specifications.
• Drive performance optimization, scalability, and data integrity across the application stack.
• Conduct detailed code reviews, troubleshoot complex issues, and provide technical guidance to developers.
• Perform unit testing and ensure all deliverables meet quality and security standards.
• Collaborate closely with project teams to define scope, timelines, and deliverables.
• Mentor and coach team members to promote best practices and technical excellence.
• Champion the adoption of new technologies, automation, and DevOps practices to enhance productivity.
• Establish and maintain application security, data protection, and coding standards.
• Document software architecture, processes, and solutions to support maintainability and knowledge sharing.
• Contribute to client implementation projects, providing technical leadership and consulting expertise.
Knowledge, Skills, and Abilities:
• Understanding of pension plan concepts is a strong asset.
• Advanced experience with Oracle SQL and PL/SQL and Java.
• Strong understanding of relational database design, performance tuning, and optimization.
• Experience with Oracle APEX, Git, Oracle Cloud Infrastructure (OCI), and UNIX Bash scripting.
• Experience with database, data conversion, reporting tools, and API integration and application design.
• Proven ability to lead development teams and mentor junior staff.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Highly motivated, collaborative, and quality-focused.
• Prior experience in the pension or financial services industry is an asset.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
-3-5 years of experience developing in Oracle PL/SQL specifically
-Strong understanding of Java framework
Nice to Have Skills & Experience
Apex
Pension/Financial knoweldge
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.