The Distributed DB2 System Administrator is responsible for managing, maintaining, and optimizing IBM DB2 databases across distributed environments. This role ensures high availability, performance, and security of DB2 systems while supporting application teams and business operations.



Key Responsibilities

DB2 Installation: Install, configure, and upgrade DB2 instances in distributed environments (Windows, Linux, UNIX).

Database Administration: Manage schemas, tables, indexes, and stored procedures.

Performance Tuning: Monitor and optimize query performance, memory usage, and I/O throughput.

Backup & Recovery: Implement disaster recovery solutions, backup schedules, and restore procedures.

Security Management: Enforce authentication, authorization, and encryption policies.

Monitoring & Troubleshooting: Use tools like IBM Data Studio, db2pd, and monitoring scripts to detect and resolve issues.

Automation: Develop scripts fo...