Oracle pl sql developer Offres d'emploi - Edmonton, AB

Job Description (JD)

Position: Full Stack Application Developer / Application Development Support Specialist
Client: Government of Alberta (GoA) – Technology and Innovation
Business Unit: Economic Intelligence & Investment Services Branch
Location: Primarily Remote within Canada, with approximately 15% onsite work in Edmonton, Alberta
Contract Type: Contingent (GOA Standard)
Hours: 36.25 hours/week (7.25 hours/day)
Start: TBD
Extension: Up to 12 months possible

Position Overview

The Government of Alberta is seeking experienced Full Stack Developers to support the maintenance, enhancement, and modernization of investment-focused web applications used by businesses, investors, economic developers, and government stakeholders.

The successful candidate will provide application development and support services for multiple public-facing data platforms, dashboards, and investment tools while ensuring high availability, performance, security, and scalability.

Requirements

Applications Supported

• Alberta Economic Dashboard (AED)
  
• Alberta Site Selector Tool
  
• Investment Data Hub
  
• Alberta Regional Dashboard
  
• Alberta Major Projects
  
• Alberta Export Tool
  

Key Responsibilities

Application Development

• Design and develop frontend and backend web applications.
  
• Develop website architecture and application interfaces.
  
• Build and maintain reusable components using StencilJS and Angular.
  
• Develop and maintain Umbraco CMS-based applications.
  
• Create responsive and user-friendly web interfaces.
  

Data & Integration

• Design and develop data pipelines and ETL processes.
  
• Develop SQL-based data applications and reporting solutions.
  
• Integrate REST and SOAP APIs.
  
• Support Azure Data Factory, Azure SQL, and Databricks solutions.
  

Cloud & Infrastructure

• Support and maintain cloud-based applications hosted in Microsoft Azure.
  
• Troubleshoot application performance, scalability, and reliability issues.
  
• Monitor website, application, and API performance.
  

Quality Assurance

• Perform unit testing and support User Acceptance Testing (UAT).
  
• Implement automated testing practices.
  
• Resolve defects and production issues.
  
• Ensure solution quality and compliance standards.
  

Agile Delivery

• Participate in Agile ceremonies and sprint activities.
  
• Collaborate with business analysts, product owners, designers, and stakeholders.
  
• Provide technical documentation and status reporting.
  

Operations Support

• Support application releases and deployments.
  
• Coordinate release schedules.
  
• Provide transition-to-operations support.
  
• Participate in on-call support when required.
  

Mandatory Qualifications

1. SQL Development

• Minimum 4 years experience designing and developing data pipelines and data applications using SQL.
  

2. StencilJS

• Minimum 6 years experience architecting complex web-based component solutions using StencilJS.
  

3. Umbraco CMS

• Minimum 6 years experience developing data content application systems using Umbraco CMS.
  

4. Socio-Economic Data

• Minimum 6 years experience working with socio-economic datasets and reporting applications.
  

5. Performance Optimization

• Minimum 4 years experience analyzing and resolving:
  • Website performance issues
    
  • Application performance issues
    
  • API performance issues
    

6. Azure Technologies

• Minimum 4 years experience supporting:
  • Microsoft Azure
    
  • Azure SQL
    
  • Azure Data Factory
    
  • Databricks
    

Required Technical Skills

Front-End

• StencilJS
  
• Angular
  
• Bootstrap
  
• HTML5
  
• CSS3 (LESS/SASS)
  
• JavaScript
  
• XHTML
  

Back-End

• ASP.NET
  
• C#
  
• LINQ
  
• SQL Server
  
• REST APIs
  
• SOAP Services
  

CMS

• Umbraco CMS
  

Cloud & Data

• Microsoft Azure
  
• Azure SQL
  
• Azure Data Factory
  
• Databricks
  
• ETL Processes
  

Visualization & Mapping

• AmCharts
  
• Tableau (preferred)
  
• Mapbox
  
• Leaflet
  
• ArcGIS
  

Development Methodologies

• Agile/Scrum
  
• SDLC
  
• Application Lifecycle Management
  
• Change Management
  

Nice-to-Have Qualifications

CI/CD & DevOps

• 4+ years of CI/CD implementation
  
• SDLC automation experience
  

Artificial Intelligence

• 2+ years designing AI assistants
  
• AI-powered data applications
  
• AI integration into enterprise applications
  
• Experience with modern AI tools and frameworks
  

Government Experience

• 2+ years working in:
  • Government of Alberta
    
  • Large public-sector organizations
    
  • Complex enterprise environments
    

Visualization & Mapping

• 4+ years with:
  • AmCharts
    
  • Tableau
    
  • Mapbox
    
  • GIS technologies
    

Work Arrangement

• Remote within Canada.
  
• Approximately 15% onsite work in Edmonton, Alberta.
  
• Travel expenses are not reimbursed.
  
• Work must be performed within Canada.
  

Working Hours

Monday – Friday
8:15 AM – 4:30 PM Mountain Time

Security Requirements

• Criminal Record Check (mandatory)
  
• Potential requirement for:
  • Enhanced Security Clearance
    
  • RCMP Top Secret Clearance (if required)