Java Expert (SQL/PLSQL)

Job description

Position Description

We are Canada’s largest independent information technology services firm, and after 50 years, we’re still growing! We have a challenging career opportunity for a Sr. SQL PLSQL Developer to work for our clients across our Banking and Wealth 360 Digital Wealth.

This role is hybrid and requires you to be at our downtown Toronto office at a minimum 2 days per week – subject to change at any time.

Future Duties and Responsibilities

• Database Development: Develop, optimize, and maintain Oracle SQL and PL/SQL code, including stored procedures, functions, and packages.
  
  Translate business needs into long‑term data architecture solutions.
  
  
• Performance Tuning: Identify and resolve performance bottlenecks, optimize query performance, and implement best practices for database tuning.
  
  
• Complex Problem Solving: Analyze, troubleshoot, and resolve complex database issues, ensuring minimal downtime and optimal performance.
  
  
• Data Modeling: Design and refactor data models to support business requirements and improve system efficiency.
  
  
• Documentation: Create and maintain detailed documentation for database structures, processes, and best practices.
  
  Analyze and document existing PL/SQL code.
  
  
• Mentorship: Guide and mentor junior developers, providing technical leadership and support in analyzing complex problems and refactoring data models.
  
  
• Collaboration: Work closely with cross‑functional teams, including developers, analysts, and project managers, to ensure seamless integration and efficient operation of database systems.
  
  
• Optimization: Evaluate reusability of current data for separate analyses.
  
  Conduct data sheering to rid the system of old, unused, or duplicate data.
  
  Review object and data models and the metadata repository to structure the data for better management and quicker access.
  
  
• Solid experience in Java technologies: Java 8+, Spring framework/Spring Boot/Spring Integration, Tomcat and Security (SAML or SSO preferred), Microservices, Restful services.
  
  
• Excellent understanding of key architecture concepts in a distributed environment (SOA, Microservices, RESTful Services, etc.).
  
  
• Experience with development life cycle including: source control (Git, Subversion, etc.), build automation tools (Maven, Gradle, etc.), development of unit tests (JUnit, TDD, etc.), and CI/CD pipeline (Jenkins/Bamboo, etc.).
  
  

Required Qualifications To Be Successful In This Role

• Bachelor of Science in Computer Science or similar discipline.
  
  
• Strong data analysis skills.
  
  
• 10+ years’ experience in Oracle 12c/19c.
  
  
• 10+ years’ experience with Oracle database, SQL and PL/SQL programming & Java programming.
  
  
• Expert in SQL performance tuning.
  
  
• Knowledge of XML, XSLT, XML Schema, YAML and JSON.
  
  
• Exposure to various technologies such as web‑based, mobile, tablet, desktop, and batch.
  
  
• Proficient in managing the development of multi‑tier, secure business applications for high availability, scalability, and performance.
  
  
• Ability to rapidly develop expertise in emerging technologies through hands‑on, real‑time – on‑the‑fly exposure and involvement.
  
  
• Excellent technical problem‑solving abilities with successful implementation of solutions.
  
  
• Expert in data migration techniques.
  
  
• Strong data modelling skills, including designing and refactoring data models.
  
  
• Experience in rewriting and optimizing complex stored procedures.
  
  
• Strong analytical and problem‑solving skills, with the ability to handle complex database issues.
  
  
• Strong troubleshooting skills.
  
  
• Excellent verbal and written communication skills.
  
  
• Ability to work in a fast‑paced environment.
  
  
• High attention to detail and a commitment to delivering high‑quality work.
  
  

Other Requirements

• Knowledgeable in the Wealth Management domain, with experience in Wealth 360 Digital Wealth Platform preferred.
  
  
• Knowledge of Postgres – 3 to 4 years of experience preferred.
  
  
• Demonstrated ability to learn new technologies, applications, and systems.
  
  
• Strong organizational and leadership skills with the ability to facilitate technical sessions.
  
  
• Can communicate in both technical and business terms.
  
  
• Ability to lead multiple projects simultaneously.
  
  
• Ability to manage geographically distributed development teams.
  
  
• Knowledge of Oracle Performance Tuning is an asset.
  
  
• Working experience in Toad / SQL Developer / Oracle DataModeler / Erwin.
  
  
• Exposure to containers like Liquibase.
  
  
• Ability to extract matrix/progress/milestones from JIRA or other collaboration tools for stakeholders.
  
  
• Familiarity with Oracle development tools and performance tuning utilities.
  
  
• Oracle Certified Professional (OCP) or equivalent certifications is an asset.
  
  

CGI is providing a reasonable estimate of the pay range for this role.

The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications.

Compensation decisions depend on the facts and circumstances of each case.

A reasonable estimate of the current range is $95,000–$145,000.

This role is an existing vacancy.

Equal Opportunity Employer

As an equal‑opportunity employer, you are invited to apply whether you are of any race, colour, religion, gender, gender identity, sexual orientation, or any other characteristic.

If you require an accommodation, please inform your recruiter.

To learn more about accessibility at CGI, contact us via email.

Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Required Skill Profession

It & Technology