IBM DB2 Warehouse Administrator AWS
Share
Job Location:
Lincoln, NE - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Job Title:IBM DB2 Warehouse Administrator - AWS
Duration:12 Months
Location:Lincoln Nebraska
IBM DB2 Warehouse Administrator - AWS
Job Summary:
We are seeking a highly skilled IBM DB2 Warehouse Edition Administrator with expertise in AWS environments (ECS S3 CloudWatch IAM) to manage optimize and modernize our data warehouse infrastructure. This role will support our data warehouse migration efforts between AWS accounts while ensuring performance reliability and security. The ideal candidate will combine advanced DB2 administration knowledge with AWS data service proficiency to support ongoing performance tuning automation and operational excellence.
Key Responsibilities:
Lead and manage migrations of IBM DB2 Warehouse Edition databases from current vendor AWS to the State Managed AWS ECS ensuring data integrity minimal downtime and compliance with security standards.
Administer and optimize IBM DB2 Warehouse Edition for performance scalability and high availability in a containerized ECS environment.
Monitor and analyze database performance metrics (CPU I/O memory workload distribution query response) and implement tuning strategies for ongoing optimization.
Develop automation scripts for health checks backup/recovery scaling and failover management.
Collaborate with existing project team to deploy scale and secure DB2 clusters and supporting AWS infrastructure.
Implement and manage backup recovery for the DB2 environments.
Support ETL optimization and data warehouse performance improvements working closely with data engineering teams.
Maintain detailed documentation including migration plans validation procedures and system architecture diagrams.
Provide ongoing DBA support including patching upgrades performance diagnostics and incident resolution.
Required Skills and Experience:
8 years of experience administering IBM DB2 databases with at least 3 years supporting DB2 Warehouse Edition in cloud or containerized environments.
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 tuning.
Hands-on experience with AWS ECS S3 CloudWatch IAM and optionally RDS for DB2.
Familiarity with AWS Database Migration Service (DMS) or comparable tools for ETL and replication.
Expertise in Linux shell scripting automation and operational monitoring.
Knowledge of database security auditing and access control best practices.
Experience supporting change management and release processes within an Agile or DevOps environment.
Excellent analytical problem-solving and communication skills.
Preferred Qualifications:
Bachelors degree in Computer Science Information Systems or a related field.
AWS Certification (Solutions Architect Database Specialty or DevOps Engineer) is a plus.
Duration:12 Months
Location:Lincoln Nebraska
IBM DB2 Warehouse Administrator - AWS
Job Summary:
We are seeking a highly skilled IBM DB2 Warehouse Edition Administrator with expertise in AWS environments (ECS S3 CloudWatch IAM) to manage optimize and modernize our data warehouse infrastructure. This role will support our data warehouse migration efforts between AWS accounts while ensuring performance reliability and security. The ideal candidate will combine advanced DB2 administration knowledge with AWS data service proficiency to support ongoing performance tuning automation and operational excellence.
Key Responsibilities:
Lead and manage migrations of IBM DB2 Warehouse Edition databases from current vendor AWS to the State Managed AWS ECS ensuring data integrity minimal downtime and compliance with security standards.
Administer and optimize IBM DB2 Warehouse Edition for performance scalability and high availability in a containerized ECS environment.
Monitor and analyze database performance metrics (CPU I/O memory workload distribution query response) and implement tuning strategies for ongoing optimization.
Develop automation scripts for health checks backup/recovery scaling and failover management.
Collaborate with existing project team to deploy scale and secure DB2 clusters and supporting AWS infrastructure.
Implement and manage backup recovery for the DB2 environments.
Support ETL optimization and data warehouse performance improvements working closely with data engineering teams.
Maintain detailed documentation including migration plans validation procedures and system architecture diagrams.
Provide ongoing DBA support including patching upgrades performance diagnostics and incident resolution.
Required Skills and Experience:
8 years of experience administering IBM DB2 databases with at least 3 years supporting DB2 Warehouse Edition in cloud or containerized environments.
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 tuning.
Hands-on experience with AWS ECS S3 CloudWatch IAM and optionally RDS for DB2.
Familiarity with AWS Database Migration Service (DMS) or comparable tools for ETL and replication.
Expertise in Linux shell scripting automation and operational monitoring.
Knowledge of database security auditing and access control best practices.
Experience supporting change management and release processes within an Agile or DevOps environment.
Excellent analytical problem-solving and communication skills.
Preferred Qualifications:
Bachelors degree in Computer Science Information Systems or a related field.
AWS Certification (Solutions Architect Database Specialty or DevOps Engineer) is a plus.
Required Skills:
AWSIBM DB2DEVOPS
Key Skills
- Children Activity
- Animal Care
- Change Management
- Jsf
- C++
- Flash
