Senior DB2 Warehouse Admin | AWS Data Warehouse

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.

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

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