Movojobs
Back to results

Added

Saransh Inc

PL/SQL Developer with Unix & DB2 - Canada

  • Montreal, QC, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type
Contract
Apply by
Posting language
English
Posted

Original job description

Role: PL/SQL Developer (Unix & DB2)

Location: Montreal, QC (3 days a week onsite is required)

Job Type: 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 optimizing database solutions, batch processes, and automation scripts that support critical business applications.

Required Skills

  • Strong expertise in Oracle PL/SQL development, including:
    • Stored Procedures
    • Packages
    • Functions
    • Triggers
    • Views
    • Performance Tuning and Query Optimization
  • 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-Oriented Programming concepts
  • Strong analytical and problem-solving skills
  • Ability to gather business requirements and translate them into technical solutions
  • Excellent troubleshooting and debugging skills
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 optimize 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
Apply About employer
More about this job

Responsibilities

Design, develop, test, maintain, and optimize Oracle PL/SQL applications, DB2 queries and procedures, and Unix/Linux scripts for database solutions and batch processing. Troubleshoot production issues, tune performance, collaborate on requirements and technical designs, and participate in reviews, testing, deployment, and production support.

Requirements

The role requires strong Oracle PL/SQL, DB2 UDB, Unix/Linux, and shell scripting experience, along with scripting or automation skills and familiarity with scheduling tools. Candidates should have strong analytical, troubleshooting, and communication abilities; ETL, data warehouse, financial services, and Agile experience are desirable.

Skills

  • Oracle PL/SQL
  • DB2 UDB
  • Unix/Linux
  • Shell Scripting
  • Bash
  • Korn Shell
  • Python
  • Perl
  • Autosys
  • Control-M
  • SQL Performance Tuning
  • Informatica ETL
  • Greenplum
  • Batch Processing
  • Object-Oriented Programming
  • Agile/Scrum

Visa sponsorship

Not detected in the job text

Categories

  • Technology
  • Software
  • Data & Analytics
  • Finance & Accounting

Keywords

  • Oracle PL/SQL
  • Stored Procedures
  • Packages
  • Functions
  • Triggers
  • Views
  • DB2 UDB
  • SQL Query Optimization
  • Database Performance Tuning
  • Unix/Linux
  • Shell Scripting
  • Bash
  • Korn Shell
  • Python
  • Perl
  • Autosys
  • Control-M
  • Object-Oriented Programming
  • Informatica ETL
  • Greenplum
  • Data Warehousing
  • Banking
  • Financial Services
  • Capital Markets
  • Data Integration
  • Batch Processing
  • Agile/Scrum
  • Production Support

Report this job