Oracle DBA

Job type:
on-site
Start date:
ASAP
Duration:
6 months+
From:
ComTech Europe Limited
Location:
Brussel
Published at:
11/23/2018
Country:
flag_no Belgium
Project ID:
1672118

Warning
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Oracle Database Administrator

Oracle Database Administrator, willing to play a key role in our organisation as the specialist of all our Oracle domain.

Your Responsibilities:

As Oracle Database Administrator, you will be responsible for:

  • Providing guidance and solutions to the different application development team during the development life cycle involving following activities:
    • PL/SQL programming
    • ERD realisation and validation (3NF modelling)
    • Query tuning (xplain, trace)
    • DB tuning (ASH, AWR, Advisor, DB parameters)
    • Writing complex queries (also recursive queries and hierarchical queries)
    • Architectural solution
    • Security model (also GDPR)
    • Data workflow analysis
    • Provide high value technical solutions in Oracle for specific problems
    • Test and Validation through proof of concept
  • Assure daily DBA operational activities covering:
    • Daily Monitoring
    • Day 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)
    • Making the link between the projects and the DBA'S operational team
    • Maintenance of monitoring tools
    • DB installation and configuration
    • Technical 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)
  • PL/SQL
  • Sqlloader
  • EXPDP/IMPDP
  • RMAN
  • Basic Linux knowledge + Scripting

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

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