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.