We are looking for someone that is in the San Francisco Bay Area since they will need to work with the physical server and not virtually.
We are looking for an experienced Oracle DBA with expertise in 12c Standard to setup a development environment instance, including the creation of Bash install scripts to reproduce the setup and rc boot/shutdown scripts.
Oracle 12c RDBMS Setup and Administration
Oracle REST data service (ORDS) setup
APEX 5.0.3 setup
Red Hat Enterprise Linux, CentOS, or Oracle Linux
Git / GitHub
• Make a list of all the non-standard packages beyond a minimal install of CentOS that are required for an install of Oracle 12c
Scripts to install Oracle 12c
o Root scripts that need to be run
o Script that needs to run for the sysconfig kernal parameters
o A script to install ORDS
o A script to install APEX 5.0.3
o A script to change the passwords (main security passwords) so everything can be secured properly
o A script to rebind TNS listener to a new IP
o A script to rebind APEX to a new IP (same as TNS listener optional)
o A UNIX start script for Oracle
o A UNIX shutdown script for Oracle
o A shell script to import/export APEX applications
o A shell script to import/export the data
o A shell script to upgrade the version of APEX
o A script to add a readonly user to APEX table space
o A script to add a readwrite user to APEX table space
o Write a script that gets the current ConnectString. [Is this possible?]
o Document: The installation process. Noting down the order of operations. The order to run the scripts in. Any notes of behavior in between running of the scripts. For example, if there is something that needs to be done after installing APEX but before running the next script.
o Document: Importing a SQL dump and generating a SQL dump.
o Is there a way to encrypt the table space without having to have hands on the keyboard
o Do you know how to set up engineX as an SSL listener, set it up as a proxy for APEX. Webserver front end instead of ORDS. (Write a script to build an install)
o General feedback on the above tasks.