IBM DB2 - AWS Data Warehouse Administrator

IBM DB2 - AWS Data Warehouse Administrator

Posted 2 days ago by Symbioun Technologies, Inc

Negotiable
Undetermined
Hybrid
Remote or Hybrid in Lincoln, Nebraska

Summary: The IBM DB2 - AWS Data Warehouse Administrator role requires a seasoned professional with extensive experience in managing IBM DB2 Warehouse, particularly in AWS environments. The position involves database administration, performance tuning, and supporting ETL processes, with a focus on healthcare or Medicaid data being advantageous. The role can be performed remotely or in a hybrid setup based in Lincoln, Nebraska.

Key Responsibilities:

  • Administer IBM DB2 Warehouse in AWS
  • Manage database installation, configuration, patching, upgrades, and administration
  • Support data warehouse migration and data validation
  • Optimize SQL performance, indexing, and query execution
  • Support ETL processes and work with DataStage and Cognos
  • Implement backup, recovery, high availability, and disaster recovery strategies
  • Monitor and optimize database performance in cloud environments
  • Provide documentation, troubleshooting, and operational support
  • Utilize AWS services (EC2, S3, IAM, CloudWatch)
  • Handle large-scale batch and reporting workloads

Key Skills:

  • 8+ years as a DB2 DBA or 3+ years supporting IBM DB2 Warehouse
  • Hands-on experience with IBM DB2 Warehouse in AWS
  • Strong SQL skills with performance tuning, indexing, and query optimization
  • Experience with ETL processes, DataStage, and Cognos
  • Knowledge of backup, recovery, high availability, and disaster recovery
  • Strong documentation and troubleshooting skills
  • Experience with AWS services (EC2, S3, IAM, CloudWatch)
  • Healthcare or Medicaid data experience is a plus
  • Knowledge of security, compliance, and data governance standards
  • Experience supporting large-scale batch and reporting workloads

Salary (Rate): undetermined

City: Lincoln

Country: United States

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Requirements:

  • 8+ years as a DB2 DBA or 3+ years supporting IBM DB2 Warehouse
  • Hands-on experience administering IBM DB2 Warehouse in AWS
  • Strong experience with database installation, configuration, patching, upgrades, and administration
  • Experience with data warehouse migration and data validation
  • Strong SQL skills with performance tuning, indexing, and query optimization
  • Experience supporting ETL processes and working with DataStage and Cognos
  • Knowledge of backup, recovery, high availability, and disaster recovery
  • Experience monitoring and optimizing database performance in cloud environments
  • Strong documentation, troubleshooting, and operational support skills
  • Experience with AWS services (EC2, S3, IAM, CloudWatch) is preferred
  • Healthcare or Medicaid data experience is a plus
  • Knowledge of security, compliance, and data governance standards
  • Experience supporting large-scale batch and reporting workloads