Need Help Trouble Shooting One Issue - repost 2

Hi, I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have expertise in writing complex queries with proper joins and index selection. In past, i involved in balancing between concurrency and locking and lock escalation. Microsoft Certified Technology Specialist in SQL Server. Thanks, Ajay

Greetings, We would be able to analyze the situation for $500, however the bidding settings of this project do not allow us to put a bid for that amount. Access to both dev and live systems would be required to analyze the data structure. Best Regards, Andrei Dev Experts Team

Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 5 years of experience. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://www.freelancer.com/u/nibiranijum.html I am confident on delivering quality. If you wish, I can show you my existing projects. Rgds, Shafiq

Aucune proposition n'a encore été fournie.

Hi I have more than 10 years experience in Database administration and develop SQL query. Please see my profile. Thanks.

Hello, Maybe you have a index issue. I can resolve this problem in few hours. let me know the way that you wish want to connect to your database to resolve this problem. regards Pedro

Dear there I could help you now. Please send me database dump with some data, also query itself Thanks & B/R

Hello. I am experienced PL/SQL developer. Ready to look at your query. Would be easier to troubleshoot if you provide sample data as well. Regards

I worked on this type of queries earlier as part of my development so i can do very quickly i have good experience with analytical functions

First I might suggest that your development system and production system don't contain the exactly same data and hence your results may be different. I have had similar issues before with queries. The joins may be missing some criteria and thereby returning more than a single roe for a result.

A proposal has not yet been provided

I'll do it. It should not be a problem, solve the complexity of the query. It will be easier if there are any help;) Is there a database schema? Although the parts used in the query? Is the work has to be dry or productive database?

I hope you accept my bid. I'm new here at Freelancer so there is not feedback of me yet, however I am very experienced in Oracle so I'm very confident that I can do this without trouble

Hi, I am an Oracle Certified Professional and SQL Server Certified DBA. I would like to help you. Could you make an export of your database and send me your query. I think the bid is with a wrong value, so I could do it for US$ 50.

Have worked in a project that involved around 50 tables. Was the database design team members of this project. Worked with lot of SQL query optimizations for this project. Also worked in database projects that required upgrading an existing sql database to newer version with new tables and alterations to existing tables. Also required transfer of data from old database to the new one.

Hi, I am an SQL expert, worked with Oracle solving these kind of bugs which you are facing for more than 6 years. So would like to resolve this issue of duplicate amount by probing in more into your 8 tables, and its data and understand the issue is 'with query or data'? Thanks Sree

A proposal has not yet been provided

Hi, As per your project description I will be able to find the root cause and may be resolve the issue of one SQL of around 50-60 lines joining 8-10 tables with in 5 days max. I do production support on Oracle database for last many years and we often resolve this kind issues related to the SQL or with some in correct data or joins. So, I think I am your best bet. I know I am new to the Freelancer.com but I am sure that I can help you in solving your issue. Also since this is my first project on Freelancer - I can provide the least price to resolve the issue. Thank & regards, Raj

A proposal has not yet been provided

Basically, I am an Oracle developer who also work for fixing issues in client environment. So, I feel I would be able to fix the issue.