19 Nov
|
S.I. Systems
|
Edmonton
19 Nov
S.I. Systems
Edmonton
Senior Oracle PL/SQL Developer to Support Enterprise Applications for an insurance clientSenior 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, GitLabExceptional 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 efficiencyRelevant experience in Implementation, Development projects related to Oracle PL/SQL based Enterprise Applications.Strong knowledge in complex queries and sub queries is a mustStrong experience with Oracle functions, procedures, triggers, packages & performance tuningKnowledge in UNIX & Shell ScriptingFamiliarity with RESTful web services and API integrationExperience following a full lifecycle SDLC process, including creating technical designs, build and unit testing for sophisticated requirementsDeveloped Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developerNice to haves:Experience with Delivery management tools like ALM, Service Now and Jira is highly preferredDemonstrated 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 desiredGood understanding of Agile development methodology would be an assetExperience with developing Oracle Reports and tuning reports would be highly beneficialResponsibilities: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 releasesTroubleshoot and resolve issuesAssess 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 managementDisplay 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, GitLabExceptional 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 efficiencyRelevant experience in Implementation, Development projects related to Oracle PL/SQL based Enterprise Applications.Robust knowledge in complex queries and sub queries is a mustStrong experience with Oracle functions, procedures, triggers, packages & performance tuningKnowledge in UNIX & Shell ScriptingFamiliarity with RESTful web services and API integrationExperience following a full lifecycle SDLC process,
including creating technical designs, build and unit testing for sophisticated requirementsDeveloped Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developerNice to haves:Experience with Delivery management tools like ALM, Service Now and Jira is highly preferredDemonstrated 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 desiredGood understanding of Agile development methodology would be an assetExperience with developing Oracle Reports and tuning reports would be highly beneficialResponsibilities: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 releasesTroubleshoot and resolve issuesAssess 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 managementDisplay 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.
📌 Senior Oracle Pl/Sql Developer To Support Enterprise Applications For An Insurance Client (Edmonton)
🏢 S.I. Systems
📍 Edmonton