Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Saransh Inc

NewBe an early applicant

PL/SQL Developer with Unix & DB2 - Canada

Posted

Summary

Contract PL/SQL developer role in Montreal (3 days/week onsite) designing, maintaining, and tuning database solutions, batch processes, and automation scripts using Oracle PL/SQL, DB2 UDB, Unix/Linux shell scripting, Python/Perl, and schedulers like Autosys/Control-M for critical business applications.

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

Skills

Apply

See also

Backend jobs by country — openings, pay and top skills →