Find more Network And System Administration Remote Jobs posted recently Worldwide

Required Unix Shell,Unify,Oracle Database,Automation,Unix System Administration freelancer for Unix administrator / DBA to write a shell script for automating oracle import job

Posted at - May 16, 2024

Toogit Instant Connect Enabled

Hi ,

I need like to write a unix shell which completes the below steps.

1) Need to connect source ftp server , grep the latest file and copy the dumps from source to local target server (have keyless ssh entry already)
2) place the files under respective client_name folder location and it shouldn't replace last week's old file .
3) Once file is copied , this latest dump needs to imported automatically in Oracle database

Drop the existing user
create a new user with default_tablespace (I have an existing script to do this already)
import the dump to newly created shchema and while doing import I should be able to remap_schema and remap_tablespace.

4) Once import is completed we need to execute a set of scripts and export the schema as a clean dump from the database .

Note : I have an existing script already for the scenario , we need to fine tune it for full automation.
Also, I have some 15 clients and I need a generic script to do this job using client name and schema name. Based on the client name it should automatically grep the name and import as relevant schema in database and need to export.

About the recuiterMember since Mar 14, 2020 Jeevan Sethu
from Gavleborg, Sweden

Skills & Expertise Required

Unix Shell Unify Oracle Database Automation Unix System Administration 

Candidate shortlisted and hiredHiring open till - Jun 6, 2024

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Apply on more work from home jobs posted in Network And System Administration category.

Related Jobs

Latest In Unix Shell Jobs

Latest In Unify Jobs

Latest In Oracle Database Jobs

Latest In Automation Jobs

Latest In Unix System Administration Jobs