Oracle Database Specialist

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

Duties:

- 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 lifecycle support for user account administration, fielded application software and data configuration management;
- Applies quality assurance to fielded application software and support processes and related technical documentation;
- Applies maintenance of IT/CIS Service plans and procedures for lifecycle 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 correctness of application software changes implemented, or to validate new versions of off-the-shelf products;
- Arranges and coordinates SQ internally installation support for assigned application software on server and client platforms, including configuration management;
- Supports 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 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 efficient and effective technical library for assigned software applications;
- Conducts data extraction requirements, to include implementing functional solutions.