Oracle Database Administrator

Spektrum have a wide range of exciting opportunities in several global locations.  We are always looking to add great new talent to our team and look forward to hearing from you.

Spektrum supports apex purchasers (NATO, UN, EU, and National Government and Defence) and their Tier 1 supplier ecosystem with a wide range of specialist services. We provide our clients with professional services, specialised aerospace and defence sales, delivery, and operational subject matter expertise. We are looking for personnel to join our team and support key client projects.

Who we are supporting 

The NATO Communication and Information Agency (NCIA) is responsible for providing secure and effective communications and information technology (IT) services to NATO's member countries and its partners. The agency was established in 2012 and is headquartered in Brussels, Belgium.

The NCIA provides a wide range of services, including:

• Cyber Security: The NCIA provides advanced cybersecurity solutions to protect NATO's communication networks and information systems against cyber threats.


• Command and Control Systems: The NCIA develops and maintains the systems used by NATO's military commanders to plan and execute operations.


• Satellite Communications: The NCIA provides satellite communications services to enable secure and reliable communications between NATO forces.


• Electronic Warfare: The NCIA provides electronic warfare services to support NATO's mission to detect, deny, and defeat threats to its communication networks.


• Information Management: The NCIA manages NATO's information technology infrastructure, including its databases, applications, and servers.

Overall, the NCIA plays a critical role in ensuring the security and effectiveness of NATO's communication and information technology capabilities.

The program

Assistance and Advisory Service (AAS)

The NATO Communications and Information Agency (NCI Agency) is NATO’s principal C3 capability deliverer and CIS service provider. It provides, maintains and defends the NATO enterprise-wide information technology infrastructure to enable Allies to consult together under Article IV, and, when required, stand together in the face of attack under Article V.

To provide these critical services, in the modern evolving dynamic environment the NCI Agency needs to build and maintain high performance-engaged workforce. The NCI Agency workforce strategically consists of three major categorise's: NATO International Civilians (NIC)'s, Military (Mil), and Interim Workforce Consultants (IWC)'s. The IWCs are a critical part of the overall NCI Agency workforce and make up approximately 15 percent of the total workforce.

Role ID – C04844

Role Duties and Responsibilities

• Database administrator services for Oracle E-Business Suite and related applications (e.g. OAS, ECC, Apex, Oracle Analytics, EPM) both for projects and in-service support.


• Handling tickets raised by functional/technical/business users


• Handling alerts raised by the monitoring system for Databases and EBS related applications


• Installation of EBS custom patches and version control


• Cloning of non-production EBS environments from PROD


• 3 monthly installation of the Oracle Critical Patch Update on all Oracle related applications and infrastructure (EBS, Oracle Analytics, SSO, EPM, ECC, OEM, Linux…).


• Monitoring of the EBS suite and its related products like EBS, Oracle Analytics, SSO, EPM, ECC, OEM, Linux, etc.


• Stopping/starting/bouncing of EBS and all its different components (apache, oacore, oafm, …)


• Writing and maintaining Perl and Shell scripts to automate routine tasks.


• Doing general technical trouble shooting and give consultation to development teams.


• Interfacing with Oracle Corporation for technical support.


• Providing 2nd and 3rd line support to the assigned business applications, by responding to service requests, investigating and resolving incidents and problems, communicating solutions or advices to customers and users on changes and improvements based on best business practices.


• Contributing to the gathering, analysis, setup, design and documentation of new requirements and change requests.


• Developing and reviewing documentation such as requirements, definitions, functional and technical design documents, system specifications or other deliverables.


• Providing time estimates for the development and implementation of new requirements.


• Ensures full lifecycle tests of requests for change before they are presented to the user for user acceptance testing.


• Active contribution to relevant projects or service operation across Service Lines where integration is required.

 Essential Skills, Experience and Certifications

• A minimum of 10 years recent practical experience as an Oracle ERP Applications DBA, demonstrating a 36 months sustained period of performance on the previous 2 most recent assignments.


• In this capacity, the Consultant must have performed duties such as installing, upgrading, and supporting (patching, troubleshooting, tuning) Oracle E-Business Suite software and the associated Oracle Technology stack in a multi-tier/multi-node/multi-platform environment, comprising database server, applications server, web server, concurrent processing server, reports server, forms server, admin server, and discoverer server.


• Experience of managing multiple Oracle installations on large systems.


• In particular, the candidate must be conversant with Oracle E-Business Suite Release 12.2 (or higher), Oracle Database 19c (or higher) product versions in Linux environments and at least three of below listed application releases:


• Hyperion – EPM (11.2.4)


• Oracle Analytics BI Publisher Reporting - OAS (12.2.1.4 or higher)


• Identity Management – SSO (12.2.1.4)


• Oracle Enterprise Command Centers – ECC (v12 or higher)


• Oracle Enterprise Manager - OEM (13.5 or higher)


• Practical experience with applying the quarterly released Critical Patch updates on all levels of the Oracle ERP Applications environment.


• Practical experience with Oracle ERP Applications and Oracle Database backup/recovery (RMAN), configuration, sizing, space management, monitoring, patching, upgrades, performance tuning, troubleshooting and administration.


• Expertise in Oracle ERP Applications technical architecture, including knowledge of the underlying database architecture, with particular reference to schemas/products, database objects, file system structure, tables, views, packages, procedures, functions, triggers, sequences, indexes and constraints.


• Broad knowledge of and proven practical experience with WebLogic application server and proven ability in dealing with Forms/Reporting/Apache Web servers and configuring, troubleshooting and tuning


• Sound knowledge of and proven practical experience with advanced topology elements like shared APPL_TOP, Oracle Clusterware, Automatic Storage Management (ASM), Demilitarized Zones (DMZ) and Disaster Recovery (DR) solutions.


• Sound knowledge of and proven practical experience with Oracle's Enterprise Manager 13c or higher.


• Sound knowledge of and proven practical experience with Oracle's Application Management Suite for Oracle E-Business Suite.


• Sound knowledge of and proven practical experience UNIX/Linux and good automation (UNIX/Linux scripting) skills.


• Practical experience with Perl and Shell scripting.

 Language Proficiency

• Fully proficient in English

 Working Location

• Brussels, Belgium

Working Policy

• Onsite

Travel

• Some travel to other NATO sites may be required

Security Clearance

• Valid National or NATO Secret personal security clearance

We never know what new opportunities might be just over the horizon. If this opportunity isn't for you, please feel free to send us your resume anyway and be the first to know if something suitable for your skills and experience comes up.