Mainframe DB2 System Administrator

4 days ago

Taguig, National Capital Region, Philippines Pan Asia Resources PH Inc. Full time

Summary of key responsibilities

· Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirements

· Recommend operating system and database performance monitoring, tuning and configuration changes

· Experience with database physical and logical design, query analysis and optimization

· Provide technical assistance and subject matter expertise to applications groups

· Provide database storage management and capacity management recommendations

· Define and manage database security and access permissions in consultation with customer

· Ensure completion of authorized Service Requests, Changes, Problem tickets

· Manage escalations and track Service Delivery and ensure SLA compliance including with vendors

· Review and update the SOP documents on regular basis

· Support in all in-flight and upcoming project activities

· Recommend and perform customer-approved database replication procedures

Years of Experience

L3 : 10+ Years of experience in Mainframe z/OS Db2 v13 Database Administration

Technical requirements

Experience in Mainframe Db2 v12/ v13 Database System-Administration on z/OS

DB2 installation, upgrade, patching, configuration and operations

Proficiency in DB2, VSAM Systems Performance Tuning and Capacity Planning

Experience in Data Sharing setup in Parallel Sysplex environment

Knowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9

Experience in SMPE and ISV tools installation and migration

Create and maintain database entities, including instances, databases, table spaces and tables

Database DR, Cloning, Backup/Recovery, HA and Point in Time Recovery (PITR) expertise

Experience with Database ISV Tools and Products like OmegaMon and AdminTool

Application related performance tuning; Write, modify, and debug database specific SQL queries

DBA related utilities like Unload, Load, DSNJU003, DSNJU004, Reorg, Runstats, image copy

REXX, CLIST, JCL, JES and Assembler knowledge

Job Types: Full-time, Permanent

Work Location: In person

  • DB2 Systems Administrator

    1 week ago

    Taguig, National Capital Region, Philippines The Pinnacle Operating System Inc. Full time ₱1,200,000 - ₱3,600,000 per year

    Technical requirementsExperience in Mainframe Db2 v12/ v13 Database System-Administration on z/OSDB2 installation, upgrade, patching, configuration and operationsProficiency in DB2, VSAM Systems Performance Tuning and Capacity PlanningExperience in Data Sharing setup in Parallel Sysplex environmentKnowledge in ACF2/RACF, CICS v5.5, Mainframe MQ v9Experience...

  • Mainframe DB2 DBA

    4 days ago

    Taguig, National Capital Region, Philippines Tata Consultancy Services Full time ₱1,500,000 - ₱2,500,000 per year

    Summary of key responsibilities:Define and provide guidance for database creation, configuration, upgrade, patches and refresh requirementsRecommend operating system and database performance monitoring, tuning and configuration changesExperience with database physical and logical design, query analysis and optimizationProvide technical assistance and subject...

  • Mainframe z/OS System Programmer

    4 days ago

    Taguig, National Capital Region, Philippines The Pinnacle Operating System Inc. Full time $100,000 - $150,000 per year

    Technical requirements· Mainframe Data Center Architecture (Metro Mirror, Global Mirror, MGM, 2/3/4 site GDPS & GDDR)· Conversant with both IBM and EMC HW and Replication methodology. Hitachi optional.· Mainframe Data Center Physical Planning and Design· Experience in IBM z14, z15 & z16 Mainframe HW and Parallel Sysplex/GDPS-GDDR Setup· Experience in...

  • Mainframe z/OS System Programmer

    1 week ago

    Taguig, National Capital Region, Philippines Pan Asia Resources Full time $100,000 - $150,000 per year

    Technical Requirements:· Mainframe Data Center Architecture (Metro Mirror, Global Mirror, MGM, 2/3/4 site GDPS & GDDR)· Conversant with both IBM and EMC HW and Replication methodology. Hitachi optional.· Mainframe Data Center Physical Planning and Design· Experience in IBM z14, z15 & z16 Mainframe HW and Parallel Sysplex/GDPS-GDDR Setup· Experience in...

  • Mainframe z/OS System Programmer

    4 days ago

    Taguig, National Capital Region, Philippines Tata Consultancy Services Full time ₱2,000,000 - ₱2,500,000 per year

    Title of Position: z/OS system programmerSummary of key responsibilitiesMinimum 10+ years of broad and in-depth hands-on technical and design/architect level experience in Mainframe z/OSExperience in a multi-site (multiple Data Center) Mainframe shop of minimum 2,000 MIPS and above.Work with Client/Customer, OEM & ISV Vendors, Business Partners related to...

  • Mainframe Operations

    2 weeks ago

    Taguig, National Capital Region, Philippines Tata Consultancy Services Full time ₱900,000 - ₱1,200,000 per year

    Years of ExperienceL1- 3-5 Years of experience in Mainframe Console Operations, Production Control and Batch Monitoring & Scheduling, PagerDutyL3– 10+ Years of experience in Mainframe Console Operations, Production Control and Batch Monitoring & Scheduling, PagerDutyTechnical requirementsGood understanding of IBM Mainframe HW, Consoles, HMC, SE, z/OS, DB2,...

  • Mainframe Storage Administrator

    1 week ago

    Taguig, National Capital Region, Philippines The Pinnacle Operating System Inc. Full time ₱900,000 - ₱1,200,000 per year

    Technical requirements· Hands-on experience with z14/z15/z16 Mainframe HW and Sysplex Setup· z/OS v2.x, JES2, DFSMS, VTAM, RACF/ACF2, TCP/IP, OMVS, RMF/SMF· SMP/E, various ISV products, UserMods and Exits.· IPL/POR procedures, various Mainframe Consoles· Mainframe Tools – OMEGAMON, TEPS, Netview, SIEM· Assembler, REXX, JCL and CA-OPS/MVS...

  • Mainframe Batch Scheduling and Code Promotion

    1 week ago

    Taguig, National Capital Region, Philippines Pan Asia Resources PH Inc. Full time ₱1,200,000 - ₱2,400,000 per year

    Summary of key responsibilitiesProvide 24 x 7 console monitoring of Mainframe infrastructure and Application Systems (e.g., Hardware, batch schedules, interfaces, database table spaces)Respond to console messages & alerts, and take corrective actions as requiredCarry out IPL, POR, Region BounceIBM and other OEM/ISV Vendors Coordination, Communication and...

  • Mainframe Storage Administrator

    2 hours ago

    Taguig, National Capital Region, Philippines AUMTREND PH INC Full time ₱1,440,000 - ₱2,400,000 per year

    Mainframe or z/OS Storage AdminLocation: BGC, TaguigWork Setup: Hybrid (2 days onsite/week)Salary: 75k-200k, depending on experienceSummary of key responsibilitiesManage BAU (Business as Usual) Service Delivery for Mainframe OS/Storage in a Technical CapacityWork on Daily Basis with Client/Customer Mainframe OS-Storage SMEs/PeersWork on MI (Major Incidents)...

  • Cobol Mainframe Developer

    4 days ago

    Taguig, National Capital Region, Philippines Xurpas Inc. Full time ₱60,000 - ₱80,000 per year

    Summary:As an Application Developer, you will be responsible for designing, building, and configuring applications to meet business process and application requirements using COBOL, IMS and DB2. Your typical day will involve working with cross-functional teams to develop and maintain software applications that meet customer needs and...