Mainframe DB2 Administrator

2 days ago

Hyderabad, Telangana, India ADP Full time US$ 90,000 - US$ 1,20,000 per year

Candidates applying for this position should have the following experience/skills:

  • Worked in Mainframe DB2 z/OS environment for 5- 10 years. Worked with DB2 V12 and/or DB2 V13 on z/OS. Knowledge of distributed infrastructure/DB2 LUW and other RDBMS is a plus.
  • Have extensive experience in data modeling and been involved in logical and physical design of relational databases with later implementation of that design in production Mainframe DB2 environment.
  • Have extensive experience in DB2 database/tablespace partitioning schemas. Worked with large partitioned tables providing ongoing support and maintenance to ensure recoverability and availability of large databases/tablespaces. Worked with temporal tables.
  • Have extensive knowledge of best practices for performance tuning/troubleshooting and have experience with BP tuning. Provided performance tuning and closely worked with application development teams to design well performing SQL queries/processes.
  • Extensive knowledge of DB2 ZPARMs and their impact on DB2 sub-system/DB behavior
  • Worked extensively with DB2 Utilities, High Performance Unload, IBM DB2 Tools or BMC, CA, Compuware products. Knowledge of query optimization techniques using DB2 Explain, Optim Query Workload Tuner, Data Server Manager, other tools.
  • Knowledge of Omegamon for DB2 and how to troubleshoot issues using it, knowledge and ability to use other Omegamon products (MVS, CICS, etc)/RMF to help identify issues quickly or setup alerts to prevent potential issues.
  • Knowledge of COBOL, CICS, JCL, DB2 and VSAM application development, REXX, Java, JSON, etc. Have experience with Stored Procedures in COBOL, SQL/PL and demonstrate problem solving skills in Production Environment.
  • Production on-call support
  • Performed recovery on a production DB/tables
  • Worked with Capacity Planning and Storage Administration, MVS system, development groups to ensure that impact of new implementations is estimated/analyzed/benchmarked/documented before actual production implementation
  • Excellent analytical and problem solving skills. Capable of performing problem determination in a 24x7 database availability environment under pressure and solve issues quickly.
  • Ability to adapt quickly and effectively to a changing environment
  • Should have an excellent organizational skills and provide documentation for all phases of project lifecycle
  • Knowledge of DB2 Connect, IDAA is a plus
  • Reviewed, evaluated, designed, implemented and maintained company database[s].
  • Ability to identify data sources, construct data decomposition diagrams, provide data flow diagrams and document the process
  • Performed Data Analysis for DB2 database using File-aid, QMF tools.
  • Knowledge of Agile principles and DevOps. Knowledge of Rally is a plus.

  • Mainframe DB2 Database Specialist

    1 week ago

    Hyderabad, Telangana, India beBeeDatabase Full time ₹ 80,00,000 - ₹ 1,20,00,000

    Mainframe DB2 Database Expert WantedWe are seeking an experienced professional to fill the role of a Mainframe DB2 Database Administrator. The ideal candidate will possess a strong background in database administration, with hands-on experience in managing and maintaining complex mainframe databases.Knowledge of DB2 system tools, including catalog reorgs,...

  • DB2 Mainframe Professional

    6 days ago

    Hyderabad, Telangana, India beBeeDb2MainframeProfessional Full time ₹ 15,97,000 - ₹ 24,59,000

    Job Title:DB2 Mainframe Professional", "Database Administration Role for Experienced Professionals", "Key Responsibilities: Knowledge of storage management, query optimization, and system tools.Experience with DB2 subsystem setup, data sharing group concepts, and cross coupling facilities.Proficiency in database administration, including DDL/DML operations,...

  • IBM DB2 Mainframe

    1 week ago

    Hyderabad, Telangana, India ITC Infotech Full time

    IBM DB2 Mainframe (Z/OS)Location : HyderabadMode: HybridKey Responsibilities:Knowledge of BSDS, Log copies, ZPARMS, Buffer-pool Managements, Storage, Thread, Locks, ZFS file systemsChange Management process & versioning tools.DB2 system tools, catalog reorgs, query monitor.DB2 for z/OS, RACF/Top-Secret, TSO, SMSGood Understanding of Catalog and...

  • IBM DB2 Mainframe

    1 week ago

    Hyderabad, Telangana, India ITC Infotech Full time

    IBM DB2 Mainframe (Z/OS)Location : HyderabadMode: HybridKey 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...

  • IBM DB2 Mainframe

    2 days ago

    Hyderabad, Telangana, India ITC Infotech Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    IBM DB2 Mainframe (Z/OS)Location : HyderabadMode: HybridKey Responsibilities:Knowledge of BSDS, Log copies, ZPARMS, Buffer-pool Managements, Storage, Thread, Locks, ZFS file systemsChange Management process & versioning tools.DB2 system tools, catalog reorgs, query monitor.DB2 for z/OS, RACF/Top-Secret, TSO, SMSGood Understanding of Catalog and...

  • IBM DB2 Mainframe

    7 days ago

    Hyderabad, Telangana, India ITC Infotech Full time

    IBM DB2 Mainframe (Z/OS)Location : HyderabadMode: HybridKey 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, SMSGood Understanding of Catalog and Directory,...

  • IBM DB2 Mainframe

    6 days ago

    Hyderabad, Telangana, India ITC Infotech Full time

    IBM DB2 Mainframe (Z/OS) 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...

  • IBM DB2 Mainframe

    17 hours ago

    Hyderabad, Telangana, India ITC Infotech Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    IBM DB2 Mainframe (Z/OS) DBALocation : HyderabadMode: HybridKey Responsibilities:Knowledge of BSDS, Log copies, ZPARMS, Buffer-pool Managements, Storage, Thread, Locks, ZFS file systemsChange Management process & versioning tools.DB2 system tools, catalog reorgs, query monitor.DB2 for z/OS, RACF/Top-Secret, TSO, SMSGood Understanding of Catalog and...

  • Mainframe DB2 System Architect

    6 days ago

    Hyderabad, Telangana, India beBeeDatabase Full time ₹ 20,00,000 - ₹ 25,00,000

    Job Title: Mainframe DB2 AdministratorKey Responsibilities:DB2 systems and tools knowledge, including Z/OS, RACF, TSO, and SMS.Familiarity with various DB2 utilities, such as IDCAMS, COPY, RECOVER, CHECK DATA, REORG, RUNSTATS, REBUILD, LOAD/UNLOAD, DSNJU003, and DSJU004.Experience with DB2 tools, including DB2 Admin Tool, Log Analysis Tool, Object Comparison...

  • Mainframe Admin

    3 days ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Role: Mainframe Admin (Z/OS)(Required 4-8 years experience)Location: Hyderabad, Bangalore, ChennaiKey Responsibilities Serve as a subject matter expert in mainframe technologies. Provide technical expertise in the architecture, deployment, and sustainment of the mainframe architecture and various applications supported on the infrastructure. DB2 database...