DB2 LUW Consultant

3 days ago

Riyadh, Ar Riyāḑ, Saudi Arabia TAT IT Technolgies Full time
DB2 LUW Consultant - DB2 setup and patch management

We have an urgent requirement for a DB2 LUW Consultant - DB2 setup and patch management for our client based in Riyadh, Saudi Arabia.

Key Responsibilities:

  • Experience in DB2 installation & apply patches and fixpacks.
  • Strong experience in restoring an online database backup and rolling back a database to a specific point-in-time.
  • Extensive database performance tuning experience by analyzing snapshots (database, buffer pool, tables, etc.).
  • Data modeling analysis, normalization, and de-normalization.
  • Hands-on experience in DB2 SQL Replication and Q-Replication.
  • Hands-on experience in DB2 HADR configuration using TSA/Pacemaker.
  • Experience in capacity planning for new hardware/software.
  • SQL analysis and capturing bad SQLs, generating EXPLAIN and ADVISER tools, and creating/changing indexes to improve performance.
  • Proper monitoring of the database using DB2DART, DB2PD, and IBM functions and administrative views.

Skills Required:

  • Capacity planning
  • DB2 HADR configuration
  • SQL analysis
  • Patch management
  • Rollback
  • DB2 SQL replication
  • DB2 installation
  • DB2 database restoration
  • Normalization and de-normalization
  • Database performance tuning
  • Database monitoring
  • Q-Replication
Seniority Level

Mid-Senior level

Employment Type

Full-time

Job Function

Consulting, Information Technology, and Sales

Industries

Technology, Information, and Internet

#J-18808-Ljbffr

  • ISIM Developer

    4 days ago

    Riyadh, Ar Riyāḑ, Saudi Arabia Aujas Cybersecurity Full time

    Should be willing to travel to Saudi Arabia.Role Description:Work as a team member to develop and implement identity management solutions using ISIM.Understand user provisioning concepts including workflows, user interfaces, policies and reports as per solution requirements.Deploy ISIM in various environments and configurations including high availability...

  • Webservices Analyst

    6 days ago

    Riyadh, Saudi Arabia Talent Pal Full time

    Languages: Java Database: Oracle, DB2 or any other RDBMS. OS: Unix web services, B2B Integration. More than 9 years of experience and at least 3-4 years of experience in eBusiness. Should possess excellent communication skills, good analytical and problem solving skills, and business building capability. - _Responsibilities:_ - Technology and product...

  • Cloud Pak for Data Consultant

    2 weeks ago

    Riyadh, Saudi Arabia IBM Full time

    **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...

  • Ibm Cloud Pak for Data Consultant

    2 weeks ago

    Riyadh, Saudi Arabia IBM Full time

    **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...

  • Ibm Z Management Consultant

    2 weeks ago

    Riyadh, Saudi Arabia IBM Full time

    **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...

  • Business Data Analyst

    4 days ago

    Riyadh, Saudi Arabia Talent Pal Full time

    We are entrepreneurs in disruptive technology, at Devoteam, we deliver innovative technology consulting for business. Digital Transformakers, we are 7,000+ professionals across EMEA dedicated to ensuring our clients win their digital battle. We improve business performance making their companies truly digital. We advise our clients and build IT...

  • Technical Account Manager Specialist

    4 days ago

    Riyadh, Saudi Arabia Talent Pal Full time

    **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...

  • Technical Account Manager Specialist

    1 week ago

    Riyadh, Saudi Arabia IBM Full time

    **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...