Oracle Database Administrator

Job Title: Oracle Database Administrator
Contract Type: Contract
Location: Brussels, Belgium
Salary: Négociable
Start Date: ASAP
Reference: 72959-ITBEL-STC_1543483445
Contact Name: Sacha Custers
Contact Email:
Job Published: November 29, 2018 09:24

Job Description

Your Responsibilities:

As Oracle Database Administrator, you will be responsible for:

· Providing guidance and solutions to the different application development team during the development lifecycle involving following activities:

oPL/SQL programming
oERD realisation and validation (3NF modelling)
oQuery tuning (xplain, trace, …)
oDB tuning (ASH, AWR, Advisor, DB parameters,… )
oWriting complex queries (also recursive queries and hierarchical queries)
oArchitectural solution
oSecurity model (also GDPR)
oData workflow analysis
oProvide high value technical solutions in Oracle for specific problems
oTest and Validation through proof of concept

· Assure daily DBA operational activities covering:

oDaily Monitoring
oDay to day DBA tasks (import/export, space management -TBS - ASM, problem solving, ACL, Schema management, security, session, promotion management, application migration to an other db, …)
oMaking the link between the projects and the DBA'S operational team
oMaintenance of monitoring tools
oDB installation and configuration
oTechnical lead on DB upgrades and migration

· Be the first technical support in the scope of the projects and in operations

Your technical knowledge :

You are a specialist of the Oracle domain covering both Oracle administration and Senior Oracle developer aspects.

The Administration aspects requires:

·Administration of Oracle 11R2, 12R1 and 12R2.
·APEX 5 (Oracle express)
·SQL (Oracle style and sql ansi standard)
·Basic Linux knowledge + scripting

As a Senior Oracle developer, you master the different skills of DBA oriented development:

·Kind of tables to use
·Materialized view
·Use of context
·Dynamic queries
·Links (db_link, Sqlloader, impdp, Sftp, ..)
·Transaction validation (A.C.I.D.)
·Java in DB
·Scheduler Job
·Triggers (tables, system)
·Data security
·Data loading

Your Profile:

·You have a master degree in computer science and at least 10 years of relevant experience as DBA and/or DB developer
·You're passionate about technology
·You're fast and eager learner
·Languages : English (very good in reading, writing, speaking) is a must