Database Administrator

THE WORK: You will be part of an exciting team where you are expected to collaborate and form part of a wider technical team. You will be responsible for team decisions and will engage with multiple teams to contribute to key decisions in the application data administration field. Your expertise will be crucial in providing solutions to problems for your immediate team and across multiple teams.

Responsibilities:

1. Design and develop databases
2. Capacity plan and conduct database backups
3. Monitor logs for potential problems
4. Monitor software database license processes
5. Manage technical action reports to resolve software issues
6. Provide outage resolution support
7. Perform analysis to resolve issues
8. Develop and maintain disaster recovery plans

HERE'S WHAT YOU WILL NEED:

1. Master proficiency in IBM DB2 Database Administration in IBM z/OS
2. Advanced proficiency in IBM z/OS
3. A minimum of 3 years of experience in relevant related skills
4. Bachelor's Degree

BONUS POINTS IF YOU HAVE:

1. Advanced proficiency in Database Optimization & Tuning
2. Advanced proficiency in Database Performance Management
3. Intermediate proficiency in IBM Db2 Query Management Facility (QMF)
4. Intermediate proficiency in Job Control Language (JCL)

Minimum Requirements:

1. Minimum 3 years experience as DB2 DBA in an IBM z OS environment
2. Working knowledge of Mainframe MVS, DB2 for z OS, WINDOWS Operating systems, SQL, CICS, and JCL
3. Batch operations and MVS architectures

Preferred Skills:

1. DB2 v11 or higher in a z OS environment
2. Understanding of database management tools (e.g., Performance monitor, schedulers)
3. CONTROL M R O T
4. DB2 Query Monitor for zOS
5. DB2 SQL Performance Analyser
6. OPTIM Query Workload Tuner
7. DB2 Administrator Tool for zOS
8. DB2 for zOS
9. DB2 Log Analysis Tool for zOS
10. QMF for Workstation
11. QMF for zOS
12. CICS DBUG Tool
13. TMON
14. IDZ
15. SQL and/or Rexx coding to automate routing tasks