About the position
The resources will provide these services following the acquisition of the IBM DB2 Enterprise Analyser for NPSD/PEM to analyze IBM DB2 transaction logs for tasks like data recovery, auditing, and performance monitoring. This requires a database administrator or a specialist to interpret log data to track who changed what, when, and how, which aids in troubleshooting, auditing, and ensuring data integrity. The analysis supports actions such as recovering dropped objects, replaying changes for replication, and creating reports on data modification. The main purpose of the new job roles is to be responsible for administering, optimizing, monitoring, and finetuning databases on DB2 for z/OS mainframe. Perform various related database functions across multiple teams or clients, including designing, implementing, and maintaining new databases, backup/recovery, and configuration management. Preferred Skills: DB2 v11 or v12 or v13 in a z/OS environment Certification Competencies:
It requires the ability to manage IBM DB2 monitoring with EventLog Analyzer, comprehensive log management tool knowledge, advanced capabilities for gathering, tracking, and analyzing logs from IBM Db2 databases. Requires the ability to meticulously analyze reports on all changes made using Data Definition Language (DDL) and Data Manipulation Language (DML) commands, while also monitoring user interactions with the database.
Understanding of a database management tool e.g. Performance monitor, schedulers, e.g.
o DB2 Query Monitor for zOS
o DB2 SQL Performance Analyser
o OPTIM query Workload Tuner
o DB2 Administrator Tool for zOS
o DB2 for zOS
o DB2 Log Analysis Tool for zOS
o QMF for Workstation
o QMF for zOS
o CICS DBUG Tool
o TMON
SQL and/or Rexx coding to automate routing tasks.
Basic AIX / Linux system administration and resource monitoring.
Ability to analyse application logs and identify root causes of issues.
Desired Skills:
- Analytical skills and thinking
- Presentation Skills
- Communication skills
- Time and work management
Desired Work Experience:
- 2 to 5 years
Desired Qualification Level:
- Degree
About The Employer:
- Data Auditing and Reporting: Utilize the Db2 Log Analysis Tool to monitor and audit data changes in Db2 tables, generating detailed and summary reports on modifications, user activity, and schema changes for compliance, regulatory, and business requirements.
Data Recovery and Restoration: Implement recovery procedures for dropped objects or corrupted data using the Log Analysis Tool to restore Db2 tables and associated objects to a specific point in time, minimizing data loss and ensuring business continuity.
Performance Analysis: Analyze Db2 log data to identify performance bottlenecks, understand data access patterns, and optimize database operations using the tool's performance-related features, such as parallel log reading.
Data Replication: Leverage the Log Analysis Tool to capture and replicate data changes to other systems or objects, supporting data synchronization and disaster recovery strategies.
Problem Resolution: Investigate and resolve data-related issues by analyzing log records to understand the sequence of events leading to problems and implementing corrective actions.
JCL Generation and Execution: Generate and execute JCL jobs for various Log Analysis Tool functions, including report generation, data loading, and recovery processes.
Configuration and Administration: Configure and maintain the Db2 Log Analysis Tool, including user settings, report filters, and log processing specifications.
Experience:
- Experience working in a production support environment on z/OS DB2.
- Minimum 5 years' experience as DB2 DBA in an IBM® z/OS environment
- Working knowledge of Mainframe (MVS), DB2 for z/OS, WINDOWS Operating systems, SQL, CICS and JCL.
- Batch operations and MVS architectures
