Mainframe DB2 System Admin/System Programmer
Posted 3 days ago by JSAN Consulting Ltd
Negotiable
Undetermined
Undetermined
London, UK
Summary: The Mainframe DB2 System Admin/System Programmer role requires over 7 years of experience in installing and customizing software products related to Mainframe DB2 and data replication. The position involves performing database software upgrades, managing DB2 environments, and collaborating with IT teams to enhance system performance and reliability. Strong problem-solving skills and the ability to work both independently and as part of a team are essential for success in this role.
Key Responsibilities:
- Perform Mainframe database software upgrades and administration to support DB2 environments.
- Establish policies and procedures for database management, disaster recovery, security, and maintenance.
- Analyze new versions of DB2 for functionality improvements and cost reduction.
- Conduct performance data collection, analysis, and tuning of DB2 systems.
- Execute project and internal initiative responsibilities as assigned.
- Participate in incident and problem management activities related to applications and DB2.
- Perform problem diagnostics, resolution, and change management.
- Collaborate with IT team members, functional users, and vendors for project implementation.
- Provide 24/7 on-call support for Mainframe Infrastructure.
- Develop and maintain operational documentation, best practices, and run books.
- Implement tools and procedures to maintain a stable environment.
Key Skills:
- 7+ years of experience with Mainframe DB2 and data replication products.
- Experience in large systems within a data sharing SysPlex environment.
- Strong problem determination skills in system and application areas.
- Ability to work independently and collaboratively with other experts.
- High level of personal initiative for solution improvement.
- Preferred experience with IDAA, IDAA Bulk Loader, and CDC Replication.
- Experience in design, configuration, and support for critical applications.
- Enthusiasm for developing system skills and challenging the status quo.
Salary (Rate): undetermined
City: London
Country: UK
Working Arrangements: undetermined
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Primary Skills:
Have 7+ years of experience of installing and/or customizing software products Mainframe DB2 and/or data replication product suite
Experience working with large systems in data sharing SysPlex environment
Has thorough knowledge of resources available and demonstrated ability to use the resources for problem determination, product enhancements and other technical issues related to the components being administered
Strong problem determination skills in both system and application areas
Able to work both as individual and as a team member with other subject matter experts and infrastructure DBAs
A high level of personal initiative is a must to help us improve and optimize the solutions
Secondary Skills:
Added Advantage:
Preferred experience with IDAA, IDAA Bulk Loader, and CDC Replication
Experience with design, configuration and support services to production and development departments running critical and 24*7 applications
Good to Have Skills:
Enthusiastic to strengthen/develop system skills
Able to challenge the status quo at every opportunity to drive superior solutions for the benefit of the Bank and its customers
Job Description:
Perform Mainframe database software upgrades coupled with administration and tuning to support DB2 environments
Establishment of policies and procedures pertaining to database management, Disaster recovery, security, maintenance and utilization
Analyzing new versions of DB2 for functionality that can improve systems performance and reduce cost
Perform performance data collection, analysis, and tuning of DB2 systems
Executes project and internal initiative responsibilities as assigned or delegated
Participate in incident and problem management activities related to application and DB2
Perform problem diagnostics and resolution as well as change management
Collaborate with other team members within same Information Technology (IT) departments, functional users and vendors to provide guidance and manage project implementation
Provide 24*7 on-call support Mainframe Infrastructure
Develop and maintains operational documentation, best practices, and run books for the operational platform
Implement tools and procedures required to maintain a very stable environment