DB2 LUW Database Administrator

Early Technologies
Herzliya, Israel
16 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Malvern, United States of America

Tech stack

Microsoft Windows
Agile Methodologies
IBM AIX
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Bash
Business Software
Unix
Cloud Computing
Databases
Continuous Integration
ETL
Data Recovery
IBM DB2
Linux
DevOps
Disaster Recovery
Perl
Identity and Access Management
Python
Performance Tuning
Red Hat Enterprise Linux - RHEL
Shell Script
SQL Databases
Freeform SQL
System Availability
Infrastructure as Code (IaC)
Amazon Web Services (AWS)
Cloudformation
Amazon Web Services (AWS)
Cloudwatch
Terraform

Job description

We are seeking a highly skilled Db2 LUW Database Administrator to manage, maintain, and optimize our IBM Db2 databases across Linux, Unix, and Windows (LUW) platforms. You will be responsible for ensuring database integrity, high availability, and optimal performance while partnering with development and system administration teams to support business applications. Candidates with hands-on experience managing and migrating Db2 workloads in Amazon Web Services (AWS) will be given priority consideration., * Database Management: Install, configure, upgrade, and patch Db2 LUW software across development, testing, QA, and production environments.

  • Performance Tuning: Monitor system health and optimize database configurations, buffer pools, and SQL queries to ensure maximum application efficiency.
  • High Availability & DR: Implement and maintain High Availability Disaster Recovery (HADR) and Q Replication solutions to meet strict uptime SLAs.
  • Backup & Recovery: Design, script, and execute robust backup, restore, and archiving strategies to ensure data durability and rapid point-in-time recovery.
  • Security & Compliance: Control user access, enforce data security policies, and manage database-level auditing in alignment with industry standards.
  • Capacity Planning: Analyze usage and data growth patterns to allocate storage effectively and forecast future infrastructure requirements.
  • Troubleshooting: Serve as the escalation point for complex database incidents, resolving deadlocks, connectivity issues, and performance bottlenecks.

Cloud & AWS Responsibilities (Bonus)

  • AWS Migration: Lead or assist in the discovery, planning, and migration of on-premises Db2 databases to AWS (deploying on Amazon EC2 or Amazon RDS for Db2).
  • Cloud Operations: Manage, monitor, and seamlessly scale Db2 compute and storage resources within the AWS ecosystem.
  • Service Integration: Leverage AWS-native tools for networking (VPC), storage (EBS/S3), security (IAM), and automated monitoring (CloudWatch).
  • Infrastructure as Code (IaC): Utilize Terraform or AWS CloudFormation to automate database provisioning and infrastructure deployments.

Requirements

  • 3-5+ years of hands-on experience as a Db2 LUW DBA in an enterprise environment.
  • Strong proficiency in writing and optimizing complex SQL queries.
  • Solid working knowledge of Linux/Unix operating systems (e.g., RHEL, AIX).
  • Experience with shell scripting (Bash, Python, or Perl) to automate routine database tasks.
  • Familiarity with data movement utilities (LOAD, EXPORT, IMPORT).

Preferred Qualifications

  • Relevant IBM Db2 certifications.
  • AWS Certifications (e.g., AWS Certified Cloud Practitioner, AWS Certified Solutions Architect, or AWS Certified Database).
  • Experience with Agile methodologies, DevOps principles, and CI/CD pipelines.

About the company

Early leverages Generative AI to accelerate development, enhance code quality, and speed up time-to-market. Early's AI-Agent for test code generates automated, comprehensive, cost-effective working tests, catching bugs early, expanding code coverage, and improving overall quality.

Apply for this position