DB2 on z/OS Consultant

Job Description-

DB2 on z/OS, (DB2 Admin and Recover Expert, Data Replicator, QMF on z/OS, DB2 Query Monitor z/OS) – Linux and Windows JD:-

Key Responsibilities:
DB2 Administration: Manage and maintain DB2 databases on z/OS. Perform daily DBA tasks, including backup, recovery, maintenance, and performance tuning.
Recover Expert: Implement DB2 Recover Expert for efficient recovery strategies, ensuring data protection and system availability.
Data Replicator: Configure and manage DB2 Data Replicator for real-time data replication and synchronization across platforms.
Query Management Facility (QMF): Provide support and administration for DB2 QMF, including query optimization and report generation for end-users.
DB2 Query Monitor: Utilize DB2 Query Monitor on z/OS to track and analyze SQL performance, identify bottlenecks, and provide tuning recommendations.
Linux/Windows Administration: Support DB2 instances running on Linux and Windows platforms, performing installations, upgrades, and maintenance as required.
Performance Tuning: Optimize DB2 databases for performance, including indexing strategies, memory allocation, and SQL query optimization.
Security Management: Implement and enforce DB2 security best practices, ensuring compliance with data governance and privacy standards.

Technical Skills:
DB2 Admin and Recover Expert on z/OS
DB2 Data Replicator for real-time data replication
Query Management Facility (QMF) on z/OS
DB2 Query Monitor for SQL performance analysis
Familiarity with DB2 on Linux and Windows environments
Performance tuning and optimization in DB2 environments
Strong knowledge of SQL and scripting languages (e.g., Shell, Python, REXX)

Experience: 5+ years of hands-on experience with DB2 on z/OS, including administration, recovery, and monitoring.