pripája sa...

SENIOR DB2 ADMINISTRATOR

Lokalita Bratislavský kraj
Sektor
Typ Práce Trvalý pracovný pomer
Publikované asi rokom
Kontakt Grečo Matej
Ref. Č. 19328

Popis Práce

This is an excellent opportunity to work in a well-established international company.

  • Creating database, configure DB for archival logging, configure DB parameters
  • Database upgrade/migration (applying fix pack and Version upgrade)
  • DB2 Database Security Model (Authentication, Authority)
  • DB monitoring (Database Snapshot and event monitor)
  • Database backup/restore
  • Review and Execute DDL, review DB2 diag logs, notification logs
  • Resolve locks and deadlocks
  • Analyse and recommend performance enhancements in database design, SQL queries and DB setup
  • Maintain and enhance database availability, manage large number of connections/users
  • Communication with management, key-users, team members and suppliers

Requirements

The candidate should have:
  • 4+ years of experience with DB2 DBA (Linux, Unix and Windows)
  • A solid knowledge of DB2 Database architecture (Process, memory and storage architecture)
  • A solid knowledge of DB2 Database fundamentals (Threads/process, Instance, table spaces, Containers, SMS, DMS, buffer pools)
  • Worked with DB2 V9 or higher
  • Hands on with management/monitoring tools available for DB2
  • Good in root cause analysis of any outage from DB2 logs
  • Sound knowledge on Database character sets (UTF8 and Non-UTF8 Database)
  • Hands on exposure on Data movement tools (db2move, export, import etc)
  • Fluency in English language

Benefits

Company offers attractive compensation package

Other notes

For more related job opportunities visit www.grafton.sk/en/jobs/it-telecommunications/

IT and Telecommunications | System administration and support | Administrator | Database | DB2 | 2nd | Developer