DB2 Database Specialist Brussels

DB2 DATABASE SPECIALIST

For a client of ours in Brussels we are seeking an English speaking DB2 Database Specialist to be assigned 50 - 100% to this project, depending on the needs of the project as well as your availability.

YOUR TASKS:

- - Creation of Materialized Query Table
- - Performance tuning
- - Set up of DB2 database
- - Automatisation of online backup and restore (see example of instructions below)
- - Create and refresh MQT's

REQUIREMENTS:

- - DB2 Administration expertise and experience
- - Commitment to deliver
- - Ready to do overtime when necessary
- - Basic consultancy skills
- - Clear communication
- - Patience to explain DB2 administration activities

Here is an example of instructions:

ColdDB .99
Copy Z:online_backup TO E:/X/
DB2 CONNECT TO HANDIC USER s_Curam_DB2ADMIN USING "2,60000
DB2 rollforward DB HANDIC to end of backup and stop
DB2SET DB2_OVERRIDE_BPF=
DB2 ACTIVATE DATABASE HANDIC
DB2 CONNECT TO HANDIC
DB2 UNQUIESCE DATABASE
DB2 CONNECT RESET
DB2 DEACTIVATE DATABASE HANDIC
DB2 CONNECT TO HANDIC USER s_Curam_DB2ADMIN USING "&_Ser_CdN"
DB2 ALTER BUFFERPOOL LOWMEM IMMEDIATE SIZE
DB2 update DB cfg using NUM_LOG_SPAN 0
DB2 update DB cfg using LOGSECOND -1
DB2 update DB cfg using LOGINDEXBUILD OFF

FOR IMMEDIATE CONSIDERATION PLEASE E-MAIL YOUR CV WITH REFERENCE DB2 TO (SEE BELOW)