Senior Oracle PL/SQL Developer to Support Enterprise Applications for an insurance client

S I Systems; Edmonton, Calgary; Hybrid; CAD 110,000 - 150,000; Full time

Job summary

S I Systems in Canada is seeking a Senior Oracle PL/SQL Developer to support enterprise applications for an insurance client. This hybrid role is based in Edmonton or Calgary, offering collaboration across teams and exposure to large-scale data-handling projects.

The ideal candidate has 10+ years of PL/SQL experience, expertise in performance tuning, complex queries, and RESTful integration. You will design, build, test, and document changes while following the full SDLC and IT controls.

Qualifications

• Bachelor's degree or diploma in Computer Science or related technical discipline.
• 10+ years of experience developing/designing PL/SQL for large-scale applications.
• Proven ability to use SQL Developer, TOAD, GitLab.
• Strong consultation and communication skills for technical and non-technical audiences.

Responsibilities

• Collaborate with multiple teams across the organization.
• Communicate effectively with team, manager and business customers.
• Develop and maintain PL/SQL code and documentation.
• Understand, design, build and test change requests per project needs.
• Troubleshoot and resolve issues; assess root causes.
• Perform unit/integration testing with IT and business stakeholders.
• Follow IT Controls and SDLC best practices.
• Support deployment and code management activities as Senior SA.

Skills

PL/SQL development

SQL performance tuning

Advanced PL/SQL packaging

Unix shell scripting

RESTful API integration

SQL/PLSQL optimization

Communication skills

Education

Bachelor's degree or diploma in Computer Science

Tools

SQL Developer

TOAD

GitLab

Job description

Senior Oracle PL/SQL Developer to Support Enterprise Applications for an insurance client

Senior Oracle PL/SQL Developer to Support Enterprise Applications for an insurance client

**Hybrid in Edmonton or Calgary**

Must haves:

• A bachelor’s degree or diploma in Computer Science or related technical discipline.
• 10+ years of progressive experience developing and designing implementations with small to large scale applications with data manipulation components preferably using PL/SQL or similar languages.
• Established Proven ability to work using tools like SQL Developer, TOAD, GitLab
• Exceptional consultation skills are critical, with the ability to convey technical ideas to both technical and non-technical audiences.
• Demonstrated skills in performance Tuning and optimizing SQL, PL/SQL code to reduce execution time or improve efficiency
• Relevant experience in Implementation, Development projects related to Oracle PL/SQL based Enterprise Applications.
• Strong knowledge in complex queries and sub queries is a must
• Strong experience with Oracle functions, procedures, triggers, packages & performance tuning
• Knowledge in UNIX & Shell Scripting
• Familiarity with RESTful web services and API integration
• Experience following a full lifecycle SDLC process, including creating technical designs, build and unit testing for sophisticated requirements
• Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer

Nice to haves:

• Experience with Delivery management tools like ALM, Service Now and Jira is highly preferred
• Demonstrated technical leadership on projects/large initiatives in a highly complex and integrated application architecture would be highly beneficial.
• Completion of Oracle PL/SQL Developer Certified Associate would be considered an asset.
• Experience with services and integration with Mid-Tier applications highly desired
• Good understanding of Agile development methodology would be an asset
• Experience with developing Oracle Reports and tuning reports would be highly beneficial

Responsibilities:

• Work collaboratively with multiple teams across the organization.
• Communicate effectively with your team, team manager and business customers.
• Contribute and be accountable to your development activities and workload management.
• Produce and maintain program code (mostly PL/SQL) and documentation.
• Understand, design, build and test change requests as per demands of the projects and releases
• Troubleshoot and resolve issues
• Assess the root cause of issues and recommend changes.
• Perform unit and integration testing with both IT and business customers as required. Provide support during various phases of testing.
• Prepare documentation and instructions for the execution of application programs.
• Reviews requirements with the users and provides time estimates for task completion.
• Work as part of a project team as required.
• Follow IT Controls practices (e.g., IT Governance, Data Privacy) to ensure quality output.
• Follow Systems Development Life Cycle best practices.
• Continual learning and understanding of the application environment, interdependencies, and integrations with other systems.
• Could include data management activities such as designing and building data interfaces and extracts, forms, and reports, and designing logical and physical data models.
• As Senior SA, provide expertise with respect code quality, security, deployment and code management
• Display certainty in one’s ability to make decisions and perform difficult job tasks and self-assurance in all work relationships.
• You will participate in project estimation, provide inputs for solution delivery, conduct technical risk planning, perform code reviews and unit test plan reviews.

Senior Oracle PL/SQL Developer to Support Enterprise Applications for an insurance client

**Hybrid in Edmonton or Calgary**

Must haves:

• A bachelor’s degree or diploma in Computer Science or related technical discipline.
• 10+ years of progressive experience developing and designing implementations with small to large scale applications with data manipulation components preferably using PL/SQL or similar languages.
• Established Proven ability to work using tools like SQL Developer, TOAD, GitLab
• Exceptional consultation skills are critical, with the ability to convey technical ideas to both technical and non-technical audiences.
• Demonstrated skills in performance Tuning and optimizing SQL, PL/SQL code to reduce execution time or improve efficiency
• Relevant experience in Implementation, Development projects related to Oracle PL/SQL based Enterprise Applications.
• Strong knowledge in complex queries and sub queries is a must
• Strong experience with Oracle functions, procedures, triggers, packages & performance tuning
• Knowledge in UNIX & Shell Scripting
• Familiarity with RESTful web services and API integration
• Experience following a full lifecycle SDLC process, including creating technical designs, build and unit testing for sophisticated requirements
• Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer

Nice to haves:

• Experience with Delivery management tools like ALM, Service Now and Jira is highly preferred
• Demonstrated technical leadership on projects/large initiatives in a highly complex and integrated application architecture would be highly beneficial.
• Completion of Oracle PL/SQL Developer Certified Associate would be considered an asset.
• Experience with services and integration with Mid-Tier applications highly desired
• Good understanding of Agile development methodology would be an asset
• Experience with developing Oracle Reports and tuning reports would be highly beneficial

Responsibilities:

• Work collaboratively with multiple teams across the organization.
• Communicate effectively with your team, team manager and business customers.
• Contribute and be accountable to your development activities and workload management.
• Produce and maintain program code (mostly PL/SQL) and documentation.
• Understand, design, build and test change requests as per demands of the projects and releases
• Troubleshoot and resolve issues
• Assess the root cause of issues and recommend changes.
• Perform unit and integration testing with both IT and business customers as required. Provide support during various phases of testing.
• Prepare documentation and instructions for the execution of application programs.
• Reviews requirements with the users and provides time estimates for task completion.
• Work as part of a project team as required.
• Follow IT Controls practices (e.g., IT Governance, Data Privacy) to ensure quality output.
• Follow Systems Development Life Cycle best practices.
• Continual learning and understanding of the application environment, interdependencies, and integrations with other systems.
• Could include data management activities such as designing and building data interfaces and extracts, forms, and reports, and designing logical and physical data models.
• As Senior SA, provide expertise with respect code quality, security, deployment and code management
• Display certainty in one’s ability to make decisions and perform difficult job tasks and self-assurance in all work relationships.
• You will participate in project estimation, provide inputs for solution delivery, conduct technical risk planning, perform code reviews and unit test plan reviews.

Disclaimer:
AI may be used in evaluating candidates.
This posting is for an existing vacancy.