Senior Systems Analyst

Aplin

Edmonton

Hybrid

CAD 96,000 - 138,000

Full time

28 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Aplin is seeking a Senior Systems Analyst (Oracle) on a contract, hybrid role based in Edmonton or Calgary AB. You will design, develop, and support Oracle-based enterprise applications, with a strong focus on SQL/PL/SQL, Forms, and Reports, including integrations and full SDLC delivery.

The ideal candidate will have 10+ years of enterprise development experience, advanced PL/SQL skills, and hands-on Oracle Forms/Reports experience, plus a background in Agile/hybrid delivery environments.

Qualifications

  • 10+ years of progressive enterprise application development experience with substantial hands-on Oracle PL/SQL.
  • Advanced PL/SQL skills including packages, procedures, functions, triggers, cursors, and collections.
  • Strong Oracle Forms and Oracle Reports development and support experience.

Responsibilities

  • Analyze complex business and technical requirements and translate them into maintainable Oracle-based solutions.
  • Design, develop, enhance, and support enterprise applications using Oracle SQL and PL/SQL.
  • Build and maintain packages, procedures, functions, triggers, cursors, interfaces, and data processing solutions.
  • Write, optimize, and tune complex SQL for high-volume data environments.

Skills

Oracle PL/SQL
Oracle Forms
Oracle Reports
SQL
RESTful APIs
Git/GitLab
Unix/Linux
Shell scripting

Education

Bachelor's degree in Computer Science

Tools

Oracle SQL Developer
TOAD

Job description

Senior Systems Analyst (Oracle) – Contract (Hybrid, Edmonton or Calgary AB)


Our client, Alberta Blue Cross, is seeking a Senior Systems Analyst to design, develop, enhance, and support enterprise applications built on Oracle technologies. This role is hands-on and senior-level, with a strong focus on Oracle SQL/PL/SQL, Oracle Forms, and Oracle Reports, as well as integrations and full SDLC delivery.


Location


  • Hybrid in Edmonton or Calgary, Alberta (Canada)

  • Contract, full-time hours (40 hours/week)


What you’ll do


  • Analyze complex business and technical requirements and translate them into maintainable Oracle-based solutions

  • Design, develop, enhance, and support enterprise applications using Oracle SQL and PL/SQL

  • Build and maintain packages, procedures, functions, triggers, cursors, collections, interfaces, extracts, and data processing solutions

  • Write, optimize, and tune complex SQL for high-volume data environments (performance tuning, root-cause analysis)

  • Tune Oracle Forms, Oracle Reports, SQL, and PL/SQL for reliability and performance

  • Design and support system-to-system integrations (RESTful APIs, web services, mid-tier/application-to-database integrations)

  • Contribute across the full SDLC: estimation, technical design, development, peer/code reviews, unit/integration testing, deployments, production support, and documentation

  • Collaborate with technical and non-technical stakeholders and provide technical leadership as needed


What you bring (must-have)


  • Degree or diploma in Computer Science, Information Technology, or a related field (or equivalent experience)

  • 10+ years of progressive enterprise application development experience with substantial hands-on Oracle PL/SQL

  • Advanced PL/SQL skills (packages, procedures, functions, triggers, cursors, collections)

  • Strong Oracle Forms and Oracle Reports development/support experience (e.g., Forms 10g/12c or comparable)

  • Strong SQL skills (complex queries/subqueries, large dataset processing, performance optimization)

  • Experience with Oracle SQL Developer and/or TOAD

  • Experience with source control practices/tools (e.g., Git/GitLab)

  • Unix/Linux experience including shell scripting

  • Experience working in Agile and structured/hybrid delivery environments

  • Strong documentation, troubleshooting, estimation, and communication skills


Nice-to-have / assets


  • Jira and ServiceNow experience (Azure DevOps, Xray/ALM, or similar tools considered an asset)

  • Strong understanding of application security and data privacy in controlled enterprise environments

  • Oracle certifications


At Aplin — together with our brands CompuStaff, Impact Recruitment, and Vantix Systems — we connect great people with great organizations across North America. We believe diverse teams build stronger companies, and we welcome applicants from all backgrounds, experiences, and perspectives. We use AI tools to assist in a fair and efficient matching process, helping our recruiters connect the right people with the right opportunities. To be considered, applicants must be legally entitled to work in Canada, including holding any required permits. Our recruitment services are always free for job seekers.Accommodation is available upon request throughout all stages of the recruitment process.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Systems Analyst
Senior Systems Analyst

Vantix Systems Inc. • Edmonton

Hybrid
CAD 120,000 - 150,000
Systems Analyst (PL/SQL)
Systems Analyst (PL/SQL)

10 Percent Recruiting Ltd. • Edmonton

Hybrid
CAD 100,000 - 140,000
Senior Business Analyst (2)
Senior Business Analyst (2)

Aplin • Edmonton

Hybrid
CAD 90,000 - 130,000
Senior Business Analyst (2)
Senior Business Analyst (2)

Vantix Systems Inc. • Edmonton

Hybrid
CAD 83,000 - 124,000
Int Application Analyst
Int Application Analyst

Vantix Systems Inc • Edmonton

Hybrid
CAD 85,000 - 110,000
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

S.I. Systems Ltd. • Edmonton, Calgary

Hybrid
CAD 110,000 - 150,000
Int Application Analyst
Int Application Analyst

Aplin • Edmonton

Hybrid
CAD 55,000 - 96,000
Manager, Enterprise Platforms & Analytics
Manager, Enterprise Platforms & Analytics

Aplin • Edmonton

On-site
CAD 150,000 - 210,000
Senior System Analyst – Information Technology
Senior System Analyst – Information Technology

Alberta Blue Cross • Edmonton

On-site
CAD 110,000 - 150,000
Sr. Data Conversion Analyst
Sr. Data Conversion Analyst

Vantix Systems Inc • Edmonton

On-site
CAD 90,000 - 120,000
Restaurant access