DB2 DBA - Brussels, Belgium - French Speaking - 9 Months+

DB2 DBA - BRUSSELS, BELGIUM - FRENCH SPEAKING - 9 MONTHS +

One of our blue chip clients is urgently looking for a DB2 DBA.

Main language English

Second language French

Assignment percentage 50 to 100%

Job description summary Database specialist DB2

Responsibilities - Creation of Materialized Query Table

- Performance tuning
- Set up of DB2 database
- Automatisation of online backup and restore; refer to example of instructions

IT-Skills - DB2 database administration specialist

- Business Intelligence

Example of instructions:

ColdDB .99

Copy Z: 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

create and refresh MQT's

DB2 -stvnf C:/Users/gert.kraats/mqt_all.txt > C:/Users/gert.kraats/mqt_all_mde.out

DB2 GRANT DBADM ON DATABASE TO USER BO_DGHAN

Soft-Skills Basic consultancy skills

Clear communication

Patience to explain DB2 administration activities

Screening requirements - DB2 Administration expertise and experience

- Commitment to deliver
- Ready to do overtime when necessary

Please send CV for full details and immediate interviews, We are a preferred supplier to the client.