IBM DBWarehouse Administrator

⭐ - Featured Role | Apply direct with Data Freelance Hub

This role is for an IBM DB2 Warehouse Administrator with a contract length of "unknown" and a pay rate of $55.00 - $65.00 per hour. It requires 8+ years of DB2 DBA experience, AWS cloud proficiency, and familiarity with healthcare data.

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.

The ideal candidate will have strong hands‑on DBA experience in DB2 Warehouse, familiarity with cloud-based environments, and a solid understanding of 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 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 to 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.

$55.00 - $65.00 per hour.

Hybrid remote in Lincoln, NE 68516.