Overview
Skills
Job Details
IBM DB2 Warehouse Administrator – AWS (Remote)
< data-start="395" data-end="422"> Important Details</>
Position Type: Remote
Client: NeDHHS (Department of Health and Human Services)
< data-start="527" data-end="554"> Position Overview</>
We are seeking a highly skilled IBM DB2 Warehouse Edition Administrator with proven expertise in AWS environments (ECS, S3, CloudWatch, IAM) to manage, optimize, and modernize our data warehouse infrastructure.
This role will play a critical part in supporting the migration of DB2 data warehouses between AWS accounts, ensuring security, performance, and reliability throughout the transition.
The ideal candidate combines advanced DB2 administration experience with AWS data services knowledge to drive automation, performance tuning, and operational excellence across cloud-based data warehouse environments.
< data-start="1214" data-end="1244"> Key Responsibilities</>
Lead and manage IBM DB2 Warehouse Edition migrations from vendor-managed AWS to State-managed AWS ECS environments, ensuring data integrity and minimal downtime.
Administer and optimize DB2 Warehouse Edition for performance, scalability, and high availability within a containerized ECS environment.
Monitor and analyze database performance metrics (CPU, I/O, memory, query response, workload distribution) and implement tuning strategies for continuous improvement.
Develop automation scripts for system health checks, scaling, backup/recovery, and failover management.
Collaborate with project and infrastructure teams to deploy, scale, and secure DB2 clusters in AWS.
Implement and manage backup and recovery strategies for DB2 environments.
Support ETL optimization and data warehouse performance improvements, working closely with data engineering teams.
Maintain comprehensive documentation — including migration plans, validation procedures, and architecture diagrams.
Provide ongoing DBA support, including patching, upgrades, diagnostics, and incident resolution.
< data-start="2418" data-end="2456"> Required Skills & Experience</>
8+ years of experience administering IBM DB2 databases, including 3+ years with DB2 Warehouse Edition in cloud or containerized setups.
Proven experience migrating DB2 data warehouses to AWS and performing cross-account migrations.
Experience in Medicaid, Medicare, or healthcare data warehouse environments.
Strong proficiency in DB2 utilities, backup/restore operations, and query performance tuning.
Hands-on experience with AWS ECS, S3, CloudWatch, IAM, and optionally RDS for DB2.
Familiarity with AWS Database Migration Service (DMS) or equivalent ETL/replication tools.
Expertise in Linux shell scripting, automation, and monitoring tools.
Knowledge of database security, auditing, and access control best practices.
Experience supporting change management and release processes in Agile or DevOps environments.
Strong analytical, problem-solving, and communication skills.
< data-start="3473" data-end="3507"> Preferred Qualifications</>
Bachelor’s degree in Computer Science, Information Systems, or a related field.
AWS Certifications such as Solutions Architect, Database Specialty, or DevOps Engineer are a plus.