Mainframe Application - DB2

We are a $13+ billion global technology company, home to more than 224,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud, and AI, powered by a broad portfolio of technology services and products. HCLTech is a globally recognized leader in the Tech and IT industry, but we’ve never forgotten the startup mindset that got us here. We’ve always approached our work with an idea-first attitude because every one of our accomplishments —no matter how big or small —can be traced back to an idea’s single spark. It’s that spark —that inner drive —that sets our people apart from our competitors. It enables us not just to pull off game-changing feat after game-changing feat but to better our world in the process. We want you to find your spark. Because that’s what drives you to be better, be more and ultimately, be more fulfilled. Role- Mainframe Application Operation, DBA – DB2 and DL1 Location- Stockholm and Gothenburg, Sweden Job Type- Hybrid (2 days to travel to the office) Full-time Employment - Permanent Job summary: Mainframe Application Operation Management of a leading tech company has a global setup with members from Sweden and India to operate the Application Operation Management environment for all our Mainframe global Customers. We are handling the application operation task to handle increasing business in our area. The team works during working office hours and provides oncall support 24/7 on a regular basis. You will become a member of our Swedish team, you will be assigned to various tasks, both run-time and one time supporting shared services for our customer for technical activities related to your expertise. Mainframe Application Operation Management is part of the Mainframe area within HCLTech, with technical teams alongside us in various areas. We are responsible for the streamlining of the mainframe Application Operation Management, tools, work methods, follow up, guidance and participate in resolutions of Major Incidents in the area. Working with incident and problem solving to provide maximum availability for our customers and our mission is to give our Application Operation Management with the highest possible quality. Our solutions give the Customer premium standardization and optimization of their internal and external high availability first environments. Responsibilities Application DB2 DBA:

• Db2 utilities for z/OS
• Db2 commands
• Db2 backup and recovery
• JCL
• Db2 UTS and non-UTS tablespaces
• CA tools for job scheduling and Db2 maintenance
• Db2 database administration for z/OS
• Db2 performance tuning and monitoring tools
• Db2 encryption for z/OS
• Db2 temporal tables for z/OS
• Performing Unload/reload of tables
• DB2 tables status check/correction
• Supporting Version upgrades (pre and post change verification)
• Db2 reorgs and database maintenance
• Executing DML Queries/SQL for creation, optimization and maintenance of Db2
• Db2 backup and recovery
• Db2 data sharing
• ITIL
• Full Data Refresh of subsystems
• DB2 – Reorg and maintenance
• Restore of programs/phases from USER1/2/3

IMS (DL1) DBA:

• Experience with administration of IMS Full Function, HALDB, Fastpath databases.
• Good knowledge on Restore, Reorg, Load IMS DB.
• JCL
• DBRC
• Create and maintain DBDs, PSBs, ACBs
• CA utilities
• Dynamic allocation
• IBM IMS High performance utilities
• IMS database utilities
• IMS Fastpath utilities
• IMS unload expert
• IMS pointer checker – IBM and BMC
• IMS encryption
• OSAM / VSAM creation and maintenance
• IMS database backup and recovery
• IMS performance and tunning guide
• FM / IMS
• Concepts of storage, security and networking for z/OS
• Full IMS system refreshes

Skills : Education and / or Experience Recommended: Bachelor degree in IT Professional/Technical Competencies: Mandatory:

• Db2 database administration experience for z/OS
• IMS database administration experience
• 24/7 On-call support availability on a shift basis
• Good knowledge of troubleshooting
• Fluency in English , both orally and in writing

Personal Profile:

• Customer oriented, service minded and result driven
• Analytic skills and ability to prioritize
• Excellent social and interpersonal skills
• Goal and result oriented with an open attitude
• Continuous personal development
• Team player
• Positive attitude and high working moral.