Mainframe Database Administrator

Alphaeus Pte Ltd; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Alphaeus Pte Ltd is seeking an experienced Mainframe DB2 DBA to support mission-critical applications across DEV, UAT, and Production environments in enterprise banking systems.

You will review SQL, troubleshoot issues, and collaborate with application teams to ensure performance, stability, and successful migrations in a high-demand mainframe setting.

Qualifications

• Minimum 5+ years of DB2 DBA experience in enterprise environments.
• Strong SQL tuning and performance optimization skills.
• Hands-on experience with backup, recovery, and migration processes.
• Proficiency in JCL, VSAM, and Mainframe DB2.
• Excellent communication and stakeholder management skills.

Responsibilities

• Review and optimize SQL queries for performance and scalability.
• Troubleshoot database issues, SQL errors, and performance bottlenecks.
• Support database deployments, migrations, and releases.
• Perform database tuning, statistics updates, and tablespace maintenance.
• Collaborate with application teams on database design and best practices.
• Provide production support and incident management for DB2/zOS environments.

Skills

DB2 DBA

SQL tuning

Backup and recovery

JCL

VSAM

Communication

Tools

Mainframe DB2

JCL

VSAM

Job description

We are seeking an experienced Mainframe Database Administrator (DB2 DBA) to support mission‑critical applications and databases across DEV, UAT, and Production environments. This role is pivotal in ensuring database stability, performance, and scalability in enterprise banking systems.

Key Responsibilities

• Review and optimize SQL queries for performance and scalability.
• Troubleshoot database issues, SQL errors, and performance bottlenecks.
• Support database deployments, migrations, and releases.
• Perform database tuning, statistics updates, and tablespace maintenance.
• Collaborate with application teams on database design and best practices.
• Provide production support and incident management for DB2/zOS environments.

Requirements

• Minimum 5+ years of DB2 DBA experience in enterprise environments.
• Strong skills in SQL tuning and performance optimization.
• Hands‑on experience with backup, recovery, and migration processes.
• Proficiency in JCL, VSAM, and Mainframe DB2.
• Excellent communication and stakeholder management skills.

Skills & Tools

• DB2 | SQL Tuning | Mainframe | JCL | VSAM
• Database Performance | Application Support | Production Support

Why Join Us

• Work on mission‑critical banking systems with high impact.
• Be part of a collaborative, cross‑functional team.
• Opportunity to grow into senior DBA leadership roles.