Senior Database Administrator

Job Title:

Senior IBM DB2 LUW Database Administrator (10+ Years Experience)

Experience Required:

10+ years of hands-on experience in IBM DB2 LUW administration

Job Summary:

Senior IBM DB2 LUW DBA

Key Responsibilities:

• Design, implement, and administer

  IBM DB2 LUW databases

  on Linux/UNIX (RHEL/AIX) for large multi-terabyte environments
• Configure and support

  partitioned databases (DPF/MPP)

  and optimize data distribution strategies
• Implement and manage

  replication technologies

  such as Q Replication, CDC/IIDR for real-time and batch data movement
• Plan and execute

  database installations, fix packs, upgrades, migrations, and cross-platform moves

  with minimal downtime
• Perform advanced

  performance tuning

  including:
• SQL tuning and access plan analysis
• Index strategy and physical database design
• Tablespaces, bufferpools, and partitioning optimization
• Design and manage

  backup, restore, and disaster recovery strategies

  including online backups, HADR, and DR drills
• Provide

  24×7 production support

  and participate in on-call rotations for critical systems
• Implement and enforce

  database security, auditing, and compliance controls

• Automate routine DBA tasks using

  Shell scripting (Bash/Korn)

  and scheduling tools (Control-M or equivalent)
• Collaborate with application, ETL/ELT, and infrastructure teams for schema design, release management, and issue resolution
• Lead

  root-cause analysis

  for major incidents and maintain comprehensive technical documentation

Required Skills & Expertise (Highlights):

Core DB2 Skills

• IBM

  DB2 LUW administration (10+ years)

• DB2 utilities:

  BACKUP/RESTORE, REORG, RUNSTATS, LOAD, IMPORT/EXPORT

• Performance tools:

  db2pd, mon_get functions, explain plans

High Availability & DR

• HADR

  , log shipping, DR planning & testing
• Experience with

  TSA / cluster managers

• Exposure to

  pureScale

  (preferred)

Replication & Data Movement

• Q Replication / CDC / IIDR

• Monitoring, conflict handling, and performance optimization

Operating System & Automation

• Strong

  Linux/UNIX (RHEL/AIX)

  administration skills
• Shell scripting (

  Bash / Korn

  )
• Enterprise monitoring and scheduling tools

Environment & Soft Skills

• Experience in

  24×7 mission-critical environments

• Strong troubleshooting, documentation, and communication skills
• Ability to work with cross-functional teams under strict SLAs

Nice to Have:

• Experience with large

  data warehouse environments

• Exposure to cloud or hybrid DB2 deployments
• Knowledge of enterprise security and auditing tools