Closed listing
Senior DB2 Developer
- Montreal, QC, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Closing date
- Experience
- 7+ years of experience in DB2 development.
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
We are looking for an experienced DB2 Developer to join our technology team in Montreal. The ideal candidate will have strong experience in IBM DB2 database development, SQL, stored procedures, database performance tuning, and data integration. Experience working in enterprise or banking environments is highly preferred.
Key Responsibilities
- Design, develop, and maintain IBM DB2 databases, tables, views, indexes, and stored procedures.
- Develop complex SQL queries, DB2 stored procedures, functions, triggers, and packages.
- Perform database development, optimization, troubleshooting, and performance tuning.
- Analyze and resolve DB2-related production issues and provide root-cause analysis.
- Develop and maintain data extraction, transformation, and loading processes.
- Work closely with application developers, data engineers, business analysts, and QA teams.
- Perform database migration, data conversion, and integration activities.
- Monitor database performance and identify opportunities for optimization.
- Implement appropriate indexing and query optimization strategies.
- Ensure data integrity, security, availability, and consistency.
- Participate in code reviews, testing, deployment, and production support activities.
- Prepare technical documentation for database solutions and processes.
- Follow organizational coding, security, and database development standards.
Required Skills
- 7+ years of experience in DB2 development.
- Strong knowledge of IBM DB2 database architecture and development.
- Excellent SQL skills, including complex queries and performance optimization.
- Experience with DB2 Stored Procedures, Functions, Triggers, Views, and Indexes.
- Strong understanding of database design, normalization, and data modeling.
- Experience with DB2 performance tuning and query optimization.
- Strong troubleshooting and production-support experience.
- Experience with Unix/Linux environments and shell scripting is an asset.
- Experience with ETL/data integration tools is an asset.
- Knowledge of Agile development methodologies.
- Strong communication and problem-solving skills.
More about this job
Responsibilities
Design, develop, maintain, and optimize IBM DB2 databases and database objects, including complex SQL queries, stored procedures, and ETL processes. Troubleshoot production issues, support migrations and integrations, ensure data integrity and security, and collaborate with cross-functional teams on testing, deployment, documentation, and production support.
Requirements
Requires 7+ years of DB2 development experience, strong SQL skills, and expertise in DB2 database architecture, database design, performance tuning, and production troubleshooting. Unix/Linux and shell scripting, ETL tools, Agile experience, and strong communication and problem-solving skills are assets or desired capabilities.
Skills
- IBM DB2
- SQL
- Stored Procedures
- Functions
- Triggers
- Views
- Indexes
- Database Design
- Data Modeling
- Performance Tuning
- Query Optimization
- Troubleshooting
- Production Support
- Unix/Linux
- Shell Scripting
- ETL/Data Integration
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
Keywords
- IBM DB2
- SQL
- Stored Procedures
- Functions
- Triggers
- Views
- Indexes
- Database Architecture
- Database Design
- Normalization
- Data Modeling
- Performance Tuning
- Query Optimization
- Troubleshooting
- Production Support
- ETL
- Data Integration
- Database Migration
- Data Conversion
- Unix/Linux
- Shell Scripting
- Agile
- Code Reviews
- Data Integrity
- Database Security
- Root-Cause Analysis
- Enterprise
- Banking