Description
DB2 Database Administrator - (Amsterdam, NL)
Skills and experience:
Has minimum 5 years of experience in database development and support in UDB environments.
Experience in Database Administration in UDB ( 9.5 and 9.7 )
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot UDB related CPU, memory, I/O, disk space and other resource contention.
Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Expert experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of UDB related tools
SQL Development - ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints )
AIX operating systems
Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures
Preferred candidates would also meet the following criteria:
Knowledge of 3rd party DBA tools and applications
UDB certification
IBM procedures
Description of work:
-Maintain DB2 databases, perform software upgrades (databases inrichten)
-Perform software patching
-Maintain (2nd/3rd line incident handling and tuning).
-Participate in projects
Please send your CV to James.
Contracts IT acts as an employment agency and employment business. No terminology in this advert is intended to discriminate on the grounds of age and applications from persons of any age will be accepted for this role.