Find Jobs
Hire Freelancers

Migrate 5 PL/SQL Store Procedures and Functions to Google BigQuery SQL and UDF

$250-750 USD

Closed
Posted over 5 years ago

$250-750 USD

Paid on delivery
We are migrating from Oracle to Google BigQuery. All the data is aldeady migrated and we have great results in query speed. Now we just need to translate 5 PL/SQL Store Procedures and Functions to the Equivalent in BigQuery SQL (Standard or Legacy) and possible to UDF (User Defined Functions) is needed. The code is not to complex, just a comple of nested SELECTS. No more than 5 pages of total PL/SQL code.
Project ID: 18425050

About the project

18 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

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
18 freelancers are bidding on average $481 USD for this job
User Avatar
I have extensive migration experienced from one database to other I have deep understanding of Oracle database and Google I can migrate as per your requirements please send me message to discuss
$555 USD in 5 days
5.0 (39 reviews)
5.2
5.2
User Avatar
Hello, I am a veteran (25+ years) database developer with real industry experience in Oracle (v6 thru v12c), SQL Server (v7 thru v17), MySQL (4.x thru 8.x), BigQuery and a few others. Over this period of time, I have authored thousands of lines of SQL and procedural SQL code. Apart from technical skills, I communicate near-natively in English. Considered a 10x, no-tall-talk developer. I look forward to working with you on this. Best Regards Kashi
$250 USD in 4 days
5.0 (9 reviews)
4.5
4.5
User Avatar
Have previous experience. You can check via freelancer.com's review. I would like to see the existing scripts. Thanks.
$250 USD in 4 days
5.0 (6 reviews)
3.8
3.8
User Avatar
hi sir I have read your requirements and want to discuss this task with you. I have experience of 5 years as a sr software engineer and have experienced team, ping me for more details.
$250 USD in 5 days
5.0 (2 reviews)
1.7
1.7
User Avatar
I can do this since I am well experienced in gcp Hi, I have 7 years of experience and working on hadoop, spark, nosql, java, BI tools(tableau, powerbi), cloud(Amazon, Google, Microsoft Azure)... Done end to end data warehouse management projects on aws cloud with hadoop, hive, spark and presodb. Worked on multiple etl project like Kafka, nifi, flume, mapreduce, spark with XML/JSON., Cassandra, mongodb, hbase, redis, oracle, sap hana, ASE.... Many more. Let's discuss the required things in detail. I am committed to work done and strong in issue resolving as well. Thanks
$250 USD in 3 days
5.0 (1 review)
1.5
1.5
User Avatar
Hi! I have good experience in Database Programing creating procedures and funtions, developing huge batch procedures and using simple an complex funtions. I have worked in PL/SQL for 7 years, and even I dont' know so much about BigQuery SQL I have checked its definition language and I found easy and understandable. Be free to ask me, Szb
$250 USD in 6 days
5.0 (1 review)
0.5
0.5
User Avatar
I work currently with bigquery at CHAOS ltd in Finland and other GCP services are also familiar to me. I would implement your task probably with bigquery standard sql.
$333 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
DEVELOPER 2000 ORACLE REPORTS, DEVELOPER 2000 ORACLE FROMS PART II & I and DEVELOPER 2000 PROCEDURES. - ORACLE SQL AND PL/SQL. - DEVELOPER6i, DEVELOPER 9i, DEVELOPER 10G, DEVELOPER 11G
$444 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i ' d like to considered for your project . we are a team of developers with a strong background developing skills, including apps of various categories. for 5 years we've worked in a software development company and so we are accustomed to development of all sorts of projects. you can just check my profile to get more info.i highly value professionalism and hold my self strictly accountable to represent my client's brand . we aim to form a long-term working relationship. thank you for consideration.
$666 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working with database and development in sql for 5 years. I have experience with complex queries, store procedures, functions, triggers.
$611 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I work as a PLSQL developer. I don't have experince with Google BigQuery but I think I should finish the project in less than 5 days.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked on both oracle stored procedure in which majorly use of cursor , also I have worked on Google BigQuery UDF in which code is written in JS to make customize business functions.
$277 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good experience in creating udfs in Bigquery. I will prefer going with standard sql. Following are my list of tasks I can think about: 1. Make sure relevant tables for PL/SQL are present in GCS 2. If not, ask you to make them available at GCS. 3. Understand the PL/SQL and form the steps for Bigquery function using standard sql can think possibilities of using data flow if required.
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
México, United States
5.0
1
Payment method verified
Member since Mar 4, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.