Create a proxying JDBC driver that implements SQL performance improvement features
$5000-10000 USD
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.
Project ID: #9711121
About the project
22 freelancers are bidding on average $8132 for this job
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
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.
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
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
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
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
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
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