Mainframe Db2 Database Administrator(Dba)

5 months ago

Bengaluru Karnataka, India FIS Global Full time

**Position Type**:
Full time
**Type Of Hire**:
Experienced (relevant combo of work and education)
**Education Desired**:
Bachelor's Degree
**Travel Percentage**:
0%
**Mainframe Db2 Database Administrator(DBA) - Bangalore/Pune/Chennai (5 to 8 yrs)**

Are you curious, motivated, and forward-thinking? At FIS you’ll have the opportunity to work on some of the most challenging and relevant issues in financial services and technology. Our talented people empower us, and we believe in being part of a team that is open, collaborative, entrepreneurial, passionate and above all fun.

**About this Team**:
Db2 DBA team on z/OS manages IBM’s Db2 databases on Mainframe. We handle tasks like database administration, performance tuning and security managements.

The team is also responsible for backup, recovery, ensuring data integrity and compliance. The DBA team play a vital role in managing these databases to meet FIS’s business needs

**What you will be doing**:

- Granting and Revoking Db2 object privileges
- Performance study and improvements along with backup, recovery, REORGS, RUNSTATS etc.
- Tuning and optimizing the complex queries for better performance
- Involved in requirement gathering for designing the physical and logical data model.
- Activities related to Db2 upgrades and Maintenance.
- Setting up IVP jobs for Db2 validations
- Creation of database objects in both development and production Environment
- Build db2 utility JCLs and tune the parms associated.
- Running utilities like copy. load. unload. reorg. run stats. Check. Repair
- Involved in changes of Db2 components. monitoring Db2 DASD. Db2 cluster Ratio etc.
- Involved in the performance monitoring using SMF, RMF and tuning.
- Tuning of SQL statements using explain and Query Monitor tools.
- Monitoring Db2 job performance through Omegamon, SYSVIEW etc.
- Provide the day-to-day support and administration activities of Db2 subsystems across various LPARS.
- Monitoring the helpdesk queues and resolve production, test, and QA tickets.
- Perform the Analysis of Db2 batch job failures across Z/OS LPARs
- Resolve the Db2 error states for all production Db2 operations across all the LPARs.
- Perform the core Db2 administration activities, performing image copies of various databases load/unload the data to/from databases, creation / rebuilding the indexes, validating the data, repairing the table spaces, Quiesce the databases, perform the lock escalations and concurrency analysis etc.
- Perform the database sizing and performing the online / offline REORG activities of various databases.
- Perform Db2 support for the 4 datacenters (12 hours on weekdays and 24 hours on weekends)
- Database performance/availability monitoring and maintenance.
- Creation and monitoring of the Db2 health check jobs and related items.
- Setting up utility jobs, test and migrate them to QA and Production regions.
- Support activities for Test Data Management process.

**What you bring**:

- Understanding on REXX, JCL
- Excellent Communication Skills.
- Creativity & Problem-solving

**What we offer you**:
An exciting opportunity be a part of World’s Leading FinTech Product MNC
A range of benefits designed to help support your lifestyle and wellbeing
A multi-faceted job with a broad spectrum of responsibilities
A modern international work environment and a dedicated and innovative team

**Privacy Statement**

FIS is committed to protecting the privacy and security of all personal information that we process in order to provide services to our clients. For specific information on how FIS protects personal information online, please see the Online Privacy Notice.

**Sourcing Model**

Recruitment at FIS works primarily on a direct sourcing model; a relatively small portion of our hiring is through recruitment agencies. FIS does not accept resumes from recruitment agencies which are not on the preferred supplier list and is not responsible for any related fees for resumes submitted to job postings, our employees, or any other part of our company.

pridepass

  • Mainframe Db2 Dba

    4 days ago

    Bengaluru, Karnataka, India Atos Full time

    **Job Applicant Privacy Notice**: **Mainframe DB2 DBA**: - Publication Date: Nov 22, 2024- Ref. No: 519283- Location: Bangalore, IN Chennai, IN**Who we are.** Together we create **reliable and responsive digital foundations** for the world’s businesses, institutions, and communities. Learn more on **Advancing what matters** **Description**: Database...

  • Mainframe DB2 System Administrator

    1 month ago

    Bengaluru, Karnataka, India Infosys Full time

    Mainframe DB2 System Admin Job DescriptionWe are seeking a highly skilled Mainframe DB2 System Admin to join our team at Infosys.Key Responsibilities:Perform mainframe database software upgrades, administration, and tuning to support DB2 environments.Establish policies and procedures for database management, disaster recovery, security, maintenance, and...

  • Mainframe DB2 System Administrator

    3 weeks ago

    Bengaluru, Karnataka, India Infosys Full time

    Mainframe DB2 System AdministratorWe are seeking an experienced Mainframe DB2 System Administrator to join our team. As a key member of our IT department, you will be responsible for the administration and tuning of DB2 environments.Key Responsibilities:Perform mainframe database software upgradesEstablish policies and procedures for database...

  • Mainframe Ims and Db2 Dba

    6 months ago

    Bengaluru, Karnataka, India Kyndryl Full time

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

  • Mainframe DB2 Sys Admin

    3 weeks ago

    Bengaluru, India Infosys Full time

    Open Position-Mainframe DB2 System Admin/System ProgrammerExperience-7-15YearsLocation-Bangalore or Chennai or Pune or HyderabadPrimary Skills:• Have 7+ years of experience ofinstalling and/or customizing software products Mainframe DB2 and/or data replication product suite• Experience working with large systems indata sharing SysPlex environment• Able...

  • Db2 Dba

    5 months ago

    Bengaluru, Karnataka, India Technology Next Full time

    **DB2 DBA (Immediate Joiner)** **Location**:Bangalore **(Hybrid 3 Days WFO)** **Tenure**:6 Months **Job Type**:Contractual **Salary**:15-16 LPA **Experience - **5 Years **Note: (**Strong written and verbal communication skills**)** **Preferred Qualifications**: - Experience with other relational database management systems (RDBMS) such as Oracle or SQL...

  • Db2 Dba

    6 months ago

    Bengaluru, India Cranium IT Inc Full time

    Skill: DB2 DBA Experience: 3 years JD: 3 Yrs Skills : Powershell Developer, DB2 DBA on LUW JD : Experience with Windows PowerShell Programming/Coding experience Strong knowledge in Windows Batch Scripting Knowledge on DB2 database administration on windows is preferred Build scripts to automate DBA tasks on windows server via writing batch files,...

  • Db2 Dba Administrator

    6 months ago

    Bengaluru, India Quess IT Staffing Full time

    **About Us** “Magna Infotech, now Quess IT Staffing, is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions...

  • Mainframe DB2 Sys Admin

    2 months ago

    Bengaluru, India Infosys Full time

    Open Position-Mainframe DB2 System Admin/System Programmer Experience-7-15Years Location-Bangalore or Chennai or Pune or Hyderabad Primary Skills: • Have 7+ years of experience of installing and/or customizing software products Mainframe DB2 and/or data replication product suite • Experience working with large systems in data sharing SysPlex...

  • Mainframe DB2 Sys Admin

    2 months ago

    Bengaluru, India Infosys Full time

    Open Position-Mainframe DB2 System Admin/System ProgrammerExperience-7-15YearsLocation-Bangalore or Chennai or Pune or HyderabadPrimary Skills:• Have 7+ years of experience of installing and/or customizing software products Mainframe DB2 and/or data replication product suite • Experience working with large systems in data sharing SysPlex environment•...

  • Mainframe DB2 Sys Admin

    2 months ago

    Bengaluru, India Infosys Full time

    Open Position-Mainframe DB2 System Admin/System ProgrammerExperience-7-15YearsLocation-Bangalore or Chennai or Pune or HyderabadPrimary Skills:• Have 7+ years of experience of installing and/or customizing software products Mainframe DB2 and/or data replication product suite • Experience working with large systems in data sharing SysPlex environment•...

  • Ims-db2 Dba On Mainframe(Z/os)

    6 months ago

    Bengaluru, India Nityo Infotech Full time

    4 months ago **Job Code**: JD-19322 **JOB DESCRIPTION**: IMS-DB2 DBA on Mainframe(Z/OS) **Experience Required**: 3 - 6 Years **Industry Type**: IT **Employment Type**: Contract **Location**: India

  • Ims-db2 Dba On Mainframe(Z/os)

    5 months ago

    Bengaluru, India Nityo Infotech Full time

    2 weeks ago **Job Code**: JD-19322 **JOB DESCRIPTION**: IMS-DB2 DBA on Mainframe(Z/OS) **Experience Required**: 3 - 6 Years **Industry Type**: IT **Employment Type**: Contract **Location**: India

  • Principal - Database Administration

    5 months ago

    Bengaluru, Karnataka, India Fidelity Investments Full time

    **Job Title : Principal - Database Administration** **The Purpose of This Role** - Provide Database Administration to Mainframe DB2 systems. Work with senior level business and technology partners to define and implement database solutions. The person will be responsible in providing Database Administration to DB2 systems. **The Value You Deliver** The...

  • Manager infrastructure services(db2 dba)

    6 days ago

    Bengaluru, India DXC Technology Full time

    Job Description:DXC offers competitive compensation and benefits, along with career growth opportunities, while prioritizing employee well-being and work-life balance. Key benefits include onboarding support, a recognition platform, flexible working hours, an Employee Assistance Program, and referral rewardsWho We AreAt DXC, we design, build, manage and...

  • Manager Infrastructure Services(DB2 DBA)

    1 week ago

    Bengaluru, India DXC Technology Full time

    Job Description:DXC offers competitive compensation and benefits, along with career growth opportunities, while prioritizing employee well-being and work-life balance. Key benefits include onboarding support, a recognition platform, flexible working hours, an Employee Assistance Program, and referral rewardsWho We AreAt DXC, we design, build, manage and...

  • Manager infrastructure services(db2 dba)

    3 days ago

    Bengaluru, India DXC Technology Full time

    Job Description:About the companyDXC offers competitive compensation and benefits, along with career growth opportunities, while prioritizing employee well-being and work-life balance. Key benefits include onboarding support, a recognition platform, flexible working hours, an Employee Assistance Program, and referral rewardsWho We AreAt DXC, we design,...

  • Manager Infrastructure Services(DB2 DBA)

    4 days ago

    Bengaluru, India DXC Technology Full time

    Job Description:About the companyDXC offers competitive compensation and benefits, along with career growth opportunities, while prioritizing employee well-being and work-life balance. Key benefits include onboarding support, a recognition platform, flexible working hours, an Employee Assistance Program, and referral rewardsWho We AreAt DXC, we design,...

  • Mainframe Db2 Dba

    5 months ago

    Bengaluru, Karnataka, India Kyndryl Full time

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

  • Manager Infrastructure Services(DB2 DBA)

    1 week ago

    Bengaluru, India DXC Technology Full time

    Job Description:DXC offers competitive compensation and benefits, along with career growth opportunities, while prioritizing employee well-being and work-life balance. Key benefits include onboarding support, a recognition platform, flexible working hours, an Employee Assistance Program, and referral rewardsWho We AreAt DXC, we design, build, manage and...