Oracle DBA

Job type:
on-site
Start date:
n.a
Duration:
n.a
From:
Next Ventures Ltd
Location:
Brussel
Published at:
11/23/2018
Country:
flag_no Belgium
Project ID:
1672036

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

Oracle Database Administrator

NV are urgently looking for an 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

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

Please send your CV to the team