Db2 system programmer
Posted 6 days ago by CSI GLOBAL LTD
Negotiable
Inside
Undetermined
Sheffield, England, United Kingdom
Summary: As a Db2 system programmer, you will ensure the performance, integrity, maintenance, and security of the database estate in the UK, supporting over 50 Db2 subsystems across various mainframes. The role involves installing and testing new versions of Db2, managing distributed Db2 connections, and ensuring the stability of a responsive OLTP environment. You will also be responsible for capacity planning, monitoring performance, and managing security and disaster recovery aspects of the database. Strong problem-solving skills and the ability to work under pressure are essential for success in this position.
Key Responsibilities:
- Install and test new versions of Db2 / Function Levels
- Continuous delivery of maintenance for Db2 and associated tools
- Support and management of distributed Db2 connections
- Engineering solutions to exploit appropriate automation
- Stability and integrity of a highly responsive OLTP (CICS) Db2 environment
- Planning and maintenance of databases
- Carry out capacity planning
- Ensure that storage and archiving procedures are functioning correctly
- Monitor performance and manage parameters for fast responses to front-end users
- Manage the security and disaster recovery aspects of a database
- Develop, manage and test back-up and recovery plans
- Communicate regularly with technical, applications and operational staff to ensure database integrity and security
- Establish the needs of users and monitor user access and security
- Troubleshooting activities
Key Skills:
- Excellent problem-solving and analytical skills
- Good communication, teamwork and negotiation skills
- Familiarity with main data manipulation languages and principles of database design
- Ability to work to tight deadlines under pressure
- Good organisational skills
- Flexibility and adaptability
- Ability to create and maintain strong working relationships with colleagues and customers
- Business awareness and understanding of IT business requirements
- Willingness to keep up to date with developments in new technology
- Commitment to continuing professional development (CPD)
- Understanding of information legislation, such as GDPR
- Incident management
- Agile practices
Salary (Rate): undetermined
City: Sheffield
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
Role Title: z/OS Db2 specialist
FTE Needed: 1
Location: Sheffield, UK
Start Date ASAP
End Date 31-Dec-26
Inside IR35 Contract role
Role Summary: As a Db2 system programmer you will be responsible for ensuring the performance, integrity, maintenance and security of our database estate in the UK. The UK Db2 system programmer team is responsible for large-scale environments, supporting 50+ Db2 subsystems across various mainframes and geographies. You will be required to work as part of the team to support all aspects of Db2 for z/OS activities.
As a Db2 for z/OS specialist, you’ll need to:
- Install and test new versions Db2 / Function Levels
- Continuous delivery of maintenance for Db2 and associated tools
- Support and management of distributed Db2 connections
- Engineering solutions to exploit appropriate automation
- Stability and integrity of a highly responsive OLTP (CICS) Db2 environment
- Planning and maintenance of databases
- Carry out capacity planning
- Ensure that storage and archiving procedures are functioning correctly
- Monitor performance and manage parameters in order to provide fast responses to front-end users
- Manage the security and disaster recovery aspects of a database.
- Develop, manage and test back-up and recovery plans
- Communicate regularly with technical, applications and operational staff to ensure database integrity and security
- Establish the needs of users and monitor user access and security
- Troubleshooting activities
Skills You will need to show:
- Excellent problem-solving and analytical skills
- Good communication, teamwork and negotiation skills
- Familiarity with the main data manipulation languages and the principles of database design
- The ability to work to tight deadlines under pressure
- Good organisational skills
- Flexibility and adaptability
- The ability to create and maintain strong working relationships with colleagues and customers
- Business awareness and understanding of the business requirements of IT
- A willingness to keep up to date with developments in new technology
- A commitment to continuing professional development (CPD)
- An understanding of information legislation, such as the GDPR.
- Incident management
- Agile practises
Qualifications You can enter this career with a degree in any subject or significant relevant industry experience, but the following is preferable:
- Computer science
- Computer software/computer systems engineering
- Electronics
- Information Technology
- Mathematics
- Operational research
Working hours Working hours are usually 35 hours a week, Monday to Friday. Work may be required during unsocial hours (overnight and weekends) to support activities during periods of low usage. A successful applicant may be required to support an on-call rota responding to critical issues outside of business hours (overnight and weekends).
Work experience Experience of working as a z/OS Systems Specialist with significant skills in the Db2 arena
- Db2 production support
- Db2 software maintenance
- Db2 performance tuning
- Db2 application support
It's a good idea to have some experience in programming such REXX/Cobol.