IBM DB2 Warehouse Administrator AWS Data Warehouse

Compunnel, Inc.; Lincoln (NE); On-site; USD 100,000 - 130,000; Part time

Job summary

A technology solutions company is seeking an experienced DB2 Warehouse Administrator to support migrating a data warehouse to an AWS infrastructure. Responsibilities include managing DB2 Warehouse in AWS, optimizing database performance, and ensuring data integrity. The ideal candidate has over 8 years of DBA experience, strong skills in SQL performance tuning, and familiarity with healthcare data compliance. This is a contract position based in Lincoln, Nebraska.

Qualifications

• 8+ years of experience as a Database Administrator supporting DB2.
• Hands-on experience administering databases in a cloud environment (AWS preferred).
• Experience with enterprise data warehouse platforms.

Responsibilities

• Install, configure, and administer IBM DB2 Warehouse.
• Support initial data migration from vendor-hosted AWS to client-hosted AWS.
• Optimize SQL, indexing, and workload management.

Skills

DB2 Warehouse Administration

SQL Performance Tuning

AWS Cloud Expertise

Database Security Management

ETL Processes with IBM DataStage

Education

Bachelor’s degree in Computer Science or related field

Tools

IBM DB2 Warehouse

IBM DataStage

IBM Cognos

AWS (EC2, S3, IAM)

Job description

IBM DB2 Warehouse Administrator AWS Data Warehouse

01/05/2026

Contract

Active

Job Description:

Job Summary

We are seeking an experienced DB2 Warehouse Administrator to support the implementation, migration, and ongoing operations of an enterprise Data Warehouse.

This role will focus on migrating from a vendor-hosted AWS environment to a client-hosted AWS infrastructure, configuring IBM DB2 Warehouse, and ensuring optimal performance, security, and reliability post‑migration.

The ideal candidate will have strong hands‑on DBA experience with DB2 Warehouse, cloud expertise, and familiarity with healthcare or Medicaid data.

Key Responsibilities

DB2 Warehouse Administration & Operations

• Install, configure, and administer IBM DB2 Warehouse in an AWS environment.
• Perform database provisioning, patching, upgrades, and configuration management.
• Monitor database health, availability, and capacity; proactively address performance issues.
• Implement and maintain backup, recovery, and disaster recovery strategies.
• Manage database security, user access, roles, and privileges in alignment with State security policies.
• Support audit, logging, and compliance requirements for State and Federal systems.

Data Migration & Platform Enablement

• Support initial data migration from vendor-hosted AWS to client-hosted AWS DB2 Warehouse.
• Validate data loads, integrity, and migration outcomes.
• Collaborate with vendors and internal teams during migration and cutover activities.
• Assist in defining data standards, naming conventions, and warehouse best practices.

ETL & Performance Optimization

• Work closely with IBM DataStage, IBM Cognos, and ETL teams.
• Optimize SQL, indexing, partitioning, and workload management.
• Tune batch loads, incremental loads, and reporting queries.
• Identify and resolve ETL‑related performance bottlenecks.

Operations & Maintenance

• Provide ongoing database operations and maintenance support.
• Respond to incidents, perform root cause analysis, and implement corrective actions.
• Participate in change management, release planning, and operational readiness activities.
• Create and maintain DBA runbooks, SOPs, and technical documentation.
• Support production and non‑production environments.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
• 8+ years of experience as a Database Administrator supporting DB2 or 3+ years with DB2 Warehouse edition.
• Hands‑on experience administering databases in a cloud environment (AWS preferred).
• Strong SQL skills with experience in performance tuning and query optimization.
• Experience supporting enterprise data warehouse or analytical database platforms.
• Familiarity with backup, recovery, high availability, and disaster recovery strategies.
• Experience working in regulated or public‑sector environments is a plus.

Preferred Qualifications

• Experience with IBM DB2 Warehouse on AWS.
• Hands‑on experience with IBM DataStage and IBM Cognos for ETL and reporting workloads.
• Knowledge of Medicaid, healthcare claims, eligibility, provider, or encounter data.
• Familiarity with HIPAA, CMS, or State/Federal data governance and security requirements.
• Experience supporting large‑scale batch processing and reporting workloads.
• AWS experience with services such as EC2, S3, IAM, CloudWatch, and networking concepts.