22 Mainframe Db2 Jobs

Dear Candidate, Please find below Job Descrption Role :- SQL Developer Mainframe + Data migration + DB2 or Mainframe + Data + Migration + SQL+ Server or Mainframe +Data migration + HCOSS 7+ years of experience in SQL development and database management. Own and drive the end-to-end data migration process from Mainframe DB2 to GCP. Analyze existing DB2 data structures, stored procedures, and ETL processes. Design and implement scalable, secure, and efficient data models. (BigQuery, Cloud SQL, etc.). Develop and optimize SQL scripts for data extraction, transformation, and loading (ETL). Develop, test, and optimize SQL queries for performance, scalability, and maintainability. Collaborate with infrastructure, cloud engineering, and business teams to ensure data integrity and performance. Monitor and troubleshoot data migration pipelines and resolve data quality issues. Proven experience in cloud data migration projects Document data mappings, and technical specifications. Strong understanding of query execution plans, indexing, and optimization techniques. Ensure compliance with data governance, security, and privacy standards. Excellent analytical, communication, and documentation skills. Regards Divya Grover +91 8448403677

About Client Hiring for One of the top most MNC!! Job Description Job Title: Mainframe Developer/Mainframe DB2/Mainframe Storage Admin Qualification : Any Graduate or Above Relevant Experience : 4 to 10 Years SKILL Should be stronghold on Mainframe & Database Architecture. Should be expertise in Mainframe Database concepts Should be dealing with various vendors & application team and troubleshoot the application Issues. Should hold the hands-on knowledge in Mainframe Database offline & online Utilities. Hands-on experience in ISV tools like BMC and CA products. Hands-on experience Mainframe Db2 System Upgrades and Migration activities. Hands-on experience in SMP/e tools. Basic understanding in DR concepts and the DBA role in the DR activities. Should have strong knowledge on JCL and their various concepts. Should have the experience on Performance monitoring and the tools. In depth Knowledge on ITIL processes like Incident management, Problem Management, Configuration management and Change Management processes. Candidate should have been in a customer facing role with excellent communication skills. Strong technical knowledge and eagerness to learn new technologies. Location : Pune,chennai,Hyderbad,Kolkata,Bangalore CTC Range : 20 LPA TO 30 LPA Notice period : ANY Shift Timing : N/A Mode of Interview : VIRTUAL Mode of Work : WORK FROM OFFICE Vardhani IT Staffing Analyst Black and White Business solutions PVT Ltd Bangalore, Karnataka, INDIA. 8686127477 I vardhani@blackwhite.in I www.blackwhite.in

Mainframe DB2 DBA Skills required : A. Database Object Creation and Maintenance : 1. Create, Alter various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes etc. 2. Knowledge and expertise on DB2 utility execution. B. Data load and migration : 1. Knowledge and understanding of data migration process from VSAM to DB2. 2. Unload data from DB2 tables using UNLOAD utility. 3. Load data from files to Tables using LOAD utility. 4. Unload data from Image copy using UNLOAD or other utilities. 5. Migrate data from one environment to another. C. Database backup and Recovery : 1. Setup and maintain Image Copy and other DB2 housekeeping jobs. 2. Able to recover data from Image Copy using RECOVER utility. D. Database access and security control : 1. Follow the security and audit control procedures to GRANT/REVOLKE permissions on database objects. 2. Understand and provide Group level access on DB2 objects to RACF user groups. E. Support to Application team : 1. Monitor and troubleshoot batch job failures. 2. Handle and resolve all DB2 package related consistency token issues. 3. Assist application team to resolve performance issues for the SQLs and/or Stored procedures. F. Performance monitoring and tuning : 1. Monitor current active and historical threads using DB2 monitoring tool. 2. Identify potential bottleneck, lock contention in the active or historical threads and troubleshoot them. 3. Check overall Mainframe CPU utilization using SYSVIEW online panels. 4. SQL tuning by rewriting the SQLs or designing appropriate indexes.

Role & responsibilities Design, code, test, and debug mainframe applications using COBOL, JCL, CICS, and DB2. • Maintain and enhance existing mainframe applications. • Analyze business requirements and translate them into technical solutions. • Perform impact analysis, code reviews, and unit testing. • Participate in system integration and user acceptance testing. • Troubleshoot production issues and provide support as needed. • Document technical designs and operational procedures. • Collaborate with cross-functional teams including business analysts, QA, and infrastructure teams. Preferred candidate profile 6 to 8 Years of experience. Professional experience in Mainframe COBOL, IBM z / OS tools . Ability to analyze existing applications code and to create with working flow documentation. Ability to establish a technical test book. Ability to understand and take ownership of a DB2 data model.

Experience: 4 to 7 years experienced in administration/implementation/configuration of IBM ZoS Mainframe systems Location : Chennai Skills Overview: Experience in Managing ZoS system Administration. Handling LPAR management Handling IPLs for Systems Resource Management Experience in RACF Experience in REXX programs Experience in TSO and ISPF modules Managing Mainframe subsystems Handling Mainframe storage support Experience in SMF Policies and Configuration Installing Software or hardware in ZOS Handling System Performance queries

7 to 12 years experience in Mainframe development Hands-on coding experience in PL/1, JCL and DB2 Knowledge in Insurance domain Knowledge in Agile development methodologies knowledge / experience Good Communication skills Code development and maintenance experience. Knowledge in Agile development methodologies knowledge / experience Demonstrates good analytical and systematic approach to problem solving. Understands and uses appropriate methods, tools and applications. Willingness to continuously learn and upgrade the skills.

Administers and optimizes DB2 databases on mainframes.

The Mainframe DB2 - Application Development role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the Mainframe DB2 - Application Development domain.

The Mainframe DB2 - Application Development role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the Mainframe DB2 - Application Development domain.

The Mainframe DB2 - Application Development role involves working with relevant technologies, ensuring smooth operations, and contributing to business objectives. Responsibilities include analysis, development, implementation, and troubleshooting within the Mainframe DB2 - Application Development domain.

More than 5+ years hands-on experience in Mainframe DB2 zOS database administration Hands on experience in DB2 Database Management area ( DB2 Z/OS DBA) with Medium to Advanced knowledge of JCL, VSAM Good analytical skills and ability to troubleshoot Analyzing Database State (both Space and Performance wise) DB2 utility (Load, Unload, Image copy, Reorg etc..) Analyzing tablespaces for space and Performance Writing queries Database Refresh from one system to another Good understanding of Agile Weekly maintenance support and incident handling This position will work on - Small infrastructure type of projects in databases. Ensuring round the clock availability of databases and tables. Work on user requests and tickets. Weekly maintenance process for backup and recovery. DDL and DML Performance tuning.

Position: Manager Min 8+ years experience Location: ANYWHERE IN INDIA INTERESTED CANDIDATES PLEASE SHARE YOUR RESUME TO LAVANYA.KUMARESAN@COGNIZANT.COM Technology M/F, ODBA, SQL DBA, M/F DBA, App Support, Incident Management, etc DB2 System DBA Mainframe (System programmer ) Candidates should possess strong knowledge on Mainframe DB2 v12, v13 Database System Programming/Administration. Requires 24x7 support experience in a large production environment. Excellent skills on customizing IBM Db2 products(Db2 Admin tool, Log analysis tool, Omegamon for DB2 Performance Expert, High Performance Unload, Query Monitor, Db2 Sort, Syncsort, ) Excellent Verbal and written communication skills. Good interpersonal Skills. The candidate should have worked in a SLA driven environment. Ability to work in a flexible, team-oriented and constantly changing environment Tools and Technologies : z/OS, SMP/E, SMS, DB2, Db2 Admin tool, Log analysis tool, Omegamon for DB2 Performance Expert, High Performance Unload, Query Monitor, Db2 Sort, Syncsort, DB2Connect. System DBA role as following: Install new, upgrade, migrate, consolidate and configure database Systems, services, settings, storage, etc. in accordance with standards and project or operational requirements. Maintain installation and configuration procedures. Excellent skills on CA b2 products to IBM DB2 products(Log Analysis, Db2 admin tool, Db2 Query Monitor, Omegamon for Db2, High performance unload, Synsort, Db2 Sort) migration. Experience in converting CA Log analyzer report jobs to IBM Log analysis report jobs. Support incident management processes including responding to alerts, 24x7x365 on-call and root cause analysis. Repair and recover from hardware or software failures. Coordinate and communicate with impacted constituencies through contacts with application support and Technical Operations Center Maintenance role as following, Apply database patches and upgrades on a regular basis, and upgrade Database administrative tools and utilities. Configure / add new services as necessary to maintain control, security and stability. Assist in deployment, roll-out and maintenance of applications per project or operational needs. Perform ongoing performance tuning, and resource optimization as required. Configure databases memory, and disk, and IO as required.

Role & responsibilities Design, code, test, and debug mainframe applications using COBOL, JCL, CICS, and DB2. • Maintain and enhance existing mainframe applications. • Analyze business requirements and translate them into technical solutions. • Perform impact analysis, code reviews, and unit testing. • Participate in system integration and user acceptance testing. • Troubleshoot production issues and provide support as needed. • Document technical designs and operational procedures. • Collaborate with cross-functional teams including business analysts, QA, and infrastructure teams. Preferred candidate profile 6 to 8 Years of experience. Professional experience in Mainframe COBOL, IBM z / OS tools . Ability to analyze existing applications code and to create with working flow documentation. Ability to establish a technical test book. Ability to understand and take ownership of a DB2 data model.

Job Title: Data Warehouse Developer Mainframe Specialist Experience: 4+ Years Location: Pan India Employment Type: Full-time Job Summary: We are seeking a Data Warehouse Developer with strong experience in mainframe-based data processing and ETL development. The ideal candidate will have a solid understanding of DWH concepts and hands-on experience working with mainframe technologies to support large-scale data integration and reporting solutions. Key Responsibilities: Design, develop, and maintain ETL workflows using mainframe tools and technologies (e.g., JCL, COBOL, DB2). Perform data extraction, transformation, and loading from legacy systems into enterprise data warehouses. Collaborate with business analysts and data architects to understand data requirements and deliver scalable solutions. Ensure data quality, consistency, and performance across large datasets. Participate in performance tuning, troubleshooting, and production support activities. Primary Skills: Mainframe Technologies: JCL, COBOL, DB2 (hands-on) Data Warehousing: Strong understanding of DWH concepts and architecture Good to Have: Experience with ETL tools like IBM DataStage or Informatica Familiarity with scripting (Unix) and modern languages (Python) Exposure to orchestration tools like Apache Airflow Preferred Qualifications: Experience in Agile development environments Exposure to cloud-based data platforms is a plus Strong analytical and communication skills Role & responsibilities Preferred candidate profile

Mainframe DB2 DBA DB2 Database Administration Good articulation skills Ability to drive Incident Calls

Who We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The Role As a Mainframe DB2 System Programmer SME at Kyndryl are project-based subject matter experts in all things infrastructure – good at providing analysis, documenting and diagraming work for hand-off, offering timely solutions, and generally “figuring it out.” This is a hands-on role where your feel for the interaction between a system and its environment will be invaluable to every one of your clients. There are two halves to this role: First, contributing to current projects where you analyze problems and tech issues, offer solutions, and test, modify, automate, and integrate systems. And second, long-range strategic planning of IT infrastructure and operational execution. This role isn’t specific to any one platform, so you’ll need a good feel for all of them. And because of this, you’ll experience variety and growth at Kyndryl that you won’t find anywhere else. You’ll be involved early to offer solutions, help decide whether something can be done, and identify the technical and timeline risks up front. This means dealing with both client expectations and internal challenges – in other words, there are plenty of opportunities to make a difference, and a lot of people will witness your contributions. In fact, a frequent sign of success for our Infrastructure Specialists is when clients come back to us and ask for the same person by name. That’s the kind of impact you can have! This is a project-based role where you’ll enjoy deep involvement throughout the lifespan of a project, as well as the chance to work closely with Architects, Technicians, and PMs. Whatever your current level of tech savvy or where you want your career to lead, you’ll find the right opportunities and a buddy to support your growth. Boredom? Trust us, that won’t be an issue. Your future at Kyndryl There are lots of opportunities to gain certification and qualifications on the job, and you’ll continuously grow as a Cloud Hyperscaler. Many of our Infrastructure Specialists are on a path toward becoming either an Architect or Distinguished Engineer, and there are opportunities at every skill level to grow in either of these directions. Who You Are You’re good at what you do and possess the required experience to prove it. However, equally as important – you have a growth mindset; keen to drive your own personal and professional development. You are customer-focused – someone who prioritizes customer success in their work. And finally, you’re open and borderless – naturally inclusive in how you work with others. Required Technical and Professional Experience 9 to 14 Years of Experience in Mainframe DB2 System Programming. Experience and Expertise in Monoplex, SYSPLEX architecture and data sharing architecture. Experience in DB2 subsystem setup - both Stand-alone and data sharing. Experience in DB2 backup and recovery scenarios - traditional image copy, FLASH, mirroring etc., methodology. Experience in REXX/CLIST and ISPF programming skills. Good knowledge on transactional environment like CICS, IMS architecture and interface with DB2. DB2 Data sharing skills - Installation, customization, DB2 structures, CFRM policy, DB2 CF recovery, Data sharing locking mechanism etc. Experience and good exposure to SMP/E process. Experience and Expertise on software migration and maintenance procedures - Install, backout, re-migration process - DB2 V9, V10, and V11. Good Knowledge on DB2 Health check, DB2 security and Patch management. Good knowledge and experience on DB2 traces, SMF, RMF and WLM. Good Knowledge on z/OS and DB2 system performance tuning methods. Preferred Skills and Experience •Bachelor’s degree in computer science or a related field. •Experience in DB2 Connect and IBM Data Studio •DB2 Cloning process - IBM DB2 Cloning Tool or any customized in-house Tools. • Good knowledge on SYSPLEX, data sharing and distributed problem-solving skills. • Experience in problem debugging and Vendor specific PMR ticketing procedure. Being You Diversity is a whole lot more than what we look like or where we come from, it’s how we think and who we are. We welcome people of all cultures, backgrounds, and experiences. But we’re not doing it single-handily: Our Kyndryl Inclusion Networks are only one of many ways we create a workplace where all Kyndryls can find and provide support and advice. This dedication to welcoming everyone into our company means that Kyndryl gives you – and everyone next to you – the ability to bring your whole self to work, individually and collectively, and support the activation of our equitable culture. That’s the Kyndryl Way. What You Can Expect With state-of-the-art resources and Fortune 100 clients, every day is an opportunity to innovate, build new capabilities, new relationships, new processes, and new value. Kyndryl cares about your well-being and prides itself on offering benefits that give you choice, reflect the diversity of our employees and support you and your family through the moments that matter – wherever you are in your life journey. Our employee learning programs give you access to the best learning in the industry to receive certifications, including Microsoft, Google, Amazon, Skillsoft, and many more. Through our company-wide volunteering and giving platform, you can donate, start fundraisers, volunteer, and search over 2 million non-profit organizations. At Kyndryl, we invest heavily in you, we want you to succeed so that together, we will all succeed. Get Referred! If you know someone that works at Kyndryl, when asked ‘How Did You Hear About Us’ during the application process, select ‘Employee Referral’ and enter your contact's Kyndryl email address.

Role: Mainframe Database Admin Experience: 9+ Years Location: Bangalore Description Mainframe Computing (MC) is a technology enabler for the business by providing a strong, resilient, and stable platform to host and enable business innovation/growth in our lines of business and global locations. MC consists of experienced administration, operations and engineering staff required to support the platform. In addition to flexible hours, the Firm enables its staff to work remotely. The mainframe engineers work with the latest hardware and software technologies. There is extensive interoperability between the mainframe and non-mainframe platforms. Responsibilities and Team Info The mainframe communicates with software running on Linux and Windows server environments. Likewise, our clients have extensive use of data on the mainframe via this interoperability. This role is for an administrator of distributed (non-mainframe) software and its configuration for interoperability to the mainframe-based databases. In addition, the role involves overseeing paths out of the mainframe to open systems-based databases. Responsibilities include: Update and maintain driver software for mainframe database (ADABAS, DB2) access. Trace, collect and maintain inventory of inbound and outbound IP traffic to selected distributed/non mainframe databases (DB2 on Linux, Sybase Greenplum). Monitor inbound/outbound traffic for performance opportunities. Load balancing, port sharing etc. Track and enforce security standards (TLS/SSL SLL, Kerberos,) for mainframe database access. Refresh and update entitlements for mainframe database access on schedule. Implement database turnover requests for all APG groups and application for all environments. Perform verification for database maintenance upgrades of driver software. Execute Weekend verification involving the running of the IVP/RFB and weekend checkouts for infrastructure on and off mainframe. Preparing for, coordinating, writing up and communicating the summary of the weekend work. Qualifications- Technical Skills / Environment 10+ years Desired IBMs Data Virtualization Manager (DVM). Database (DB2/UDB, Sybase, Greenplum, MySQL, SQL server.) IBMs JGATE middleware. USS environment. TLS/SSL, Encryption protocols. Port Security administration. Strong mainframe access methodologies. JavaScript, JSON formats. Python Programming. Restful APIs? Linux- Mainframe X-team integration skills. Linux/Unix, Shell scripting Networking protocols - TCP/IP, UDP, HTTP. Port Security administration. Assets ADABAS database on mainframe IBM’s z/OS Operating system and Tools (ISPF,TSO,SDSF,JCL) FTP,Rexx. DB2 on mainframe Agile development, SDLC, DevOps best practices Task management using JIRA. Minimum EDUCATIONAL and EXPERIENCE REQUIREMENTS University Degree (B.S.) and at least 5 years technical experience Experience with Project Management and Agile preferred Data analysis and manipulation Scripting/coding experience a plus Weekend shift and on call rotation required.

Install, update, and administer Mainframe CICS products; Installing, upgrading, maintaining IBM CICS/MQ and related ISV products such as BMC MAPR, IBM tools(Fault Analyzer, Debug Tool); Monitoring of CICS regions, CICS Region Build, CICS regions monitoring using tools like Mainview, Omegamon; CPSM install and CICSplex WorkLoad balancing and high availability; Perform changes within company regulations and security standards; Assist with testing, implementation, and installation of new/improved systems, as well as product upgrades; Attend meetings and interact regularly with management, team, and clients to continuously improve services; Participate in On-Call rotation schedule. Knowledge on administration tasks using various CICS Commands; Good-to-Have CICS Level 3 System Program Skills; JCL, ISPF, and SMP/E proficiency; z/OS System level Skills; 1.Initialize/Add new DASD volumes and Add new tape volumes. Perform the space management activities such as VTOC resizing, Defrag, Compress/Reclaim/Release/Cleaning of datasets. 2.Manage and Define SMS rules and ACS routines. 3.Manage and Maintaining DFHSM & Catalogs. 4.Storage dataset (RMM/HSM CDS & Catalog file) reorganization. 5.Disk and space management. 6.Experience in generating all type of storage reports, SMF and Dcollect. 7.Data/Volume level backup and restores. 8.Disaster recovery planning and performing the recovery test (Tape recovery / DASD Replication / Tape Replication / PPRC / XRC) and Managing the Copy services / GDPS. 9.Experience in Storage box data migration (DASD to DASD and Tape to tape) and Storage replication. 10.Product upgrades and configuration.(SMP/E knowledge) 11. Maintain documentation of the storage environment. Good-to-Have 1.Experience in Storage hardware subsystems including HDS 5100 2.Optica ZVT virtual tape controllers with IBM FS5200 storage devices. Kondly do not apply if already interviewed or applied

Warm Greetings from SP Staffing Services Pvt Ltd!!!! Experience:6-10yrs Work Location :Chennai Job Description: Experience in Mainframe Db2 DBA 1. Should be stronghold on Mainframe & Database Architecture. 2. Should be expertise in Mainframe Database concepts 3. Should be dealing with various vendors & application team and troubleshoot the application Issues. 4. Should hold the hands-on knowledge in Mainframe Database offline & online Utilities. Hands-on experience in ISV tools like BMC and CA products Interested candidates, Kindly share your updated resume to gokul.priya@spstaffing.in or contact number (Whatsapp:9360311230) to proceed further.

Warm Greetings from SP Staffing Services Pvt Ltd!!!! Experience:6-8yrs Work Location :Bangalore Roles and responsibility - Design, develop, and maintain mainframe applications. Collaborate with business analysts and stakeholders to gather requirements. Write and maintain high-quality code in COBOL, JCL, and other mainframe languages. Perform code reviews and provide constructive feedback to team members. Troubleshoot and resolve issues in a timely manner. Implement new features and enhancements based on business needs. Ensure the scalability and reliability of mainframe systems. Create and maintain technical documentation. Participate in system testing and quality assurance activities. Provide support and training to end-users as needed. Stay up-to-date with the latest mainframe technologies and best practices. Ability to learn new technologies and adapt to changing requirements. Collaborate with cross-functional teams to identify business requirements and implement solutions. Monitor system performance and make recommendations for improvements. Assist in the planning and execution of mainframe upgrades and migrations. Excellent communication and collaboration skills. Ability to work independently and as part of a team. Experience with Agile development methodologies. Strong attention to detail and commitment to quality. Strong problem-solving and analytical skills. Ability to manage multiple projects and priorities. Knowledge of mainframe security and compliance requirements. Experience with performance tuning and optimization. Strong organizational and time management skills. Interested candidates, Kindly share your updated resume to ramya.r@spstaffing.in or contact number 8667784354 (Whatsapp:9597467601)to proceed further.

Warm Greetings from SP Staffing!! Role: Mainframe DB2 DBA Experience Required :6 to 8 yrs Work Location :Pune/Chennai Required Skills, DB2 DBA SMP/e tools. Interested candidates can send resumes to nandhini.spstaffing@gmail.com

Position title : Mainframe System Administrator and DB2 DBA Position overview : Candidate is expected to work as Mainframe System Admin and DB2 DBA where the major deliverables would be system monitoring and troubleshooting, CICS definition setup, CICS monitoring, Production code deployment and Mainframe DB2 related routine DBA support. Nice to have skills on MQ and RACF administration. Mainframe Admin Skills required : 1. System health check and monitor system performance using monitoring tool. 2. Take proactive action to avoid any system related issue. 3. CICS definitions, transactions set up and monitoring using Monitoring tool. 4. Production code deployment using Change Management tool. 5. Monitor and troubleshoot batch job failures. 6. Proactive monitoring of disk space utilization and take necessary action to avoid space failure. 7. FTP alert set up. 8. Nice to have MQ Admin and Security Admin (RACF) skills. Mainframe DB2 DBA Skills required : A. Database Object Creation and Maintenance : 1. Create, Alter various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes etc. 2. Knowledge and expertise on DB2 utility execution. B. Data load and migration : 1. Knowledge and understanding of data migration process from VSAM to DB2. 2. Unload data from DB2 tables using UNLOAD utility. 3. Load data from files to Tables using LOAD utility. 4. Unload data from Image copy using UNLOAD or other utilities. 5. Migrate data from one environment to another. C. Database backup and Recovery : 1. Setup and maintain Image Copy and other DB2 housekeeping jobs. 2. Able to recover data from Image Copy using RECOVER utility. D. Database access and security control : 1. Follow the security and audit control procedures to GRANT/REVOLKE permissions on database objects. 2. Understand and provide Group level access on DB2 objects to RACF user groups. E. Support to Application team : 1. Monitor and troubleshoot batch job failures. 2. Handle and resolve all DB2 package related consistency token issues. 3. Assist application team to resolve performance issues for the SQLs and/or Stored procedures. F. Performance monitoring and tuning : 1. Monitor current active and historical threads using DB2 monitoring tool. 2. Identify potential bottleneck, lock contention in the active or historical threads and troubleshoot them. 3. Check overall Mainframe CPU utilization using SYSVIEW online panels. 4. SQL tuning by rewriting the SQLs or designing appropriate indexes. Role & responsibilities Preferred candidate profile