Senior Systems Analyst

Vantix Systems Inc.

Edmonton

Hybrid

CAD 120,000 - 150,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

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

Get past ATS filters

Job summary

Alberta Blue Cross is seeking a Senior Systems Analyst (Oracle) to design, develop, enhance, and support Oracle-based enterprise applications in a hands-on, senior role. The position is contract, hybrid, and based in Edmonton or Calgary, AB.

The role centers on Oracle SQL/PLSQL, Oracle Forms and Reports, as well as system integrations, across the full SDLC, with collaboration across technical and non-technical stakeholders.

Qualifications

  • 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 (Forms 10g/12c).
  • Strong SQL skills (complex queries/subqueries, large datasets, performance optimization).
  • Experience with Oracle SQL Developer and/or TOAD.
  • Experience with Git/GitLab and source control practices.
  • Unix/Linux experience including shell scripting.
  • Experience working in Agile and hybrid delivery environments.
  • Strong documentation, troubleshooting, estimation, and communication skills.

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 (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.

Skills

Oracle PL/SQL
SQL
Oracle Forms
Oracle Reports
Git/GitLab
Unix/Linux
Agile delivery
Documentation

Education

Degree or diploma in Computer Science or IT

Tools

Oracle SQL Developer
TOAD
RESTful APIs

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

We welcome applicants from all backgrounds, experiences, and perspectives.

To be considered, applicants must be legally entitled to work in Canada, including holding any required permits.

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

Aplin • Edmonton

Hybrid
CAD 96,000 - 138,000
Systems Analyst (PL/SQL)
Systems Analyst (PL/SQL)

10 Percent Recruiting Ltd. • Edmonton

Hybrid
CAD 100,000 - 140,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
Senior Business Analyst (2)
Senior Business Analyst (2)

Vantix Systems Inc. • Edmonton

Hybrid
CAD 83,000 - 124,000
Senior Oracle EBS Developer to deliver Oracle E-Business Suite technical development and application support
Senior Oracle EBS Developer to deliver Oracle E-Business Suite technical development and application support

S I Systems • Calgary

Hybrid
CAD 120,000 - 160,000
Senior Business Analyst (2)
Senior Business Analyst (2)

Aplin • Edmonton

Hybrid
CAD 90,000 - 130,000
Senior Oracle HCM Consultant - TERM
Senior Oracle HCM Consultant - TERM

Red Deer • Red Deer

On-site
CAD 79,000 - 98,000
Senior Oracle Database Developer
Senior Oracle Database Developer

Bevertec • Toronto

On-site
CAD 124,000 - 138,000
Senior Information Technology Business Analyst
Senior Information Technology Business Analyst

InSync Systems • Edmonton

Hybrid
CAD 80,000 - 100,000
Oracle Database Administrator
Oracle Database Administrator

Pacer Group • Toronto

Hybrid
CAD 76,000 - 80,000