PL/SQL Developer (Unix & DB2)

PL/SQL Developer (Unix & DB2)

Location: Montreal, QC (3 days/week Onsite)

Context / Background:

This role was originally open for a DB2 Developer. Due to candidate pool availability, the requirement has been updated to focus on a PL/SQL Developer with some DB2 experience or a strong willingness to learn DB2.

Job Description 

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

Key Responsibilities

• 
  

  Oracle & DB2 Development: Design, develop, test, and maintain Oracle PL/SQL applications, database objects, DB2 SQL queries, stored procedures, and data processing routines.

  
  


• 
  

  Automation & Scripting: Create and maintain Unix/Linux shell scripts for automation and batch processing.

  
  


• 
  

  Performance Optimization: Perform performance tuning of SQL queries, PL/SQL code, and overall database processes.

  
  


• 
  

  Production Support & Troubleshooting: Support production systems, perform debugging, and resolve application/database issues.

  
  


• 
  

  Collaboration & Requirements Gathering: Partner with business analysts, developers, and stakeholders to translate business requirements into technical solutions.

  
  


• 
  

  Documentation & Process: Prepare technical design documents, implementation plans, and ensure compliance with development standards.

  
  


• 
  

  Lifecycle Participation: Participate in code reviews, testing, deployment, and ongoing production support activities.

  
  

Required Skills & Qualifications

• 
  

  Oracle PL/SQL Expertise:

  
  
  
  
  • 
    

    Stored Procedures, Packages, Functions, Triggers, Views

    
    
  
  
  • 
    

    Performance Tuning and Query Optimization

    
    
  
  
  
  


• 
  

  DB2 UDB Knowledge:

  
  
  
  
  • 
    

    Complex SQL query development, data analysis, and retrieval

    
    
  
  
  • 
    

    Stored procedures and database performance tuning

    
    
  
  
  
  


• 
  

  Unix/Linux & Scripting:

  
  
  
  
  • 
    

    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

    
    
  
  
  
  


• 
  

  Tools & Systems:

  
  
  
  
  • 
    

    Experience with scheduling tools (e.g., Autosys, Control-M, or similar platforms)

    
    
  
  
  • 
    

    Good understanding of Object-Oriented Programming (OOP) concepts

    
    
  
  
  
  


• 
  

  Professional Competencies:

  
  
  
  
  • 
    

    Strong analytical, troubleshooting, and problem-solving skills

    
    
  
  
  • 
    

    Ability to translate business requirements into robust technical solutions

    
    
  
  
  • 
    

    Excellent communication and documentation skills

    
    
  
  
  • 
    

    Proven 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

  
  


• 
  

  Prior experience in Banking, Financial Services, or Capital Markets

  
  


• 
  

  Knowledge of data integration and batch processing frameworks

  
  


• 
  

  Exposure to Agile/Scrum development methodologies