Jobiglo

No results.

DB2 DBA – Application Support (Singapore)

Encora · Singapore

New
🇬🇧 English
DB2 SQL JCL VSAM mainframe storage database utilities backup and recovery database design statistics

Job description

About the role

The role involves supporting application teams by managing and optimizing DB2 databases. You will work closely with developers to ensure high-performance, reliable data access for new and existing features.

Key responsibilities

  • Review and optimise SQL queries written by application developers to ensure optimal performance and adherence to database standards.
  • Assist in database design activities, including table structures, indexes, and relationships to support new application features or enhancements.
  • Troubleshoot database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns.
  • Support database changes through the development lifecycle (DEV, TEST, UAT, PROD) and coordinate object migrations between environments.
  • Monitor application database performance and implement tuning measures such as reorganising tablespaces, updating statistics, and adjusting buffer pools.
  • Provide guidance to developers on DB2 best practices, coding standards, and efficient query writing techniques.
  • Assist application testing activities by handling data refresh requests, preparing test data, and validating database-related test cases.

Required profile

  • Strong background in IT, Computer Science, Computer Engineering or a related discipline.
  • Minimum of 5 years of relevant experience working with DB2 and related technologies.
  • Experience with JCL, VSAM, mainframe storage concepts, database utilities, and backup/recovery procedures is advantageous.

Required skills

  • DB2 database administration.
  • SQL query optimisation.
  • JCL (Job Control Language).
  • VSAM and mainframe storage concepts.
  • Database utilities and tools.
  • Backup and recovery procedures.
  • Database design, indexing, tablespace management, statistics, and buffer pool tuning.

Questions fréquentes

Le salaire n'est pas communiqué publiquement par le recruteur. Vous pouvez postuler et négocier directement avec Encora.
Cliquez sur "Postuler maintenant" en haut de la page. Vous pouvez importer votre CV en 1 clic — Jobiglo extrait automatiquement vos informations et postule pour vous.
Source : ats:greenhouse

Why are you reporting this job?

Thank you for your report. We will review this job.

Explore further

Salaries, guides and searches in Singapore.

Apply in 30 seconds

Enter your email to apply. An account will be created automatically.

By continuing, you accept our terms of use.

Already have an account? Login

💬 Chat with us on Telegram Chat on WhatsApp

Published 5 hours ago

Expires 1 month from now

4 views · 0 interested

Boost your chances

Upload your CV — we will match you with relevant openings.

Analyzing your CV...

Encora

Singapore