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

S.I. Systems Ltd.

Edmonton, Calgary

Hybrid

CAD 110,000 - 150,000

Full time

14 days+

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Systems Analyst (PL/SQL)
Systems Analyst (PL/SQL)

10 Percent Recruiting Ltd. • Edmonton

Hybrid
CAD 100,000 - 140,000
Senior Systems Analyst
Senior Systems Analyst

Aplin • Edmonton

Hybrid
CAD 96,000 - 138,000
Senior Systems Analyst
Senior Systems Analyst

Vantix Systems Inc. • Edmonton

Hybrid
CAD 120,000 - 150,000
Senior Business Analyst support multiple project initiatives for an insurance client
Senior Business Analyst support multiple project initiatives for an insurance client

S I Systems • Edmonton, Calgary

Hybrid
CAD 85,000 - 120,000
Software Developer - Senior (Oracle/OLAP and OLTP)
Software Developer - Senior (Oracle/OLAP and OLTP)

Bevertec • Toronto

On-site
CAD 117,000 - 124,000
RQ09096 - Software Developer - ETL - Senior
RQ09096 - Software Developer - ETL - Senior

Rubicon Path • Toronto

Hybrid
CAD 85,000 - 110,000
RQ11579 - Software Developer - Junior
RQ11579 - Software Developer - Junior

Analyst Technical Solutions • Toronto

On-site
CAD 83,000 - 90,000
Intermediate Oracle Pl/ Sql Consultant
Intermediate Oracle Pl/ Sql Consultant

S.I. Systems • London

Hybrid
GBP 83,000 - 124,000
Senior Oracle Database Developer
Senior Oracle Database Developer

Bevertec • Toronto

On-site
CAD 124,000 - 138,000
RQ08204 - Sr. Software Developer
RQ08204 - Sr. Software Developer

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000