Introduction
In this role you'll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers) where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology.
In this role you'll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers) where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology.
Your role and responsibilities
- In this role you will work in one of our IBM Consulting Client Innovation Centers (Delivery Centers) where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology.
- As a Database Administrator you'll participate in many aspects of the software development lifecycle such as design code implementation testing and support. You will create software that enables your clients' hybrid-cloud and AI journeys
- Your primary responsibilities include:
- Monitor and analyze database performance (CPU memory disk space etc.).
- Verify backup integrity and recovery procedures regularly.
- Work with developers and architects to ensure optimal database design for application requirements.
- Optimize database schema for performance scalability and maintainability.
- Implement performance tuning strategies (e.g. indexing query optimization and partitioning).
- Identify and resolve database bottlenecks.
- IBM DB2 Administrator role is to manage and maintaining IBM's DB2 database systems.
- Educational qualification - Bsc Computer Science
- Work experience - 6.9 years and 2 years 9 months for UKSC
Required education
Bachelor's Degree
Required technical and professional expertise
- Knowledge on IBM DB2 LUW (DB2 for Linux Unix and Windows)
- Migration of DB2 UDB databases from old to newer versions
- Apply FIXPACKS to keep DB2 at most recent level.
- SQL Tuning and benchmarking using db2batch db2advis db2explain tools.
- Working for creating Instances Databases Tablespaces and Buffer pools
Preferred technical and professional experience
- Working on IBM DB2 LUW (DB2 for Linux Unix and Windows)
- Expertise in using Movement Utilities like as Export Import Load.DB2MOVE under high volume conditions.
- Expertise on HADR Server Rebuild and Monitoring and HADR failovers and Rolling Upgrades