Sr DB2 Developer

Remote

Contract (8 months 4 days)

Published 4 hours ago

technical troubleshooting

Data Governance & Compliance

root cause analysis

cross - functional collaboration

ETL/ELT

production support

shell scripting

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.

Key Responsibilities:
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.

Required Skills & Qualifications:

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).

The pay range that the employer in good faith reasonably expects to pay for this position is $43.94/hour - $68.65/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.