Oracle PL​/SQL Developer

Required Skills & Experience

• 3-5 years of experience developing in Oracle PL/SQL
• Strong understanding of Java frameworks
• UAT Testing experience
• Bash scripting knowledge

• Apex
• Pension/Financial knoweldge

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

• 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 Dev Ops 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.

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