18 Nov
|
Kutir Technologies
|
Montreal
18 Nov
Kutir Technologies
Montreal
Job DescriptionJob Descriptionn
Position Title: PL/SQL Developer (Unix & DB2)
nn
Location: Montreal QC - Hybrid
nn
Duration: 6+ months
nn
nn
Job Description:
nn
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.
nn
nn
Required Skills:
nn
Strong expertise in Oracle PL/SQL development, including:
nn
Stored Procedures
nn
Packages
nn
Functions
nn
Triggers
nn
Views
nn
Performance Tuning and Query Optimization
nn
Strong experience with DB2 UDB, including:
nn
Complex SQL query development
nn
Data analysis and retrieval
nn
Stored procedures
nn
Database performance tuning
nn
Hands-on experience with Unix/Linux environments
nn
Expertise in Shell Scripting (Bash, Korn Shell, etc.)
nn
Experience with Python or Perl scripting for automation and data processing
nn
Experience with scheduling tools such as Autosys, Control-M, or similar platforms
nn
Good understanding of Object-Oriented Programming concepts
nn
Strong analytical and problem-solving skills
nn
Ability to gather business requirements and translate them into technical solutions
nn
Excellent troubleshooting and debugging skills
nn
Solid communication and documentation skills
nn
Ability to manage multiple priorities and deliver high-quality solutions within deadlines
nn
nn
Desired Skills:
nn
Experience with Informatica ETL
nn
Experience with Greenplum or other data warehouse platforms
nn
Experience working in Banking, Financial Services, or Capital Markets environments
nn
Knowledge of data integration and batch processing frameworks
nn
Exposure to Agile/Scrum development methodologies
nn
nn
Responsibilities:
nn
Design, develop, test, and maintain Oracle PL/SQL applications and database objects
nn
Develop and optimize DB2 SQL queries, stored procedures, and data processing routines
nn
Create and maintain Unix/Linux shell scripts for automation and batch processing
nn
Support production systems and troubleshoot application and database issues
nn
Perform performance tuning of SQL queries, PL/SQL code, and database processes
nn
Collaborate with business analysts, developers, and stakeholders to understand requirements
nn
Prepare technical design documents and implementation plans
nn
Ensure compliance with development standards and best practices
nn
Participate in code reviews, testing, deployment, and production support activities
n
📌 PL/SQL Developer (Unix & (Montreal)
🏢 Kutir Technologies
📍 Montreal