About this job

Sapienza Consulting is recruiting Oracle Specialist to join NATO – NCIA, at Geilenkirchen, North Rhine-Westphalia, Germany.

Responsibilities

• 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 trouble-shooting) 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

Additional activities

• 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

Profile

• 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
• Must hold Security Clearance NATO Secret
• Fluent business English; knowledge of another NATO member-state language is an asset

Desirable specific expereince

• 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)