Apply now

Posted 2 days ago

PL/SQL Developer

@ Gala Solutions

Montréal, Quebec

Contract
Apply now
SIGNALS

Overview

Gala Solutions is hiring a contract PL/SQL Developer in Montreal, QC, for a 12-month term with three days a week onsite. The role designs, develops and tunes Oracle PL/SQL applications and DB2 SQL, and builds Unix/Linux shell and batch automation for critical business applications. Strong Unix/Linux, DB2 and scripting skills are required.

Responsibilities:

  • Design, develop and maintain Oracle PL/SQL applications
  • Develop and optimise DB2 SQL queries and stored procedures
  • Create Unix/Linux shell scripts for automation and batch processing
  • Support production systems and troubleshoot issues
  • Perform performance tuning of SQL and database processes

Requirements summary:

  • Strong Oracle PL/SQL development experience
  • Strong DB2 UDB and complex SQL experience
  • Hands-on Unix/Linux and shell scripting
  • Python or Perl for automation
  • Experience with Autosys, Control-M or similar

Tools & skills

Source and dates

Source type not verified · apify-linkedin

Employer posting date
2026-11-08
First seen by our source
2026-11-10
Source record updated
2026-11-10

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SeniorityMid level
DepartmentSoftware development
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish

Summary and details written by AI from the posting; the employer’s posting is the authority.

Gala Solutions

FieldValue
Open jobs on Jobsy1
Job description

Job Title: PL/SQL Developer (Unix & DB2)

Location: Montreal, QC - 3 days a week onsite.

Duration: 12-Month Contract

Job Summary

We are seeking an experienced PL/SQL developer with strong Unix/Linux and DB2 database skills to join our team. The ideal candidate will be responsible for designing, developing, maintaining, and optimising database solutions, batch processes, and automation scripts that support critical business applications. The role requires strong analytical skills, attention to detail, and the ability to work effectively in a fast-paced environment.

Required Skills:

  • Strong expertise in Oracle PL/SQL development, including:
  • Stored Procedures
  • Packages
  • Functions
  • Triggers
  • Views
  • Performance Tuning and Query Optimisation
  • Strong experience with DB2 UDB, including:
  • Complex SQL query development
  • Data analysis and retrieval
  • Stored procedures
  • Database performance tuning
  • Hands-on experience with Unix/Linux environments
  • Expertise in Shell Scripting (Bash, Korn Shell, etc.)
  • Experience with Python or Perl scripting for automation and data processing
  • Experience with scheduling tools such as Autosys, Control-M, or similar platforms
  • Good understanding of Object-Orientated Programming concepts
  • Strong analytical and problem-solving skills
  • Ability to gather business requirements and translate them into technical solutions
  • Excellent troubleshooting and debugging skills
  • Strong communication and documentation skills
  • Ability to manage multiple priorities and deliver high-quality solutions within deadlines

Desired Skills

  • Experience with Informatica ETL
  • Experience with Greenplum or other data warehouse platforms
  • Experience working in banking, financial services, or capital markets environments
  • Knowledge of data integration and batch processing frameworks
  • Exposure to Agile/Scrum development methodologies

Responsibilities

  • Design, develop, test, and maintain Oracle PL/SQL applications and database objects
  • Develop and optimise DB2 SQL queries, stored procedures, and data processing routines
  • Create and maintain Unix/Linux shell scripts for automation and batch processing
  • Support production systems and troubleshoot application and database issues
  • Perform performance tuning of SQL queries, PL/SQL code, and database processes
  • Collaborate with business analysts, developers, and stakeholders to understand requirements
  • Prepare technical design documents and implementation plans
  • Ensure compliance with development standards and best practices
  • Participate in code reviews, testing, deployment, and production support activities.

Similar jobs

  • PL/SQL Developer

    Toronto, ON
    $70k–$115k/yrHybrid

    CMiC

    3+ YOECandidates need 3 to 7+ years of backend development, with significant hands-on Oracle and enterprise PL/SQL experience. They also need Java REST API experience, performance tuning skills and experience working in Agile or Scrum teams.

    Oracle Database, PL/SQL Developer, TOAD, SQL*Plus, Oracle JDeveloper, IntelliJ

  • Senior Machine Learning Developer

    Montréal, QC
    RemoteFull Time

    Clera

    Develop agent memory, knowledge graph, and customization tools to help systems adapt to different workflows; At least 6 years of software or machine learning engineering experience, including a track record of shipping…

  • Contremaître de chantier

    Montréal, QC
    Full Time

    Hays

    3+ YOEMinimum de 3 ans d’expérience en gestion de chantier; Expérience en projets commerciaux, institutionnels ou industriels (atout majeur); Leadership, sens de l’organisation et autonomie

    Communication skills, Leadership, Organizational skills, Valid driver's licence

  • Regional Maintenance Manager

    Montréal, QC
    Full Time

    TEN Canada

    5+ YOEFort de plusieurs décennies de connaissances et d'expérience, d'un historique exceptionnel auprès de sa clientèle et d'une vision d'avenir claire pour l'industrie, TEN propose des…; Connaissance de l'industrie :…

    Process improvement, Leadership, Dispatching, Inventory management, Coaching, Health and safety

  • Compliance Assistant

    Montréal, QC
    Full Time

    Robert Half

    1+ YOERole Requirements; 1+ year of experience in regulatory/compliance (food); Help ensure compliance with Canadian food safety and labelling requirements

    Regulatory compliance, Bilingualism, Microsoft Office, Documentation, Food safety, Packaging

    Senior Advisor, Payroll Tax & Accounting

    Montréal, QC
    Contract

    Robert Half

    Agissez en tant que spécialiste de haut niveau et digne de confiance, en pilotant les rapports de fin d’année, les audits, les rapprochements et le transfert des connaissances essentielles; C’est une excellente…

    Payroll, Taxation, Accounting, Documentation

    Senior Payroll Analyst, Bilingual

    Montréal, QC
    Full Time

    Robert Half

    5+ YOE5+ years of Canadian payroll experience, ideally supporting large, multi-provincial payrolls; Payroll Compliance Professional (PCP) designation required; PLP considered an asset; Hands-on Workday Payroll experience…

    Payroll, Bilingualism, Workday, Oracle HRIS, Account reconciliation, Reporting

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.