DB2 Specialist - IDAA Systems Programmer

LOCATION:CHENNAI/BENGALURU

DB2 Specialist - IDAA Systems Programmer

Key Responsibilities:

o IDAA Installation & Management: Install, configure, and maintain IDAA using tools like GUI Management Console, Data Studio, and Admin Services.

o Data Synchronization: Manage and troubleshoot Db2-IDAA data sync for optimized query performance.

o IDAA Loader Administration: Install, configure, and maintain IDAA Loader for efficient data processing.

o Storage & Performance Optimization: Reallocate storage, improve system efficiency, and prevent slow SQL queries.

o System Administration: Perform admin tasks using Putty and Unix System Services (USS).

o Upgrades & Maintenance: Conduct IDAA loader and system maintenance upgrades to ensure stability and security.

Required Technical and Professional Experience

o 7+ Yrs Experience in IBM Db2 Analytics Accelerator (IDAA) to manage, optimize, and maintain the system.

o Strong expertise in DB2 database administration and IDAA installation & optimization.

o Experience with query acceleration, performance tuning, and storage management.

o Proficiency in IDAA data synchronization and loader management.

o Knowledge of Putty, Unix System Services (USS), and mainframe environments (z/OS).

o Ability to troubleshoot performance bottlenecks and optimize complex SQL queries.

o DB2 & IDAA Expertise Proven experience in IDAA installation, configuration, and query optimization.

o Familiarity with SMP/E installation, storage reallocation, and system security.

o Ability to diagnose and resolve performance bottlenecks affecting query execution.

o Exposure to IBM Infosphere Data Replication (CDC) for IMS.

Preferred Technical and Professional Experience

o Experience with Omegamon, IBM Control Center, and Tivoli monitoring tools.

o Knowledge of disaster recovery planning and IDAA system upgrades.

o Familiarity with automation scripting for monitoring and issue resolution.