IBM DB2 Warehouse Administrator (AWS Data Warehouse)

IBM DB2 Warehouse Administrator (AWS Data Warehouse)

Posted 2 days ago by NovaLink Solutions

Apply
Negotiable
Undetermined
Remote
Remote
Apply
Amazon Elastic Compute Cloud Amazon Web Services (AWS) AWS Identity And Access Management (IAM) Batch Processing Business Continuity And Disaster Recovery Cloud Computing Cloud Technology Content Management Systems Database Administration Database Management Data Governance Data Warehousing Disaster Recovery Extract Transform Load (ETL) IBM DB2 IBM Software Management Performance Tuning Query Optimisation Query Tuning SQL (Programming Language)

Summary: The role of IBM DB2 Warehouse Administrator focuses on managing and optimizing DB2 databases, particularly in cloud environments like AWS. Candidates should possess extensive experience in database administration, SQL performance tuning, and familiarity with enterprise data warehouse platforms. Preferred qualifications include experience with IBM DataStage and Cognos, as well as knowledge of healthcare data governance. The position is remote, catering to professionals with a strong background in database management and analytics.

Key Responsibilities:

  • Administer and support DB2 databases, particularly in cloud environments (AWS preferred).
  • Optimize SQL performance and conduct query tuning.
  • Support enterprise data warehouse or analytical database platforms.
  • Implement backup, recovery, high availability, and disaster recovery strategies.
  • Work in regulated or public-sector environments as needed.

Key Skills:

  • 12+ years of experience as a Database Administrator supporting DB2 or 5+ years for DB2 Warehouse edition.
  • Strong SQL skills with experience in performance tuning and query optimization.
  • Experience with IBM DB2 Warehouse on AWS.
  • Hands-on experience with IBM DataStage and IBM Cognos for ETL and reporting.
  • Knowledge of Medicaid, healthcare claims, and data governance requirements.
  • AWS experience with services such as EC2, S3, IAM, and CloudWatch.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

12+ years of experience as a Database Administrator supporting DB2 or 5+ 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

Preferred Qualifications

Experience with IBM DB2 Warehouse on AWS

Hands-on experience working with IBM DataStage 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, CloudWatch, and networking concepts

Apply
Similar Jobs
Loading data...