Summary: The role of IBM DB2 Warehouse Administrator involves supporting the implementation, migration, and ongoing operations of an enterprise Data Warehouse platform. The candidate will be responsible for database administration, performance optimization, and ensuring data integrity, particularly in healthcare or Medicaid data systems. Strong hands-on experience with DB2 Warehouse and AWS cloud environments is essential for success in this position.
Key Responsibilities:
- Install, configure, and administer IBM DB2 Warehouse in an AWS environment
- Support migration, perform database provisioning, patching, upgrades, and configuration management
- Monitor database health, availability, capacity, and performance
- Tune SQL queries, indexing, and workload performance
- Implement and manage backup, recovery, high availability, and disaster recovery
- Support data migration activities and validate data integrity
- Collaborate closely with ETL teams, including IBM DataStage and Cognos
- Ensure database security, access controls, auditing, and compliance
- Support large-scale batch processing and reporting workloads
- Provide ongoing operations and maintenance support in production and non-production environments
Key Skills:
- Experience as a DB2 Database Administrator or experience administering IBM DB2 Warehouse
- Hands-on experience administering databases in cloud environments (AWS preferred)
- Strong SQL skills with performance tuning and query optimization experience
- Experience supporting enterprise data warehouse or analytical database platforms
- Knowledge of backup, recovery, high availability, and disaster recovery strategies
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Client is seeking an experienced IBM DB2 Warehouse Administrator to support the implementation, migration, and ongoing operations of an enterprise Data Warehouse platform. This role will be responsible for migrating the Data Warehouse, along with ongoing administration and performance optimization. The ideal candidate will have strong hands-on DB2 Warehouse DBA experience, exposure to AWS cloud environments, and experience supporting healthcare or Medicaid data systems in a regulated environment.
Key Responsibilities
- Install, configure, and administer IBM DB2 Warehouse in an AWS environment
- Support migration, Perform database provisioning, patching, upgrades, and configuration management
- Monitor database health, availability, capacity, and performance
- Tune SQL queries, indexing, and workload performance
- Implement and manage backup, recovery, high availability, and disaster recovery
- Support data migration activities and validate data integrity
- Collaborate closely with ETL teams, including IBM DataStage and Cognos
- Ensure database security, access controls, auditing, and compliance
- Support large-scale batch processing and reporting workloads
- Provide ongoing operations and maintenance support in production and non-production environments
Required Qualifications
- Experience as a DB2 Database Administrator or experience administering IBM DB2 Warehouse
- Hands-on experience administering databases in cloud environments (AWS preferred)
- Strong SQL skills with performance tuning and query optimization experience
- Experience supporting enterprise data warehouse or analytical database platforms
- Knowledge of backup, recovery, high availability, and disaster recovery strategies
Preferred Qualifications
- Experience administering IBM DB2 Warehouse on AWS
- Hands-on experience with IBM DataStage and IBM Cognos
- AWS experience with EC2, S3, IAM, CloudWatch, and networking concepts
- Knowledge of Medicaid or healthcare data (claims, eligibility, provider, encounter data)
- Familiarity with HIPAA, CMS and experience supporting large-scale batch processing and reporting workloads
