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 - Feb 8, 2023

Toogit Instant Connect Enabled


Hi ,

I need 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.
  4. Drop the existing user.
  5. Create a new user with default_tablespace (I have an existing script to do this already)
    import the dump to newly created schema and while doing import I should be able to remap_schema and remap_tablespace.
  6. 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 Medussa Multi B
from Departamento de Santander, Colombia

Skills & Expertise Required

Unix Shell Unify Oracle Database Automation Unix System Administration 

Candidate shortlisted and hired
Hiring open till - Mar 12, 2023

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$47.98
Cost

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