IBM DBWarehouse Administrator AWS Data Warehouse

IBM DB2 Warehouse Administrator AWS Data Warehouse

01/05/2026

Contract

Active

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.

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

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

• Work closely with IBM Data Stage, 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.

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

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

• Experience with IBM DB2 Warehouse on AWS.
• Hands‑on experience with IBM Data Stage 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, Cloud Watch, and networking concepts.