Jobs Career Advice Signup

Send this job to a friend


Did you notice an error or suspect this job is scam? Tell us.

  • Posted: Nov 21, 2019
    Deadline: Not specified
  • At IBM Southern and Central Africa, we strive to lead in the creation, development and manufacture of the industry's most advanced information technologies, including computer systems, software, networking systems, storage devices and microelectronics. And our worldwide network of IBM solutions and services professionals translates these advanced technologie...
    Read more about this company

    Database Administrator - DB2 SysProg

    Over the past 100 years, IBMers all over the globe have helped make the world work better and smarter. In this new era of Cognitive Business, IBM is helping to reshape industries by bringing together our expertise in Cloud, Analytics, Security, Mobile, and the Internet of Things: Changing how we create, collaborate, analyze and engage. From transforming healthcare to improving the retail shopping experience – it’s what IBMers do. As we tackle the world’s biggest challenges, our company continues to grow, we’re looking for talented professionals to join us in this new era.

    Join us and be part of a diverse and global team of thinkers and doers - people who want to make an impact, cultivate their expertise and collaborate with some of the world’s top business and technology professionals.

    DB2 SysProg

    • Database Administrator with data security and disaster recovery experience to contribute toward the success of our technology initiatives.
    • Manages physical databases on the specific database technologies.
    • Designs and implements back-up, recovery, archiving, and conversion strategies.
    • Manages and maintains data definitions in all production and non-production databases and replication servers.
    • Manages the database distribution, security, and access requirements.
    • Designs and develops logical and physical layers of databases. Handles testing, reporting, back-up, and restores.
    • Provides technical assistance and mentoring to staff for developing conceptual and logical database design and the physical database.
    • Recommends, installs, and maintains database software.
    • Monitors performance and performs database training and assists application developers with train tuning efforts .SMPE Knowledge where applicable.
    • Design, monitor, and tune large/high volume DB2 z/OS applications to contribute toward the success of our technology initiatives.
    • Logical and physical database design, support distributed access, back-up, recovery, reorg, archiving, data conversion, data security, database and application training, support testing efforts and recommend and support database software.
    • Experience with tools, facilities and techniques for managing and administering data.
    • Installation, upgrade and PTF application of DB2 base and related products
    • Do research regarding end of service dates for products in the support portfolio
    • Do research regarding PTFS
    • Plan upgrades taking inter product dependency into consideration
    • Do upgrades of products when required
    • Backup and recovery of DB2 catalog and directory
    • Design, document and maintain backup and recovery strategy
    • Implement strategy using scheduler and automation tools
    • Running of housekeeping on DB2 catalog and directory
    • Design, document and maintain backup and recovery strategy
    • Implement strategy using scheduler and automation tools
    • Performance tuning of the DB2 system components
    • Create and document performance tuning strategy
    • Implement strategy using scheduler and automation
    • Suggest and implement solutions to identified performance issues
    • Capacity planning for the DB2 system components
    • Monitoring of various DB2 system components
    • Design and implement disaster recovery procedures for DB2 system components
    • Set up DB2 DR Procedures when required
    • Take part in the DR exercise;
    • Ensure operational availability of DB2 systems in accordance to the SLA
    • Design and implement daily checks and exception notification using scheduler and automation
    • Maintain DDF connections
    • Problem resolution during abnormal termination of DB2
    • Ensure DB2 adhere to agreed installation and security protocols
    • Run quarterly security checks
    • Implement remedial actions

    Preferred Skills/Experience

    • Rudimentary coding knowledge (Java, Cobol, Rexx, etc)
    • Computer operations
    • Product and vendor evaluation
    • Computer operations
    • Product and vendor evaluation
    • Database structures
    • Relational databases
    • Performance monitoring tools
    • Query tuning
    • DB2 Connect
    • Database utilities (both IBM and third party)
    • Technical troubleshooting
    • Query and database access tools
    • Information management
    • Application development tools
    • Application delivery process
    • Data administration
    • Technical troubleshooting
    • IT environment
    • Query and database access tools
    • Database backup and migration
    • Database structures
    • Information management
    • Application development tools
    • Application delivery process Relational databases

    Have a good working knowledge

    • The workings of DB2 z/OS components such as the MSTR, DBM1, DIST and IRLM
    • The DB2 online and offline utilities
    • The various DB2 commands that will affect the operational availability of DB2
    • The installation and upgrade steps for DB2 as described in the DB2 installations guide
    • How to use the DSNTINST clist
    • Generating DB2 ZPARMS
    • Have a good knowledge of the following IBM products
    • DB2 Admin tool
    • DB2 automation tool
    • VSAM and ICF catalogs
    • OF SMP/E concepts and features

    Understanding Of

    • The impact that the following will have on DB2
    • SMS,HSM and storage pools
    • RACF/ACF 2
    • APF, LINKLIST and Sub system definitions
    • ZIPP
    • SMF
    • Sysplex and data sharing
    • TCP/IP
    • VSAM and ICF catalogs
    • The concepts of problem and change management

    Required Technical and Professional Expertise

    • Degree in Engineering, MBA Computer Science or similar
    • Minimum 3 years experience in similar technology

    Method of Application

    Interested and qualified? Go to IBM on to apply
  • Send your application

Never miss a job with our real-time & personalized push notification
Subscribe Now
Back To Home

Career Advice

View All Career Advice

Subscribe to Job Alert


Join over 1K happy subscribers

Send your application through

Yahoomail Gmail Hotmail