Database Administrator (DB2)Database Administrator (DB2)

ELLIOTT MOSS CONSULTING PTE. LTD.; Dublin; On-site; EUR 90,000 - 130,000; Full time

Job summary

Elliott Moss Consulting Pte. Ltd. seeks an experienced Application DBA specializing in Mainframe DB2 on z/OS to manage and optimize databases in production and non-production environments.

The role emphasizes setup, maintenance, backups, performance tuning, and governance-aligned data migration to flat files using scripts or mainframe tools.

Qualifications

• Minimum 4+ years as a Mainframe DB2 on z/OS Database Administrator.
• Strong DB2 for z/OS administration, support and maintenance experience.
• Hands-on data migration from Mainframe DB2 on z/OS to flat files.
• Experience with backup, recovery and disaster recovery planning.
• Knowledge of data modeling and SQL performance tuning.

Responsibilities

• Administer and support Mainframe DB2 on z/OS databases in production and non-production environments.
• Perform database setup, configuration, maintenance, backup, recovery, and disaster recovery activities.
• Plan and execute database migrations, including migration of data from Mainframe DB2 on z/OS to flat files using scripts or mainframe tools.
• Monitor database performance, availability, and capacity; proactively identify and resolve issues.
• Analyze and tune SQL queries and database objects to improve application performance.
• Review database designs and recommend improvements to data models based on business and application requirements.

Skills

Mainframe DB2 on z/OS

DB2 for z/OS administration

SQL performance tuning

Data migration to flat files

Backup & recovery

Disaster recovery planning

Data modeling

Job description

Job Description

• We are seeking an experienced Application Database Administrator (DBA) with strong expertise in Mainframe DB2 on z/OS administration and data migration.
• The role is responsible for database setup, administration, performance monitoring, backup and recovery, database design reviews, SQL tuning, and operational support.
• The ideal candidate will have hands-on experience in migrating data from Mainframe DB2 on z/OS to flat files using scripts or tools within the mainframe environment and ensuring database reliability, performance, and compliance with governance standards.

Key Responsibilities

• Administer and support Mainframe DB2 on z/OS databases in production and non-production environments.
• Perform database setup, configuration, maintenance, backup, recovery, and disaster recovery activities.
• Plan and execute database migrations, including migration of data from Mainframe DB2 on z/OS to flat files using scripts or mainframe tools.
• Monitor database performance, availability, and capacity; proactively identify and resolve issues.
• Analyze and tune SQL queries and database objects to improve application performance.
• Review database designs and recommend improvements to data models based on business and application requirements.

Required Skills & Experience

• Minimum 4+ years of experience as a Mainframe DB2 on z/OS Database Administrator.
• Strong expertise in DB2 for z/OS database administration, support, and maintenance.
• Hands-on experience in data migration from Mainframe DB2 on z/OS to flat files using scripts, utilities, or mainframe tools.
• Experience with database backup, recovery, disaster recovery planning, and implementation.
• Strong knowledge of database design, data modeling, and SQL performance tuning.
• Experience in database monitoring, troubleshooting, and performance optimization.