IBM DB2 Administrator

8 years

0 Lacs

Posted:1 day ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

About the Role

Sr. IBM DB2 Administrator

database administration, monitoring, optimization, and troubleshooting

🔹

Key Responsibilities

  • Manage

    DB2 LUW architecture

    , installation, instance creation, and product setup.
  • Create and maintain

    database objects

    (tables, indexes, views, tablespaces, stored procedures).
  • Implement

    backup & restore strategies

    (online, offline, point-in-time recovery).
  • Perform

    tablespace management, reorg (online/offline), and data movement utilities

    .
  • Configure & maintain

    HADR

    for high availability and disaster recovery.
  • Monitor database health using

    PD, TOP, and monitoring tools

    .
  • Conduct

    performance tuning

    (DBM/DB parameters, query tuning using EXPLAIN/ADVISE).
  • Handle

    redirect restores between servers

    and

    database upgrades/rollback plans

    .
  • Implement

    replication setups (SQL & Q)

    for primary-to-standby environments.
  • Troubleshoot issues related to

    logs, rollback segments, tablespaces, I/O errors, data corruption

    .
  • Define

    naming conventions, data structures, storage parameters, and security rules

    .
  • Estimate and recommend

    storage requirements

    .
  • Apply

    patches, upgrades, and proactive monitoring

    to prevent outages.
  • Support

    day-to-day database administration & performance optimization

    .
🔹

Mandatory Skills

✅ DB2 LUW Administration (5–8 Years)

DB2 architecture & basic commands

✅ HADR configuration & maintenance

✅ Backup/restore & recovery management

✅ Tablespace, index & object management

✅ Database installation, maintenance & upgrades

✅ Query tuning & performance optimization

✅ Replication setup (SQL/Q)

✅ Linux/Unix administration skills

🔹

Preferred Skills

  • Strong

    problem-solving & troubleshooting

    abilities
  • Experience in

    security/access management

  • Knowledge of

    storage estimation & capacity planning

  • Exposure to

    cloud/enterprise-level DB2 environments


Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

noida, uttar pradesh, india

noida, uttar pradesh, india