Mainframe Db2 Database Administrator(DBA)

1 month ago

Bengaluru, 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:

  • Perform the Db2 performance and tuning of Databases for all the applications across the mainframe LPARS.

  • Granting and Revoking Db2 object privileges

  • Perform the Db2 bind process for various Db2 database groups across LPARS for all the applications.

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

  • Perform Creation of databases, table spaces, tables. indexes and other Db2 objects from logical data models and worked closely with developers to design and tune the database of various business applications.

  • 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 application performance guidance for the application team.

  • Database performance/availability monitoring and maintenance.

  • Creation and monitoring of the Db2 health check jobs and related items.

  • Make sure the Database design and sizing was performed as per each application architectural design.

  • Setting up utility jobs, test and migrate them to QA and Production regions.

  • Support activities for Test Data Management process.


âWhat you bring:

  • Sound knowledge on db2 for z/os as an application DBA.

  • 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

  • Db2 Dba

    4 weeks 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,...

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

    3 weeks ago

    Bengaluru, India Nityo Infotech Full time

    IMS-DB2 DBA on Mainframe(Z/OS)Experience Required3 - 6 YearsIndustry TypeITEmployment TypeContractLocationIndia

  • Mainframe Db2 Dba

    4 weeks ago

    Bengaluru, Karnataka, India Atos Full time

    **Mainframe CICS**: - Publication Date: Apr 17, 2024- Ref. No: 511901- Location: Bangalore, IN, 560048**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** - SENIOR MAINFRAME ADMINISTRATOR DB2**Learn more about us** At Atos, we...

  • Mainframe Ims and Db2 Dba

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

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

    4 weeks ago

    Bengaluru, India Nityo Infotech Full time

    IMS-DB2 DBA on Mainframe(Z/OS) Experience Required 3 - 6 Years Industry Type IT Employment Type Contract Location India

  • Mainframe IMS and DB2 DBA

    2 days ago

    Bengaluru, India 5100 Kyndryl Solutions Private Limited Full time

    Who We AreAt 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 RoleWithin...

  • Principal - Database Administration

    1 week ago

    Bengaluru, India Fidelity Investments Full time

    The Purpose of This RoleProvide 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 DeliverThe Mainframe DBA group provides a variety of services related to DB2 on...

  • Mainframe IMS and DB2 DBA

    4 days ago

    Bengaluru, India 5100 Kyndryl Solutions Private Limited 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...

  • Principal - Database Administration

    1 week ago

    Bengaluru, India Fidelity Investments Full time

    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 Mainframe DBA group provides a variety of...

  • Db2 Dba

    4 weeks ago

    Bengaluru, India Capgemini Full time

    Proficiency with DB2 LUW v9 ,10/v11 database administration on UNIX or Linux platforms on medium to large systems - Good exposure to UDB DBA maintenance activities like reorgs, runstats, back-up, restore, expanding and reducing the table-spaces. - Performance Tuning of databases by designing appropriate architecture and tuning of database instances. -...

  • Db2 Mainframe

    3 weeks ago

    Bengaluru, India Nityo Infotech Full time

    •Design, develop, modify, debug and/or maintain software code according to functional, non-functional and technical design specifications in Agile/Waterfall•Understand High Level Design, Application Interface Design & build Low Level Design as per specifications. Perform application analysis & propose technical solution for application enhancement or...

  • Database Administrator

    4 weeks ago

    Bengaluru, India IBM Full time

    Introduction This is a Database Administrator Position to work in the Maximo/Tririga SRE team, responsible for all infrastructure support for production environments in the IBM Cloud. Most of the activities are performed in DB2, however DB experience in other database offerings would be useful for this position as well. The professional will have the...

  • Mainframe Administrator

    2 weeks ago

    Bengaluru, India Eviden Full time

    Job Description:Experienced Mainframe professional with 3 to 7 years of hands-on experience in Mainframe System Administration.Good Knowledge of Mainframe z/OS system upgrade/maintenance.Good knowledge of tools/products like Changeman, Abend-Aid, ZEKE, $AVRS, View Direct, or CMOD.Mandatory Skills:Good knowledge of Mainframe z/OS system...

  • MainFrame DB2 DataBase Administrator

    4 weeks ago

    Bengaluru, India Tata Technologies Full time

    o Good experience in DB2 with§ Creation of new DB objects§ Providing access to Group id's in XDEV/IGRT/DEVE/ACPT/PROD§ Cleanup of existing individual id's§ Maintenance of objects in all Env.§ Environment Refresh§ Troubleshooting, incident resolution, change implementations§ Deployments related to PROD environment changes§ Application operations and...

  • DB2 Database Administrator

    3 weeks ago

    Bengaluru, India Kyndryl Full time

    Who We AreAt 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 RoleAn...

  • Db2 Mainframe

    4 weeks ago

    Bengaluru, India Nityo Infotech Full time

    •Design, develop, modify, debug and/or maintain software code according to functional, non-functional and technical design specifications in Agile/Waterfall•Understand High Level Design, Application Interface Design & build Low Level Design as per specifications. Perform application analysis & propose technical solution for application enhancement or...

  • MainFrame DB2 DataBase Administrator

    4 weeks ago

    Bengaluru, India Tata Technologies Full time

    o Good experience in DB2 with § Creation of new DB objects § Providing access to Group id's in XDEV/IGRT/DEVE/ACPT/PROD § Cleanup of existing individual id's § Maintenance of objects in all Env. § Environment Refresh § Troubleshooting, incident resolution, change implementations § Deployments related to PROD environment changes § Application...

  • MainFrame DB2 DataBase Administrator

    4 weeks ago

    Bengaluru, India Tata Technologies Full time

    o Good experience in DB2 with§ Creation of new DB objects§ Providing access to Group id's in XDEV/IGRT/DEVE/ACPT/PROD§ Cleanup of existing individual id's§ Maintenance of objects in all Env.§ Environment Refresh§ Troubleshooting, incident resolution, change implementations§ Deployments related to PROD environment changes§ Application operations and...

  • MainFrame DB2 DataBase Administrator

    1 month ago

    Bengaluru, India Tata Technologies Full time

    o Good experience in DB2 with§ Creation of new DB objects§ Providing access to Group id's in XDEV/IGRT/DEVE/ACPT/PROD§ Cleanup of existing individual id's§ Maintenance of objects in all Env.§ Environment Refresh§ Troubleshooting, incident resolution, change implementations§ Deployments related to PROD environment changes§ Application operations and...

  • DB2 Database Administrator

    3 weeks ago

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