DB2 Support Specialist
Posted 3 days ago by eappstechnologies
Negotiable
Inside
Hybrid
Sheffield, South Yorkshire, UK
Summary: The DB2 Support Specialist will be a key member of the DB2 Support Team, responsible for managing and maintaining DB2 for z/OS across various mainframes. The role involves ensuring database performance, integrity, and security while providing support for applications utilizing DB2. The specialist will also engage in planning, development, and troubleshooting to meet user needs effectively. This position requires collaboration with technical and operational staff to uphold database standards and security protocols.
Key Responsibilities:
- Establish the needs of users and monitor user access and security
- Monitor performance and manage parameters in order to provide fast responses to Front End users
- Install and test new versions of DB2
- Develop, manage and test back-up and recovery plans
- Ensure that storage and archiving procedures are functioning correctly
- Carry out capacity planning
- Communicate regularly with technical, applications and operational staff to ensure database integrity and security
- Manage the security and disaster recovery aspects of a database
- Support and management of distributed DB2 connections
- Provide 2nd and 3rd Level Support for applications that use DB2
- Ensure stability and integrity of a highly responsive OLTP (CICS) DB2 environment
- Ensure that we use supported versions for all database and monitoring solutions
- Provide provision for data security and recovery control
Key Skills:
- 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
- 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
- Experience in programming such as REXX/Cobol is advantageous
Salary (Rate): undetermined
City: Sheffield
Country: UK
Working Arrangements: hybrid
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
DB2 Support Specialist
Main Purpose of the Job
Working as part of the DB2 Support Team to undertake all aspects of DB2 for z/OS. The team is responsible for is large DB2 subsystems across various mainframes and geographies.
Your responsibility as a DB2 System programmer will be ensuring the performance, integrity, maintenance and security of our database estate. You'll be involved in the planning and development of the databases, as well as in troubleshooting any issues on behalf of the users.
You'll ensure that:
- There is provision for data security and recovery control (ensuring all data is retrievable in an emergency).
- Ensure that we use supported versions for all database and monitoring solutions.
- Provide 2nd and 3rd Level Support for applications who use DB2.
- Stability and integrity of a highly responsive OLTP (CICS) DB2 environment.
Responsibilities
As a DB2 for z/OS specialist, you'll need to:
- Establish the needs of users and monitor user access and security
- Monitor performance and manage parameters in order to provide fast responses to Front End users
- Install and test new versions DB2
- Develop, manage and test back-up and recovery plans
- Ensure that storage and archiving procedures are functioning correctly
- Carry out capacity planning
- Communicate regularly with technical, applications and operational staff to ensure database integrity and security
- Manage the security and disaster recovery aspects of a database.
- Support and management of distributed DB2 connections.
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.
- 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.
Location: Sheffield
Client: HSBC
Day Rate: negotiable (Inside IR35)
Hybrid/Remote: Hybrid (2-3 days in office)