IBM DB2 Mainframe (Z/OS) DBA

IBM DB2 Mainframe (Z/OS) DBA

Location : Hyderabad

Mode: Hybrid

Key Responsibilities:

• Knowledge of BSDS, Log copies, ZPARMS, Buffer-pool Managements, Storage, Thread, Locks, ZFS file systems
• Change Management process & versioning tools.
• DB2 system tools, catalog reorgs, query monitor.
• DB2 for z/OS, RACF/Top-Secret, TSO, SMS
• Good Understanding of Catalog and Directory,
• Hands on experience of application DBA side with various DB2 Utilities both online and offline like IDCAMS, COPY, RECOVER, CHECK DATA, REORG, RUNSTATS, REBUILD, LOAD/UNLOAD, DSNJU003, DSJU004 etc.
• Hands on experience on DB2 tools: DB2 Admin Tool, Log Analysis Tool, Object Comparison Tool, Query Monitor Tool, Automation Tool HPU, IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z OS etc.
• DB2 DBA activities including DDL/DML operations like creating new objects, modify existing objects structures, grant/revoke privileges. Hands on experience of DB2 object changes and handling related impact.
• Understand, write, tune and understand the performance implications of DB2 SQL, application environments & stored procedures.

Good to have skills

• DB2 Subsystem Setup in Sysplex distributor DDF, RRSAF, Data Sharing Group concepts and Cross Coupling Facility. == good to have
• power designer tool for designing == good to have

Education:

• Graduate Bachelors degree (Engineering preferred)
• Preferred certifications: IBM DB2 Database Administration on Z/OS platform

Other:

• Flexibility, sound technical skills, high aptitude, positive attitude, strong inter-personal skills, excellent communication, and time management skills

Competencies:

• Make sound business decision
• Embrace Change
• Build strong Partnership
• Get results
• Act Strategically
• Lead & cultivate talent