DB2 Support Specialist
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)