Data Developer Expert

IBM DB2 Warehouse Administrator (AWS Data Warehouse)

Department of Health and Human Services (DHHS) is seeking a DB2 Warehouse Administrator to support the implementation, migration, and ongoing operations of the Department’s enterprise Data Warehouse, migrating from existing vendor-hosted AWS to state-hosted AWS infrastructure.

This role will play a critical part in the migration from vendor-hosted to state-hosted AWS environment, initial configuration, and ongoing administration of IBM DB2 Warehouse, support data migration activities from vendor-hosted to state-hosted AWS infrastructure, collaborate closely with ETL and Data Stage teams, and ensure the performance optimization, security, reliability, and ongoing maintenance operations after the migration of the Data Warehouse platform.

• 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 applicable to State and Federal systems.
• Support initial data migration from vendor-hosted AWS to state-hosted AWS into DB2 Warehouse from legacy or source systems.
• Validate data loads, data integrity, and migration outcomes.
• Partner 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.
• Optimize SQL, indexing, partitioning, and workload management.
• Tune batch loads, incremental loads, and reporting queries.
• Identify and resolve ETL-related performance bottlenecks.
• Provide guidance on DB2 best practices for large-scale analytical workloads.
• 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, standard operating procedures, and technical documentation.
• Support production and non-production environments.

• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• 8+ years of experience as a Database Administrator supporting DB2 or 3+ years of experience for DB2 Warehouse edition.
• Hands‑on experience administering databases in a cloud environment (AWS preferred).
• Strong SQL skills and experience with 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 a regulated or public‑sector environment is a plus.

• Experience with IBM DB2 Warehouse on AWS.
• Hands‑on experience working with IBM Data Stage and IBM Cognos for ETL and Cognos 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.

Mid‑Senior level

Full‑time

Other