Create a proxying JDBC driver that implements SQL performance improvement features

Cancelled Posted Feb 20, 2016 Paid on delivery
Cancelled Paid on delivery

I am seeking a mathematically minded, experienced Java developer (or developers) with strong critical thinking and problem solving skills. You will be helping me build a unique piece of specialized software.

This will be a highly rewarding challenge where you will spend up to 3 months working directly with me (an experienced software engineer). I'll be providing a complete technical design specification covering all required logic. You will be required to implement the code based on the spec. I will be helping to test the code.

Working with JDBC, you will be creating a piece of software that takes an arbitrary existing JDBC driver and implements additional features by wrapping it, in particular an ability to re-write certain SQL statements, according to specified rules, into consolidated or multiplexed SQL statements, in order to achieve improved throughput to a database, as well as logging information around SQL statement performance characteristics and outcomes. Some modules will be provided, including the JDBC proxy, which could be based on existing open source JDBC proxy of commercially-friendly licensing, such as org.apache.drill.jdbc.proxy. You will be responsible for delivering a JDBC proxy implementing the aforementioned features, which is specified and illustrated in a 45 page technical design document.

High Level Milestones

- Implement JDBC wrapper (1 week)

- Implement metadata handling, parsing and function activation according to spec (1 week)

- Implement SQL re-writes and batch mode, leveraging provided software specifications and modules (2 weeks)

- Implement multiplexing according to spec (2 weeks)

- Return codes according to specification including asynchronous prefixing (2 weeks)

- Logging performance statistics and any exceptions according to spec, re-using learned information and testing, tuning and minor changes (2 weeks)

Testing of milestones: To facilitate the required testing, there will be a testing window of up to 5 days from the date of delivery, to enable me to test your work while you are working subsequent work. The delivery must include an option for debug level logging to assist the testing effort.

Qualifications looked upon favorably include Computer Science, Mathematics and Physics. You will have demonstrable programming experience, either from your portfolio, or from your involvement in other endeavors. A thorough understanding of SQL and to a lesser extent JDBC is also a must.

Database Programming Java SQL

Project ID: #9711121

About the project

22 proposals Remote project Active Mar 14, 2016

22 freelancers are bidding on average $8132 for this job

Yknox

Hello I'm interesting your project very well I'm a Good Java, JDBC , Database, Math, Algorithm expert. I understand your req exactly. I m quite well experienced in these jobs. Let's go ahead with me I want to More

$7800 USD in 25 days
(520 Reviews)
8.7
islamianwar

I'm a 7-year experience Java developer. I have good experienced working with JDBC. I don't have much to say about your specific requirements because its kind of unique, but I always look for such technically and sc More

$7894 USD in 30 days
(74 Reviews)
8.0
lovinagarwal21

I have 9+ years of exp in java j2ee hibernate spring webservices databases. Done multiple projects like this and almost proficient in design patterns..Checkout my reviews, all projects were completed successfully.

$5111 USD in 30 days
(133 Reviews)
8.1
DavidLiu80

Hi, According to the job description you must be professional manager. I am fancy to work with you next 3 months. I would like to review the technical design specification of the 45 pages. I am sure I am a right candi More

$10000 USD in 92 days
(19 Reviews)
7.1
poornachand

I have 9 years experience in JAVA, J2EE, JDBC and ready to work on this project.

$5000 USD in 90 days
(96 Reviews)
6.8
vishalsarkar2050

Hello, Greeting!! We got requirements, we have team members worked with Deutsche bank, AurursPay payment gateway in core applications and we will use excellent object oriented concepts like Inheritance, Polymorph More

$10000 USD in 90 days
(13 Reviews)
5.8
prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i More

$10309 USD in 50 days
(6 Reviews)
5.1
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

$7731 USD in 30 days
(1 Review)
3.2
PowerDevelopers

Dear Sir this is more than 11 years experience in software development and very interested working with in your project thank you and willing to hear from you soon

$6000 USD in 90 days
(7 Reviews)
3.5
cpuntodanielcc

Hi, how are you? maybe you think i am trying lie, but trust me, i love mathematic , i love physic, trust me i love physic, quantum mechanics, and java/scala. I am Database administrator, i can provide any solution on More

$6813 USD in 90 days
(5 Reviews)
3.2
burhanbvk

This sounds like an interesting project, but before I can commit to any bid I would like to see the technical design document. You can PM me to discuss the project and check my qualifications. Regards

$8000 USD in 70 days
(0 Reviews)
0.0
tamarogreen

A proposal has not yet been provided

$8333 USD in 30 days
(0 Reviews)
0.0
engkanaan

hi Kanaan from Gaza Palestine, computer engineering with master degree, programming java since 2000, and now turn on android, familiar with many android technologies, material desing language. i have background on j More

$8333 USD in 30 days
(0 Reviews)
0.0
ericelp

Hi, I speak English and French. I can develop from scratch or with the CMS/Framework of your choice. Custom PHP, Drupal, Wordpress, Joomla, Django, everything that you need on any CMS or language. Development, co More

$10309 USD in 30 days
(0 Reviews)
0.0