Mainframe DB2 DBA

2 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 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

DB2 keywords:

  • IBM DB2 system admin, IBM DB2 v12, DB2 DBA on z/OS, Mainframe DB2 system programmer, Mainframe DB2 system administrator, IRLM, LISTDEF, REORG, RECOVER, RUNSTATS, QUIESCE, IRLM, DSNJU003, DSN1LOGP, DSN1SDMP

  • Mainframe Developer

    4 days ago

    Taguig, National Capital Region, Philippines SPAC Information Technology Inc. Full time ₱900,000 - ₱1,200,000 per year

    Job Title: Mainframe DeveloperLocation: BGC, Taguig CityWork Setup: 100% OnsiteSchedule: May include night and weekend shiftsOverviewWe are looking for a Mainframe Developer with strong experience in TSO, COBOL, JCL, DB2, and SQL. The role involves designing, developing, testing, and supporting mainframe components in a structured enterprise environment.Key...

  • Mainframe Developer

    4 days ago

    Taguig, National Capital Region, Philippines SPAC Information Technology Inc Full time ₱900,000 - ₱1,200,000 per year

    Company DescriptionSPAC Information Technology, commonly referred to as IT-SPAC, is an integrated IT powerhouse specializing in talents and technology. We offer IT consulting and HR resourcing services, aiming to provide exceptional value to multinational companies and enterprises in the Philippines. Our management team consists of passionate professionals...

  • Cobol Mainframe

    4 days ago

    Taguig, National Capital Region, Philippines YONDU INC. Full time ₱900,000 - ₱1,200,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 specifications. Roles &...

  • mainframe developer

    4 days ago

    Taguig, National Capital Region, Philippines SLI Consulting Full time ₱1,100,000 - ₱1,320,000 per year

    Position: Mainframe DeveloperWork Setup: Full OnsiteLocation: BGC taguigEmployment: Project-basedRequirements:Non-Negotiable Skills:TSO, COBOL, JCL, DB2SQLKey Responsibilities include, but are not limited to:Develop system level and component level design using the Job Analysis and Solution Document as input; work with SA to support the activities...

  • Mainframe z/OS System Programmer

    2 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 developer

    2 weeks ago

    Taguig, National Capital Region, Philippines SLI Consulting Inc. Full time ₱450,000 - ₱900,000 per year

    Mainframe DeveloperNon-Negotiable Skills:• TSO, COBOL, JCL, DB2• SQLKey Responsibilities include, but are not limited to:• Develop system level and component level design using the Job Analysis and Solution Document as input; work with SA to support the activities surrounding Design.• Develop new components or enhancement of existing components using...

  • Mainframe Developer

    4 days ago

    Taguig, National Capital Region, Philippines IT-SPAC Full time ₱360,000 per year

    Non-Negotiable Skills:Mainframe Technologies: TSO/ISPF, COBOL, JCL, DB2Database & Querying: SQL (strong hands-on experience)Preferred / Nice-to-Have Skills:Operating Systems: UNIX/Linux fundamentalsTools & Utilities:File-AIDEndeavor or Changeman (or other version control tools)Expeditor or Intertest (for debugging)Abend-AID (for error resolution)SDSF, CA7 or...

  • Mainframe Developer

    4 days ago

    Taguig, National Capital Region, Philippines IT MANAGERS INC. Full time ₱1,000,000 - ₱1,200,000 per year

    Non-Negotiable Skills:TSO, COBOL, JCL, DB2SQLKey Responsibilities include, but are not limited to:Develop system level and component level design using the Job Analysis and Solution Document as input; work with SA to support the activities surrounding Design.Develop new components or enhancement of existing components using the Job Design DocumentCreate...

  • Cobol Mainframe Developer

    4 days ago

    Taguig, National Capital Region, Philippines NYGC Services, Inc. Full time ₱900,000 - ₱1,200,000 per year

    Professional & Technical Skills:Required Skill: Expert proficiency in COBOL programming language. Experience in IMS and DB2 is also a must.Strong understanding of software development life cycle (SDLC) and software engineering principles.Experience with relational databases and SQL.Experience with version control systems such as Git or SVN.Familiarity with...

  • COBOL Programmer Analyst

    2 days ago

    Taguig, National Capital Region, Philippines IT Managers Inc Full time ₱960,000 - ₱1,080,000 per year

    Required Qualifications:Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field.Minimum 3 years of hands-on experience with COBOL/DB2 development.JCL experience: 8+ years preferred.SQL experience: 4+ years.CICS experience: At least 1 year.Unix experience: 2+ years (preferred).Solid understanding of programming, system analysis,...