Oracle Database Specialist

**JD 02**: ORACLE DATABASE SPECIALIST
**Location**:
Geilenkirchen, Germany
**Security Clearance**:
NATO Secret
**Introduction**:
The purpose is to obtain Computer Information Systems (CIS) Workforce Services for the CIS infrastructure hardware and software used by the NATO Airborne Early Warning (NAEW) at the NATO Airbase Geilenkirchen Germany, hereafter collectively referred to as the Main Operating Base (MOB) or NAEW.
**Skills, knowledge, experience required**:
**Overview**: The majority of systems developed by the NAEW&C FORCE rely to some degree on the presence of a database system. NAEW&C FORCE requires additional workforce to help with the development, testing and administration of databases. There is also an occasional requirement for a database expert to review database designs of capabilities being developed.
- Knowledgeable of both relational and non-relational (NOSQL) database principles, design, implementation and/or administration
- Knowledgeable of Object Oriented Database principles design, implementation and/or administration
- Experience with writing queries and query optimization
- High-level knowledge of other computing disciplines including software development, system integration and IT service provision
- Understanding of polyglot consistence and map reduce technologies.
- Expertise in Oracle Database Administration 11g and higher
- Expertise in Oracle Weblogic Administration 11g and higher
- Expertise in Oracle Forms and Reports Administration 11g and higher
- Expertise in Oracle Enterprise Manager 13c and higher
- Expertise in Oracle Backup and Recovery

**Desirable**:

- Advanced knowledge on Microsoft SQL server 2012 and higher
- Advanced knowledge on backup and recovery of MS SQL server databases
- Advanced knowledge on Microsoft Server operating system
- Advanced knowledge on Microsoft Active Directory
- Profound knowledge on scripting (Bash, MS command line, PL/SQL, Powershell)
- Demonstrated knowledge and experience of NAEW&C Force CIS Squadron organisation, procedures and IT Systems

**Duties/role**:

- Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software and facilities.
- Analyses data requirements to establish, modify or maintain object/data models.
- Evaluates potential solutions, demonstrating, installing and commissioning selected products.
- Uses database management system software and tools to investigate problems and collect performance statistics and create reports.
- Carries out routine configuration/installation and reconfiguration of database and related products.
- Design and implement RDBM and OODBM systems
- Define data structures, logical and physical databases using CASE tools
- Define advanced queries
- Evaluate and select commercial or academic databases for use
- Prepare Data Dictionaries and other related database documentation
- Applies Information Security protection to assigned IT/CIS Services (including software, on-line and archived data, workflows, etc.) iaw NATO and NAEW&C security directives, to include a viable disaster recovery capability;
- Supports product selection and acquisition, trial installations and walkthroughs, deployment, enabler training, testing and release for use, in-house and outsourced technical support and maintenance, and 2nd level user support of each assigned IT/CIS Services;
- Participates in analysis of causes and incidents of IT/CIS Service failures (including IT System trouble-shooting) and effecting/conducting appropriate action to correct problems;
- Conducts data extraction requirements, to include implementing functional solutions

Deployment Requirements
The Consultant is not planned to forward deploy to NAEW&C FORCE Forward Operating or Logistics bases.
On Call Requirements
The Consultant is not required to provide on-call support.
VECTOR SYNERGY sp. z o.o., ul. Marcelińska 90, 60-324 Poznań, NIP PL7811857270, REGON 301575740, KRS: 0000369575