* Database Administration
* High Availability
* Disaster Recovery
Required Security Clearance: NATO SECRET
DUTIES AND ROLE
Within the Platform as A Service (PAAS) Service Area of NISC, the incumbent is responsible for the installation, 24/7 operation, monitoring, maintenance, and system administration of all assigned systems related to provide the Database platforms services:
* Monitoring the performance of assigned systems and the definition and implementation of adequate measures ensuring an optimal performance and high availability of the DB services.
* Defining DB backup strategies and ensuring a valid and maintained recovery plan is in place.
* Defining and implementing an upgrade strategy to keep the DB environment current.
* Management/Upgrade/Patching of BI stack, composed of Oracle Analytics, Weblogic, Apache, Tomcat, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator (ODI) and Oracle Analytics Server (OAS).
* Selecting and implementing appropriate DB infrastructure configurations in support of business/technology architectures.
* Performs routine installation, re-configuration, backups of database and related products on on-premises and cloud environments.
* Develops and configures tools to enable automation of database administration tasks.
* Defining and implementing an upgrade strategy to keep the DB platforms up to date.
* Keeping up to date Software Lifecycle (roadmap) management of database products.
* Monitors performance statistics and create reports.
SKILL, KNOWLEDGE & EXPERIENCE
* The candidate must have a currently active NATO SECRET security clearance.
* Strong knowledge of the DBMS technologies (Oracle, MySQL Server and PostgreSQL) and sound experience on at least two.
* Good understanding of MySQL High Availability/Disaster Recovery solutions (MySQL InnoDB Cluster, MySQL InnoDB Replicaset, MySQL InnoDB ClusterSet, MySQL Replication).
* Good understanding of Oracle Analytics with Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator (ODI) and Oracle Analytics Server (OAS).
* Good understanding of ORDS, Apache HTTP and Tomcat administration.
* Current and in-depth knowledge and practical working experience of latest version of the operating systems (Linux/ UNIX and MS Windows Server ).
* A good understanding of more advanced architectures on High Availability and Disaster Recovery solutions, like server clustering and virtual infrastructures.