Database Administrator; Db

Overview

A DB2 LUW Administrator is responsible for managing IBM DB2 databases on distributed platforms (Linux, Unix, Windows). The role focuses on database installation, maintenance, performance optimization, and ensuring high availability and security of database systems.

• Strong experience with IBM DB2 LUW (KUW)
• Hands‑on experience with:
  • Linux/Unix environments
  • DB2 tools (db2pd, db2top, EXPLAIN)

• Experience with cloud environments (AWS/Azure)
• Exposure to other RDBMS (Oracle, SQL Server)
• Knowledge of automation and Dev Ops tool

• 8+ years of DB2 LUW administration experience
• Problem‑solving and troubleshooting skills
• Strong analytical thinking
• Ability to work in production support environments
• Good communication and teamwork

• Install, configure, and maintain DB2 LUW databases
• Create and manage instances, databases, table spaces, and schemas
• Perform database upgrades, patches, and migrations
• Manage storage, space allocation, and capacity planning

• Monitor and analyze database performance
• Tune SQL queries, indexing strategies, and database configurations
• Optimize memory usage, buffer pools, and workload management
• Troubleshoot locking, deadlocks, and slow queries

• Configure and manage backup strategies (offline/online backups)
• Perform restores and point‑in‑time recovery (PITR)
• Ensure proper archival logging and recoverability

• Implement and manage HADR (High Availability Disaster Recovery)
• Configure failover, replication, and standby databases
• Support disaster recovery drills and testing

• Manage users, roles, and permissions
• Implement DB security policies and encryption
• Ensure compliance with organizational and regulatory requirements

• Monitor database health and system logs
• Resolve incidents, outages, and performance issues
• Perform root cause analysis and preventive actions

• Automate routine DBA tasks such as backups and monitoring
• Use scheduling tools like cron for maintenance jobs