About this job

We are recruiting a Oracle Specialist for Sapienza to work on our Customers Site (NATO NCIA, Geilenkirchen, North Rhine-Westphalia, Germany)

Responsibilities

The HQ is looking for an Oracle Specialist to support their process of accrediting a large number of software applications and systems. They have a large number to tackle, plus new capabilities come online all the time. The specific tasks identified for the role, and associated skill/knowledge requirements, are as follows:

• Maintains (both in-house and outsourced) application software hosted on NAEW&C networks and stand-alone IT/CIS Systems (Data and Support Software). Includes logistics software that are used in support of Weapons Platform and are Mission Critical
• Applies life-cycle support for user account administration, fielded application software and data configuration management
• Applies quality assurance to the fielded application software and support processes and related technical documentation
• Applies maintenance of IT/CIS Service plans and procedures for the life cycle and supporting functions for assigned applications software
• Implements of IT/CIS Service Requests for changes and maintenance to fielded applications
• Conducts integration tests to validate the correctness of application software changes implemented, or to validate new versions of off-the-shelf products
• Arranges and coordinates SQ internally the installation support for assigned application software on server and client platforms, including configuration management
• Supports the conversion of legacy product application software into new IT/CIS Service environments
• Supports technical reviews of contractor produced application software and data packages
• Applying core data structures to COTS/NOTS and contractually delivered software applications
• Applies routine and contingency support for application software maintenance and support efforts at FOBs/FOL and at other deployed locations
• 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
• Provides technical advice and support on assigned application software to external partners and industry
• 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 troubleshooting) and effecting/conducting appropriate action to correct problems
• Maintains and operates an efficient and effective technical library for assigned software applications
• Conducts data extraction requirements, to include implementing functional solutions

The successful candidate will work on site at NAEW&C Force HQ in Geilenkirchen under the direction of the Head of the CIS Support Squadron or designated Section Chief.

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 manpower 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.

Activities to be performed:

• 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
• Revise database design; implement stored procedures, triggers; apply normalization and other harmonization activities
• Define advanced queries
• Use built-in Data Access classes in Application Frameworks to create Database Interfaces and classes in applications to be able to access and manage databases
• Evaluate and select commercial or academic databases for use
• Prepare Data Dictionaries and other related database documentation

Deployment Requirements:The incumbent is not planned to forward deploy to NAEW&C FORCE Forward Operating or Logistics bases.

On Call Requirements: The incumbent is not required to provide on-call support

Profile

• REQUIRED SECURITY CLEARANCE: NATO SECRET
• 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
• Expertise in applying Oracle related security updates and Operating System security updates Note With respect to administration of Oracle Services – 85% will be on Microsoft Windows operating system and 15% on UNIX/Solaris operating systems

Desirable Specific Experience:

• 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)
• Preference will be given to candidates with a demonstrated knowledge and experience of NAEW&C Force CIS Squadron organisation, procedures and IT Systems.

Please send your CV (in English) as soon as possible to jobs@sapienzaconsulting.com

For information on how we process the personal data in your application, please see the Sapienza Privacy Statement here.