IntersoftKK

IT services for financial institutions

Db2 Database Administrator z/OS

Database AdministrationConfirmed live in the last 24 hours

Full-timeBengaluru, Karnataka, IndiaNo salary listedIn-person

About the Job

Requirements

Must have experience as a production support Database Administrator.
Must have problem-solving and analytical skills.
Must have experience creating database objects, including tablespaces, tables, views, and indexes, and coordinating with application teams on design issues.
Must have experience with IBM Db2 utilities and commands, including unload, reload, copy, recover, reorganization, and run statistics.
Must have experience with Db2 performance tuning and recovery.
Must have experience with File-AID, QMF, SPUFI, and Platinum tools, including Log Analyzer, Database and Plan Analyzer, RC Tools, Detector, and Subsystem Analyzer.
Must have exposure to mainframe skills including JCL and VSAM.
Must have experience with Db2 upgrades, database monitoring, health checks, housekeeping, and disaster recovery drills.
Must have Db2 UDB DBA/LUW expertise with version 9.5 on Linux, including utilities, routine load/import/export tasks, performance tuning from application and system perspectives, migration and upgrade concepts, diagnostic log review, fix pack patches and maintenance, database backup and recovery, disaster recovery, server health monitoring, and housekeeping.
Must have IMS DBA experience with HISAM, HIDAM, and HDAM databases; IMS utilities and commands; database recovery using DBRC; database backout; Pointer Checker; MFS; DBD, PSD, and ACBGEN activities; IMS Compression and Randomizer Module; RECON maintenance, recovery, and batch backout.
Must be able to support application teams in resolving high-severity incidents, refresh databases, monitor database space, and implement space changes.

Responsibilities

Create database objects, including tablespaces, tables, views, and indexes, and coordinate with application teams on design issues.
Perform database monitoring, health checks, and housekeeping.
Conduct disaster recovery drills and database recovery activities.
Perform Db2 UDB routine tasks, including load, import, and export; upgrades, fix pack patches, and maintenance; backup and recovery; performance tuning; and database and server health monitoring.
Perform IMS database recovery, backout, RECON maintenance, batch backout, and database refresh activities.
Help application teams resolve issues during high-severity incidents.
Monitor database space and implement space changes.

Job Description

1. DB2 DBA on z/OS (Primary Skill)

• Must be a production support DBA

• Good in problem solving & analytical Skills

• Creating Database objects, Tablespaces, Tables, Views, Indexes etc. and coordinating with application team for design related issues

• Experience on followings

o IBM DB2 Utilities, Commands

 UNLOAD, RELOAD, COPY, RECOVER, REORG & RUNSTATS

o DB2 Performance Tuning

o Recovery

o Tools like File Aid, QMF, SPUFI

o Platinum tools

 Log Analyzer

 Database & Plan Analyzer

 RC Tools

 Detector

 Subsystem Analyzer



• Good exposure onmainframe skills like JCL, VSAM

• Experience on DB2 Upgrades

• Database monitoring, health check, housekeeping

• Knowledge/experience with DR (Disaster Recovery) drill

2. DB2 UDB DBA/LUW (Secondary Skill)

• Expertise on V9.5 on linux

• Able to perform db2 utilities

• Able to write scripts for performing house-keeping activities

• Performance tuning from both application perspective and system

• Able to perform routine task like load/import/export

• Understands db2 migration/upgradation concepts

• Check diaglog for any issues

• Database upgrades, Fix pack patches and maintenance

• Db2 migration/upgradation

• perform routine task like load/import/export

• Database performance and overall server health check and monitoring

• Database backup & recovery

• Disaster Recovery

• Provide support to application team

• House-keeping activities

3. IMS DBA on z/OS (Secondary Skill)

• HISAM, HIDAM, HDAM Databases

• IMS Utilities, Commands

• Database recovery using DBRC

• Database Backout

• Pointer Checker

• MFS

• DBD, PSD, ACBGEN & related activities

• IMS Compression/ Randomizer Module

• RECON Maintenance, Recovery & Batch backout

• Helping application team to fix their issue during high severity incidents

• Database refresh

• Monitor Space for the databases and implement the space changes

Qualifications

Additional Information

All your information will be kept confidential according to EEO guidelines.

About the Company

IntersoftKK

IT services for financial institutions

IntersoftKK is a global IT services company focused on banking, wealth management, insurance, and investment banks, while also serving telecom, pharma, and manufacturing clients. Its offerings include risk management and regulatory compliance software along with services to implement, integrate, and support these solutions. The company differentiates itself by specializing in financial services with targeted risk and compliance capabilities and a global delivery footprint. Its goal is to create a superior work environment and align clients, employees, and partners as a harmonized team to help everyone reach their aspirations.

Company size: 51-200
Company stage: Not listed
Total funding: Not listed
Headquarters: Tokyo, Japan
Founded: 1999

Recently Posted Jobs

Explore more opportunities at IntersoftKK

See more jobs