Db2 Database Administrator

3 days ago

Bengaluru Hyderabad, India Pragma Edge Software Services Full time ₹ 12,00,000 - ₹ 24,00,000 per year

Job Description:

As an IBM DB2 Database Administrator, you will be responsible for the management, optimization, and overall administration of IBM DB2 databases. You will ensure the availability, reliability, and performance of DB2 databases that support business-critical applications. This position requires expertise in database configuration, tuning, security, backup, recovery, and troubleshooting within both distributed and mainframe environments.

Key Responsibilities:

Database Administration:

  • Install, configure, and maintain IBM DB2 databases on GCP Could platforms.
  • Perform database upgrades and patches to ensure the environment is up to date and secure.
  • Manage database objects (tables, indexes, views, etc.) and ensure proper data integrity and normalization.
  • Handle database partitioning, clustering, and replication tasks.

Performance Tuning & Optimization:

  • Monitor and analyze database performance, identifying bottlenecks and tuning SQL queries for optimal performance.
  • Utilize tools such as IBM Data Studio, or third-party software for performance monitoring.
  • Conduct regular database health checks and make recommendations for improvements.

Backup & Recovery:

  • Design and implement robust backup strategies, including automated backups, point-in-time recovery, and disaster recovery planning.
  • Perform DB2 database restores and recoveries, ensuring minimal downtime.
  • Manage database log files and ensure recovery capabilities.

Data Management & Maintenance:

  • Perform regular maintenance tasks, including reorganization, compression, and data archiving.
  • Manage large volumes of transactional data and optimize database performance for OLTP and OLAP systems.
  • Expertise on of cloud platforms (IBM Cloud, Google cloud) is critical

Troubleshooting & Support:

  • Troubleshoot and resolve database issues, including connectivity, performance, and corruption problems.
  • Provide support to development teams for database design, query optimization, and performance tuning.
  • Support high-availability environments and participate in on-call rotations for after-hours support.

  • DB2 Database Administrator

    1 week ago

    Bengaluru, Karnataka, India Infosys Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    DB2 Database AdminCandidate should have an experience of 5 years in DB2 database administration with in-depth knowledge of DB2 database architecture and should have worked on latest versions of db2 databases like 10.5,11.1,11.5 etc

  • Db2 Database Administrator

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

  • IBM DB2 Database Administrator

    3 days ago

    Bengaluru, Karnataka, India Tata Consultancy Services (TCS) Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Key Skills:- IBB DB2 LUW- i.e Database administrator of DB2.Experience on installation of different versions of DB2 on Redhat Linux EnvironmentGood knowledge of LinuxScheduling shell scripts on LINUX environmentsGood experience in generating DDL's using DB2LOOK command on existing database and its objects.Use RUNSTATS, REORGCHK and REORG to enhance...

  • Db2 Database Administrator

    5 days ago

    Bengaluru, Chennai, Pune, India Tekskills Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Mainframe DB2 System Admin/System ProgrammerPrimary 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• Has thorough knowledge of resources available and demonstrated ability to use the...

  • DB2 Database Administrator

    1 week ago

    Bengaluru, India Capgemini Full time

    Job Description Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired bya collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizationsunlock the value of...

  • Database Administrator

    4 weeks ago

    Bengaluru, India SMARTWORK IT SERVICES Full time

    Position : Database Administrator DB2 & OracleExperience Required : 4- 8 yearsLocation : BangaloreEmployment Type : Full-timeJob Summary :We are seeking a skilled Database Administrator (DBA) with expertise in DB2 and Oracle databases hosted on Azure Cloud. The ideal candidate will be responsible for ensuring database performance, reliability, and security...

  • Mainframe DB2 Database administrator

    2 weeks ago

    Bengaluru, Chennai, India Iatocs Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Role & responsibilitiesInstall, configure, upgrade, and maintain DB2 subsystems on z/OS.Perform database performance monitoring and tuning (buffer pool tuning, SQL optimization, etc.).Administer DB2 utilities (REORG, RUNSTATS, LOAD, UNLOAD, COPY, etc.).Manage schema changes, object creation, and DDL/DML execution.Collaborate with application developers to...

  • Db2 Database Administrator

    5 days ago

    Bengaluru Rural, India Vega Intellisoft Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job DescriptionWe are looking for an experienced DB2 DBA to join our team As a DB2 DBA you will be responsible for the implementation, configuration, maintenance, and performance of critical DB2 RDBMS systemsRequirements10 years of experience as a DB2 DBA or similar role • Experience with Performance Tuning and Optimization (PTO)• Experience with...

  • Mainframe DB2 Database Administrator

    2 weeks ago

    Hyderabad, Telangana, India Kyndryl Full time ₹ 10,00,000 - ₹ 25,00,000 per year

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

  • Mainframe DB2 Database Administrator

    2 weeks ago

    Hyderabad, Telangana, India Kyndryl Full time ₹ 10,00,000 - ₹ 25,00,000 per year

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