DB2 ZOS DBA (Rexx programming)

Betanxt Inc; Bengaluru; On-site; INR 2,500,000 - 6,000,000; Full time

Job summary

BetaNXT in Bengaluru seeks an experienced IBM DB2 for z/OS Database Administrator to manage databases, performance tuning, and on-call production support. You will work with mainframe environments, DB2 utilities, and third-party tools to ensure high availability and optimal performance.

Ideal candidates have 8–15 years of DB2 DBA experience, strong mainframe skills (JCL/TSO-SISPF/SDSF/RACF), and familiarity with BMC/CA tool suites. This is an on-site role in Bengaluru, India.

Qualifications

• 8-15 years of experience as an IBM DB2 for z/OS Database Administrator with strong DBA, performance tuning, and application support skills.
• In-depth knowledge of DB2 objects: databases, storage groups, tablespaces, tables, indexes, views/aliases, native stored procedures, triggers, and UDFs.
• Experience with DB2 schema changes to support apps; involvement in logical/physical DB design.
• Mainframe skills: JCL, TSO/ISPF, SDSF, RACF.
• Experience with third-party DB2 tools: BMC/CA tools; DB2 utilities and data migration/movement.

Responsibilities

• Perform SQL performance analysis and tuning including EXPLAIN analysis and optimizer hints.
• Monitor and optimize performance using mainframe IBM/CA/BMC tools.
• Develop automation utilities using REXX.
• Tune DB2 and system resources; conduct capacity management.
• Provide application development support including SQL guidance and issue resolution.
• Participate in 24x7 on-call rotation for production incidents.
• Manage DB2 for z/OS DDF environments and related subsystem tuning.
• Analyze DB2 locking, contention, deadlocks, and timeout issues.
• Administer DB2 utilities like REORG, RUNSTATS, COPY, LOAD, RECOVER, REBUILD INDEX.

Skills

DB2 for z/OS

Database Administration

Performance Tuning

Mainframe

JCL

TSO/ISPF

SDSF

RACF

BMC Tools

Tools

BMC DB2 Tool Suite

BMC Migrator

Log Analyzer

Detector

MainView

SPUFI

Job description

About BetaNXT: BetaNXT is a leading provider of frictionless wealth management infrastructure, real-time data solutions, and an enhanced advisor experience. We invest in platforms, products, and partnerships to accelerate growth for the ecosystem we serve. Our connective approach empowers our clients to deliver a comprehensive, end-to-end advisor and investor experience. BetaNXT is a premier provider of technology, data, and operations as services to a rich client base of wealth managers, institutional wealth firms, and digital brokers. It is comprised of three industry-leading businesses which, combined, provide end-to-end solutions across the investment lifecycle. Career Framework Job
Job Description:

Key Responsibilities

• Perform SQL performance analysis and tuning, including query optimization, EXPLAIN analysis, access path evaluation, join strategy assessment, optimizer hints (OPTHINTs), and data normalization best practices.
• Monitor and optimize application performance using tools such as BMC MainView for DB2, BMC Apptune, CA Detector, or equivalent IBM performance monitoring solutions.
• Develop and maintain automation and operational utilities using REXX programming.
• Conduct performance and capacity management activities by tuning DB2 and system resources, leveraging monitoring, reporting, and diagnostic tools.
• Provide application development support, including SQL coding guidance, performance recommendations, and DB2 issue resolution.
• Participate in a 24x7 on-call support rotation (Level 1/Level 2) covering weekdays, weekends, and critical production incidents.
• Support DB2 for z/OS Distributed Data Facility (DDF) environments, including distributed workload management, stored procedure performance tuning, and DDF-related subsystem parameter optimization.
• Analyze and resolve DB2 locking and concurrency issues, including lock escalations, lock contention, deadlocks, and timeout situations across page, row, table, tablespace, and system levels.
• Manage and troubleshoot DB2 logging environments, including active and archive logs; utilize log analysis and scanning tools to investigate performance and recovery issues.
• Administer and optimize DB2 utilities, including REORG, RUNSTATS, COPY, LOAD, RECOVER, REBUILD INDEX, and related maintenance processes.

Required Qualifications

• 8-15 years of experience as an IBM DB2 for z/OS Database Administrator, with strong expertise in database administration, performance tuning, and application support.
• In-depth knowledge of DB2 database objects and structures, including:
  • Databases
  • Storage Groups
  • Tablespaces
  • Tables
  • Indexes
  • Views and Aliases
  • Native Stored Procedures
  • Triggers
  • User Defined Functions (UDFs)
• Experience managing DB2 schema and structural changes to support application development, while participating in both logical and physical database design activities.
• Strong Mainframe technical skills, including:
  • JCL
  • TSO/ISPF
  • SDSF
  • RACF
• Hands-on experience with third-party DB2 administration and performance tools, including:
  • BMC DB2 Tool Suite
  • BMC Migrator
  • Log Analyzer
  • Detector
  • MainView
  • SPUFI
  • Equivalent IBM or CA technologies
• Proficiency with DB2 Utilities and BMC/CA utility suites.
• Experience in data migration and data movement across multiple environments (Development, Test, QA, UAT, and Production).
• Strong understanding of backup, recovery, logging, and disaster recovery strategies.
• Proven experience in problem determination, root cause analysis, and production issue resolution.
• Demonstrated analytical, critical-thinking, and problem-solving skills, particularly in high-pressure or business-critical environments.
• Understanding of ITIL processes, including Incident, Problem, and Change Management. ITIL certification is preferred.

Preferred Qualifications

• Knowledge of Informatica PowerExchange.
• Familiarity with Java, Web Services, and Service-Oriented Architecture (SOA) concepts.
• Experience working with ServiceNow, Remedy, or other IT Service Management (ITSM) platforms.