> Markdown version of [/jobs/ext/4296499-sr-db2-developer](https://www.wearedevelopers.com/jobs/ext/4296499-sr-db2-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Sr DB2 Developer

- **Company:** Capgemini
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Salary:** $91,395.0 - $142,792.0
- **Contract:** Temporary contract
- **Skills:** Data Analysis, Big Data, Code Review, Databases, Data Validation, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Warehousing, IBM DB2, IBM InfoSphere DataStage, Linux, Dimensional Modeling, Disaster Recovery, IBM Cognos Business Intelligence, Job Scheduling, Performance Tuning, Query Optimization, Release Management, Shell Script, SQL Stored Procedures, Freeform SQL, Informatica Powercenter, Database Optimization, Ab Initio
- **Published:** October 5, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=b0731ad8a731bc7a

## About the Role

Technical Skills:

 * Strong experience with IBM DB2 (LUW) in large-scale data warehouse environments.
 * Advanced SQL expertise.
 * Solid experience with Linux/Unix administration.
 * Hands-on experience with IBM Cognos Analytics / Cognos BI.
 * Knowledge of data warehousing concepts and dimensional modeling.
 * Experience with ETL tools (DataStage, Informatica, Ab Initio, or similar).
 * Performance tuning and troubleshooting skills.
 * Shell scripting (bash/ksh).

## Description

We are seeking an experienced DB2 Data Warehouse Engineer with strong Linux and IBM Cognos reporting skills. The ideal candidate will be responsible for designing, developing, optimizing, and supporting enterprise data warehouse solutions on IBM DB2, ensuring high performance, reliability, and data integrity while enabling business intelligence and analytics through Cognos., Data Warehouse & DB2:

 * Design, develop, and maintain DB2-based data warehouse and data marts.
 * Develop and optimize complex SQL queries, stored procedures, views, and indexes.
 * Perform performance tuning (query optimization, indexing strategies, partitioning).
 * Manage ETL/ELT processes, including data validation and reconciliation.
 * Implement data modeling (dimensional/star/snowflake schemas).
 * Monitor database health, capacity, and performance metrics.
 * Handle backup, recovery, and disaster recovery strategies.
 * Linux
 * Manage job scheduling (cron, enterprise schedulers).

Cognos & BI:

 * Develop, deploy, and support IBM Cognos reports, dashboards, and packages.
 * Work with business users to translate requirements into Cognos data models and reports.
 * Optimize Cognos performance and ensure data accuracy.
 * Support security models (roles, groups, row-level security).

Operations & Collaboration:

 * Work closely with ETL developers, BI analysts, and business stakeholders.
 * Support production environments, including incident resolution and root cause analysis.
 * Participate in release management, change management, and code reviews.
 * Ensure compliance with data governance, security, and audit requirements.