need sql/pl sql developer to create scripts

₹100-400 INR / hour

Closed

Posted

over 7 years ago

₹100-400 INR / hour

The first for of the assignment involves the uploading of a dataextract from the production database. You will be provided with a number of files. These will include the DDL for the tables and the initial data extract for each of the tables. The initial data extract will consist of scripts that you can run. These will insert the data into the tables (you do not need to write code of this part). In your Oracle schema you should run these scripts to create the tables and populate them with the initial data extract. Full ER diagram to represent the tables extracted from the production schema ! Details of all primary and foreign keys that you can identify ! A data dictionary Files include: [login to view URL] -â€ -â€ ddl script to create the tables [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] These files can be found on the module webpage and should be saved to your U:\ drive In SQL Developer run the following commands to run these SQL scripts @u:\[login to view URL] @ u:\[login to view URL] @ u:\[login to view URL] @ u:\[login to view URL] @ u:\[login to view URL] @ u:\[login to view URL] @ u:\[login to view URL]

Database Administration

Project ID: 12082792

About the project

26 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

26 freelancers are bidding on average ₹263 INR/hour for this job

@jagdishbhatt38

I have more than 7 years of experience in IT industry. I have worked on .net with SQLSERVER and Oracle. I can provide you better solution by utilizing my knowledge and skills.

₹300 INR in 16 days

4.9

(25 reviews)

4.8

@ksinghrajeev

I can do this for you. I am an OCA. I will need two weeks of time to do this since I work part as freelancer. If you are ok with my bid then let me know. Thanks, Rajeev

₹400 INR in 40 days

4.9

(3 reviews)

2.8

@bistanil98

Need to discuss this in detail,please tell me how we can start the discussion on this requirement. We have a team of 34 professionals,they have more than 11 year of experience, expertise in php/mysql and their MVC frameworks like laravel-4,symfony-2,cakephp,html,html-5,bootstrap, etc, so we can manage this work.

₹400 INR in 40 days

1.9

(17 reviews)

6.6

@ankit4444

I am a working professional with Oracle certification in DBA and PL/SQL programming area. I have worked extensively on PL/SQL domain and in Unix shell scripting. I believe in following some basic core things before submitting any work: 1) Understanding the requirements from client's perspective. 2) Developing in efficient and understandable manner with suitable comments. 3) Thorough unit testing before delivery. You won't complain. Thanks Ankit Vohra

₹277 INR in 40 days

0.0

(0 reviews)

0.0

@softmatrixlx

Hello, I understand how important it is for you get accurate information for this project keeping keen eye on details of data. I would do my best to give you desired outputs. I have experience in Data Conversion, Data Import/Export, Website Posting, Excel Formatting. I have completed projects successfully in these areas on other freelancing site. I am also knowledgeable in working with raw data files such as text documents, xml, csv and organizing this data in MySQL/Oracle database. I am aware of consistency, accuracy and patience needed for this project. I assure you to be reliable and cost effective all the way.I would really be thankful if given opportunity to work on this project to enhance my Freelancing career. Thanks and regards, Sunil

₹305 INR in 40 days

0.0

(0 reviews)

0.0

@ajayyadav7827

I have 2+ years of experience in SQL, data warehousing and BI working for one of the largest retail clients

₹388 INR in 20 days

0.0

(0 reviews)

0.0

@abrahamsnyders

Expert in data manipulation in SQL relational databases

₹300 INR in 30 days

0.0

(0 reviews)

0.0

@amrit78

I have 14+ experience in oracle sql/plsql and dba jobs.I will do it as per your requirements in time.

₹333 INR in 40 days

0.0

(0 reviews)

0.0

@madan1976

I am having 16+ Yrs of Experience in Administering Oracle databases of all versions. I have ninche skills in Oracle database Adminsitartion, Upgrades, HA, Disaster Recovery Setup, Performance tuning , database upgrades, Cloning , Platfom Migrations,, Currently Leading the Team in Singapore.

₹277 INR in 40 days

0.0

(0 reviews)

0.0

@ShankarDMTDWH

Mastering SQL Server , SSIS , SSRS , SSAS. I am responsible for the Design and the Development of the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2. The database is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL. For performance reasons the KPIS are replicated to another DB which exploits the reports via SSRS to the consumers. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Finally several other reports are daily automatically produced and sent via email to the recipients.

₹222 INR in 40 days

0.0

(0 reviews)

0.0

@nitinbh12

A proposal has not yet been provided

₹333 INR in 4 days

0.0

(0 reviews)

0.0

@raamalakshmanan

I would like to do this as a free service. Please contact me raamalakshmanan with gmail +919962100810

₹100 INR in 10 days

0.0

(0 reviews)

0.0

@amarjotrocky

My name is Amarjot Singh working as Oracle developer/database developer from last 7+ yrs exp. I am proficient in writing Packages, procedures, function and also hands on experience in performance tuning. if you feel my profile is suitable for this work then you can contact me. Thanks and Regards Amarjot

₹166 INR in 40 days

0.0

(0 reviews)

0.0

@selvadba

Hi Sir, Have been working for 3 years 3 Months in Oracle Administration and PLSQL Developer when ever needed requirements for Developers and Clients on time , And also oracle certified to help you on future oracle support with your preferable cost . And currently working on two clients offline not listed in this site . One is for Oracle 12c cloud administration and another one is for MySQL server . I Will ready to pick your call on any time and my work will be speak to you Currently working in Datawarehousing environment for migration of SQL Server related reporting and processing procedures into Oracle exadata 11 g in current company

₹100 INR in 40 days