Senior DB2 DBA LUW

3 weeks ago


India Technocrats Domain Inc Full time

Job Description

DB2 Database Administration - LUW

- Install, configure, and upgrade Db2 instances and fix packs.
- Manage database objects (tablespaces, indexes, views, triggers, etc.).
- Manage user access, roles, and security policies.
- Apply patches, version upgrades, and monitor health.

Performance Tuning & Optimization

- Analyze and tune SQL queries, buffer pools, and memory allocation.
- Optimize storage usage and improve query execution plans.
- Monitor and resolve locking and contention issues.
- Use db2expln, db2advis, MON_GET, and db2pd tools.

Backup & Recovery

- Design and implement backup strategies (online/offline, incremental, full).
- Manage HADR (High Availability Disaster Recovery) and log shipping.
- Perform point-in-time recovery and disaster recovery simulations.

Monitoring & Maintenance

- Monitor system health using scripts, db2top, db2mon, or DMC.
- Automate maintenance tasks (REORG, RUNSTATS, backup).
- Set up alerts and logs for CPU, memory, I/O, and Db2-specific thresholds.

Linux OS Integration

- Tune Linux kernel parameters for Db2 (e.g., file descriptors, huge pages).
- Monitor disk I/O, memory usage, and CPU loads.
- Manage cron jobs for DB scripts and maintenance routines.

Good at Debugging.

Interested in a Part-Time or Full-Time role.


  • Senior DBA

    3 weeks ago


    India Lemongrass Consulting Full time

    Vacancy No VN1265 Business Unit Americas Job Location India, Philippines Employment Type Full Time Job Details and Responsibilities Role Summary:We are seeking an experienced Senior Database Administrator (DBA) with primary expertise in IBM DB2 and strong secondary skills in SAP HANA. Additional working knowledge of Oracle and MS SQL Server is desirable to...

  • IT Consulting

    4 weeks ago


    Bengaluru, India Infosys Limited Full time

    Job Description Key Responsibilities: - A day in the life of an Infoscion - As part of the Infosys delivery team your primary role would be to interface with the client for quality assurance issue resolution and ensuring high customer satisfaction - You will understand requirements create and review designs validate the architecture and ensure high levels...


  • Noida, India CodersBrain Full time

    Job Description About the Role We are seeking a highly skilled Sr. IBM DB2 Administrator with 58 years of relevant experience in DB2 LUW administration. The ideal candidate will have strong expertise in DB2 architecture, backup & restore, HADR, performance tuning, and replication setups. You will be responsible for database administration, monitoring,...


  • Bengaluru, India Fidelity Investments Full time

    Job Description Job Description Job Title Lead - Database Administrator The Purpose of Your Role Responsible for managing Fidelity Brokerage's Db2 on z/OS Platform along with Aurora PostgreSQL and Aerospike on AWS. The Value You Deliver As part of this role, the DBA will be responsible for the below key responsibilities: - Providing Application Database and...

  • Db2 Luw

    4 weeks ago


    India CIEL HR Full time

    DB2-UDB-DB Administration Experience in DB2 UDB 10 5 Fixpack 6 and 10 1 9 7 And MSSQL 2014 and 2016 MongoDB 3 2 3 4 3 6 3 Installations Configurations and Administration and upgradation Having an experience in handling Production databases up to 1TB in production environment Efficient Knowledge in maintaining the logs of Offline Online Backups ...


  • Chennai, India TECEZE Full time

    Job Description Job Title: DB2 Systems Programmer (Mainframe z/OS) Location: Chennai, Bangalore, Noida Experience: 5-8 years Work mode: Hybrid Job Summary: The DB2 Systems Programmer is responsible for installation, maintenance, and upgrade of IBM DB2 for z/OS subsystems, ensuring optimal performance, availability, and stability. Works with DB2 DBAs,...


  • INMANBP Bangalore (INMANBP) Manyatha, India Kyndryl Solutions Private Limited Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Mainframe DB2 DBA System Administrator 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...

  • Database Architect

    7 days ago


    Mumbai, Maharashtra, India, Maharashtra LTIMindtree Full time

    Managing Database access Security Checks Assessment create and maintain users' login and roles assign privileges Password Management etcManaging Database backups and restores including restores from Snapshots.Database Build Installation configuration OEM Service now tickets Idera New Relic SumoLogic EmailsStarting and stopping database services.Managing...


  • Hyderabad, India NTT DATA North America Full time

    Job Description Strong Resource with 5+ yrs of experience as Qlik Replicate Admin (Attunity) and DB2 development on the following: - Installation, configuration, and administration of the QLIK REPLICATE and Attunity Server (AIS/ARC) . - Creation of data sources and CDC solutions on Mainframe (VSAM/CICS) files using Attunity Studio. - Experience on...


  • Bengaluru, India Kyndryl Full time

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