- 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.
- Keeping up to date Software Lifecycle (roadmap) management of database products;
- Monitors performance statistics and create reports;
- 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.
Skills, Knowledge, Experience Required:
Mandatory:
- 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.
#J-18808-Ljbffr