Database Administrator - DB2 SysProg

Job description

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
Auto req ID

280782BR
Required Education

Bachelor's Degree
Role ( Job Role )

Application Database Administrator
State / Province

GAUTENG
Primary job category

Technical Specialist
Company

(0123) IBM South Africa (pty) Ltd
Contract type

Fixed Term - Short Term
Employment Type

Full-Time
Is this role a commissionable/sales incentive based position?

No
Travel Required

No Travel
IBM Business Group

GTS
Preferred Education

Master's Degree
City / Township / Village

JOHANNESBURG
Being You @ IBM

Affirmative Action and/or EE candidates will be given first preference as per our employment equity strategies.
Required Technical and Professional Expertise

Required Professional and Technical Expertise
·  Degree in Engineering, MBA Computer Science or similar
·  Minimum 3 years experience in similar technology
Country/Region

South Africa
Preferred Technical and Professional Experience

DB2 SysProg activities
Secondary Job Category

Services Specialist
Eligibility Requirements

DB2 SysProg activities
Position Type

Professional
Early Professional Track

Not Applicable - Professional Hire
Location Statement

For additional information about location requirements, please discuss with the recruiter following submission of your application.
Introduction

At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most challenging problems? If so, lets talk.
Your Life @ IBM

What matters to you when you're looking for your next career challenge?

Maybe you want to get involved in work that really changes the world? What about somewhere with incredible and diverse career and development opportunities – where you can truly discover your passion? Are you looking for a culture of openness, collaboration and trust – where everyone has a voice? What about all of these? If so, then IBM could be your next career challenge. Join us, not to do something better, but to attempt things you never thought possible.

Impact. Inclusion. Infinite Experiences. Do your best work ever.
About Business Unit

At Global Technology Services (GTS), we help our clients envision the future by offering end-to-end IT and technology support services, supported by an unmatched global delivery network. It's a unique blend of bold new ideas and client-first thinking. If you can restlessly reinvent yourself and solve problems in new ways, work on both technology and business projects, and ask, "What else is possible?" GTS is the place for you!
About IBM

IBM's greatest invention is the IBMer. We believe that progress is made through progressive thinking, progressive leadership, progressive policy and progressive action. IBMers believe that the application of intelligence, reason and science can improve business, society and the human condition. Restlessly reinventing since 1911, we are the largest technology and consulting employer in the world, with more than 380,000 IBMers serving clients in 170 countries.