Back to all jobs

Website/Database Design Consultant  Add to shortlist

Client Details

MarkMark M   
United States  United States
  • Member Since: Jul 2010
  • Last Login: 3 Mar 2011
  • PPH Verified: Yes
  • Jobs Posted: 3
  • Jobs Awarded: 2
  • Paid out: $721

Job Details

Category:IT/Web/Programming > Other

ID:31599

Title:Website/Database Design Consultant

Location:Anywhere

Job Description

Seeking expert level advice and recommendations regarding web programming for specific database driven application. Response time (speed) of database query is of critical importance. I have been speaking with many potential web developers. All seem to be segmented and only program in one language or another. I am seeking advice from one individual (who can be unbiased) who will be brought up to speed fairly quickly (within 2 hours) of the objective for the proposed site and said person can come back with a detailed response that could be recommendation of various programming languages for different parts of the site (~2-4 hours). The assignment could be considered complete at that time or may developed into something more long term depending upon the level of success.

Job Budget

Type:Fixed Price

Budget:Not Specified

Additional Information

Attached Files: None

Bidding ends:Bidding Closed

Job Posted:01/08/2010 00:15

Bidding activity on this Job

Bids:8

Who has Bid:


View 5 more bids

Clarification Board

P. K.P. K. on 01/08/2010 07:10
Hello Mark,

Can you tell for what task do you need solution a little bit clearly.

Thanks
Pompy

Reply from Client

M. M.M. M. on 01/08/2010 12:51
Currently, I am in the process of selecting a web design firm to build our company's website. As you can understand, there are many factors to be taken into account during the selection process. I really am looking for an advisor to assist in the final selection process of the web design firm. That would require the potential candidate to have expert level proficency in web programming.Thus, the job involves the following:1. A review of the proposed web build plans (functionality, navigation, database creation, database query, site design) that have already been created to help one identify the programming needs. Database query response is the overall most critical element. With speed being the number #1 concern, programming languages utilized is of the utmost importance. This is where I need advice.2. A review of the proposed submissions from six firms bidding on the project. The submissions are; answers to questions involving how they would construct the site and what they feel are the right: platform, programming languages and databases based upon our stated needs in #1. I am fairly technical overall, but I am seeking someone that I can rely upon who comes to the table with zero bias and understands the objective is not like the firms submitting the bids where they seem to lean towards one programming language (which happens to be their expertise) but to recommend which programming language or combination of languages would work best for the proposed site.Sincerely,MFM
V. T.V. T. on 01/08/2010 12:25
Hello Apply realize competently - professionally at the highest level. Quality of wake satisfied. I work with various companies from the U.S., Israel, Russia, France, Kazakhstan. Can safely rely on me. Ask, discuss the details and get down to work. Regards Basil

Reply from Client

M. M.M. M. on 01/08/2010 12:56
Vasily,Not sure if you can see the reply I posted to another potential candidate so I will repost here:Currently, I am in the process of selecting a web design firm to build our company's website. As you can understand, there are many factors to be taken into account during the selection process. I really am looking for an advisor to assist in the final selection process of the web design firm. That would require the potential candidate to have expert level proficency in web programming.Thus, the job involves the following:1. A review of the proposed web build plans (functionality, navigation, database creation, database query, site design) that have already been created to help one identify the programming needs. Database query response is the overall most critical element. With speed being the number #1 concern, programming languages utilized is of the utmost importance. This is where I need advice.2. A review of the proposed submissions from six firms bidding on the project. The submissions are; answers to questions involving how they would construct the site and what they feel are the right: platform, programming languages and databases based upon our stated needs in #1. I am fairly technical overall, but I am seeking someone that I can rely upon who comes to the table with zero bias and understands the objective is not like the firms submitting the bids where they seem to lean towards one programming language (which happens to be their expertise) but to recommend which programming language or combination of languages would work best for the proposed site.Sincerely,MFM
P. K.P. K. on 01/08/2010 13:40
Thanks for your reply - May I know
Q: You are looking to short list web design firm. Do you want us to take care of that.
Q: You need advice on programming languages/ database / deployment - you are yourself technical thats good to hear. In order to give advice / or bid for this project i have to understand your functional requirements like
* What web application you want to make Eg: enterprise web application likes supply chain, CRM etc, dating website, shopping cart , project management etc
?

You said speed is the main concern. IT looks like you need advice on some enterprise application? is it

Thanks
Pompy

Reply from Client

M. M.M. M. on 01/08/2010 14:17
Pompy (second part),

I see the assignment consisting of three areas:

1. Come up to speed on proposed site needs (20%)
2. Recommendation of best solution for required needs (50%)
3. Assist with selection process (30%)

The proposed site will have very little ecommerce. It will not
be a site selling products. There will be no cart system to speak
of.

I am a chemical engineer who designed a few sites back in 01
02. I am not up to speed with programming languages developed
over the last 8 years and the proposed site will be dealing
with a large database over time. I just want to make sure that
the programming language/platform/database put together in the
next couple of months will be able to handle the load it might
get hit with down the road if the site becomes popular.

As an engineer over the last 15+ years, one usually prides oneself
on accuracy. I would estimate the time it will take to accomplish
the initial job as I have outlined it is as follows:

1 & 2. Approx. 2-4 hours (I can walk you through as well
as point you to an existing site that will help define functionality
needs, etc).
3. Review 4 bids (proposals) approx 30 min each.

If the job assignment is successful, I would probably call
upon in an on-going consulting role over the next couple of months
as the site is being built. This would be outside the original
scope here.
P. A.P. A. on 01/08/2010 14:05
Mark, we all have some technical bias that comes from what we have worked with and the technologies we know.

It sounds as though you are looking for "THE" answer, but just like with most technical things, there are loads of differrent ways to achieve the objective.

You have already suggested that response times will be dependent on the speed of the database response. There are a lot of database systems capable of responding quickly. How fast they are depends on your host, or maybe the google appcloud..

You speak of segmentation in programming expertise and that's because nobody can know it all and there are many ways to skin the proverbial cat.

There is no chance of getting someone without any bias unless they know little about anything in equal proportion. Most people would look for someone who had already built similar solutions and take their advice or take advice from several people and then make a choice.

Reply from Client

M. M.M. M. on 01/08/2010 14:30
Paul,

You have hit the nail on the head! I am looking for THE answer and
I understand most will have bias's. But, what I am hoping for
going this route from an advice side is that once the candidate
reviews the proposed site, unlike the web development teams that
are looking to build the site (who WILL have a bias for their own skill set) he or she will tell me what is probably the best way to build
the site not because it's what they are selling, but it is what
they believe. SOME BIAS should be removed at this point.

That is why I am looking for someone who is well versed in:
Java, C, C++, .net, PHP, Ajax.

It doesn't mean they have to write the code, it just means that
they can look at the proposed site and recommend in their mind
what will work best.

And then, I would forward the proposals at that step and ask:
from what you recommend and what is proposed by these four development
firms, who would you chose?

That's it in a nutshell.
Mark
P. K.P. K. on 01/08/2010 15:05
Hello,
I have roughly though about

You would require the following :

* Content delivery network (this is very important for content sites) see en.wikipedia.org/wiki/Content_delivery_network
for hosting images, videos etc. Its like a caching stuff (if you website is hosting loads of images and stuffs)
These are few CDN vendors
Akamai
•Amazon S3
•BitGravity
•Cachelogic
•CacheFly
•Limelight Networks
•LocalMirror
•Mirror image Internet
•Panther Express
•SAVVIS, Inc.
•VitalStream
•Peer 1 RapidEdge
Mirror image

Mirror Image is good (i heard they have simpler documentation and easy to implement)
(hence your application must be made taking the above in mind)

* You need to consider other things in mind
- load balancing the server
- having a dedicated machine
- defragmenting it regularly ( for that u need to fix schedulars)
- Getting a nice dedicated box and having maximum RAM

* Also keep the database seperate. [Having backup schedulars etc]

Now the most important thing :
* Choice of programming language depends on various criterias. Every programming language has advantages and disadvantages.But nowadays it taken in terms of :
- Speed of development
- Availability of 3rd party components
- Cost of those 3rd party components
- Availability of resources ( For example: if you are using php then it would be relatively easier for you to find resources. And generally php resources are cheaper. (I am sorry to use

the word resource - but it has become so general i can't help it)
- Integration of the application with other application (if the related application with which your current application is being integrated is in different technology then its better to go with

that - but still it depends from project to project. Offcourse if the related application is in perl , you can't go with perl in this modern world)

* Also when the programmers work - good SVN setup - good coordinator etc are very important to increase the speed of development. But it has nothing to have with the final project

(its actually believe following a better process of development doesn't guarantees the performance of product)

* Now for optimization
- good xhtml validated script
- its better to use jquery (for ajax and all)
- For database paging - its better to cached output [do selective caching]
- Selectively loading data via ajax. (Eg: A schenario for example you have shown 100 forum records - now when you just scroll down and come to the edge you load another

100..another 100 and so on .. (you can see this in youtube comments) -- because way the user interface is displayed matters alot.
- Yes in the background regarding the database size - mirroring it .. transferring (moving) the old records to another table [Via daily or weekly schedulers] etc etc. But all these

depends on the schenario we face.
- Also caching the controls etc -- keeping calculated records in different stats tables.. for example: top performers, their points etc etc.


There are lots of other small things which can be considered. But primarily break down to :
1) Caching web pages, controls and images
2) Xhtmlized pages and optimized pages.
3) Database optimization scripts (like log files removal, backing up etc)
4) Mirroring and load balancing the server
5) Hardware of server
6) Programming language selected based on criteria which i mention
7) Ajaxification and loading selective records (based on calls) -- predictive/intelligent data loading so that we know when the user clicks next button the data loads immediately (this

gives an impression to the user that it has loaded very fast - i think this is used in gmail while loading mails) Also you saw that comment loading example on youtube.
8) Schedulars can defragment , automatically calculate statistical data for future retrieval, selectively moving old records to other database.


Cheers!

Reply from Client

M. M.M. M. on 01/08/2010 16:33
Your brief is what I am seeking. Once the consultant/adviser is selected I will supply the concept

I am not sure why the rest of my post is not here...

Basically, I will reiterate. What you have stated above is what I am
seeking. The next step is once I select the adviser is to forward the
defining email of the concept for the site. Then to point and have
the adviser walk through a current website with similar functionality
as the proposed site. To review the two documents that point to
logistical concerns/needs defined in greater detail. And finally to
forward the 4 bids/proposals already received for recommendation.

Sincerely,
Mark
P. K.P. K. on 01/08/2010 16:42
Ok whenever you have something then you can request me to bid or you want me to bid right away ! Or is it going to be ongoing advicer role ?

Thanks
Pompy

Reply from Client

M. M.M. M. on 01/08/2010 16:51
Pompy,

I am ready to receive bids now for the assignment. If the candidate
chosen is successful in aiding with the below mentioned details,
then I can definitely see a role being there throughout the process
of the build as issues/questions/concerns come up.

But, for now I would recommend bidding on a fixed fee basis for
the advisory role of:
1. Reviewing the site and it's concept
2. Recommendations for platform/programming languages/database and
any other issues deemed critical for dynamic database driven site in
it's early defining/development stages.
3. Review and recommendation on which vendor or development firm
I should choose, based upon their proposal.

P.S. To clarify, it doesn't mean that I might not stick to my
own viewpoints and select the vendor I already have in mind. I
don't mind paying for advice that I might not take - I just
want another technical person's viewpoint with regards to the
decision making process.
P. K.P. K. on 01/08/2010 17:00
I got it - you need someone in your advisory panel - who would just cross check (just for double checking things) what you decide.

Just like if you got bad disease - you just get it crossed checked from a doctor as a 2nd / 3rd opinion

Warm Regards
Pompy

Reply from Client

M. M.M. M. on 01/08/2010 17:06
You got it!

P.S. I am looking to select the vendor to start the build in
the next 48 hours.

Sincerely,
Mark
T. S.T. S. on 01/08/2010 21:14
Please clarify "level advice". Is the requirement forensic, liability, IP, etc.? Please clarify the relationship between the 'legal' advice and choice (advice thereto) of programming language and DB query protocols.

We have a legal team that provides counsel and advocacy on these matters in respect of all our web 2.0 developments.

Regards
TMIT

Reply from Client

M. M.M. M. on 01/08/2010 22:18
The "level" of advice does not need to be entry or mid-level. It
need not be someone with 2 years experience in programming for
database driven websites. I myself would qualify under this requirement. I am seeking someone with "expert" level background.
An individual with a BS and MS degree in computer science/programming or
someone with at least full time experience over the last four years in development of dynamic database driven sites utilizing various programming languages (Java, C, C++, ASP, PHP, etc) depending upon
the needs or desire of the application at the time.

I was not referring to seeking any legal advice at all.

MFM

Bidding closed

Stay safe: Read our safety guidelines before bidding

Bidding has ended for this project, the client has accepted the bid(s) below:

Accepted Bid #1

Amount: $94 Fixed Fee

Country of Freelancer: India  India

Acceptance Reason: Pompy,

Actually, let us begin the process as you are already into the evening in India. Please review the beginning email and definitely sign up (free) and log into the website whose functionality is almost the same as the one I am proposing. Once you have a feel for the site, I will also send you a 38 point Scope of Work word doc that should help clarify the focus of the work. I will also forward the second word doc that I put together for the vendors to respond to. This is the one I am still awaiting two responses for.
You can make your recommendations for what you believe the platform,programming languages and database should be based upon these inputs. Then, once I have the vendor responses finalized, I can forward and you can make recommendation of your top two.

That's it for now.

Mark

Estimated Start Date: Within 1 Business Day




Accepted Bid #2

Amount: $314 Fixed Fee

Country of Freelancer: United Kingdom  United Kingdom

Acceptance Reason: Atif,

Please forward the best email to send you the supporting documents to date. Sincerely, Mark

Estimated Start Date: Within 1 Business Day





Here are some practical tips on staying safe


Remember: if something looks too good to be true, it probably is!

If you are in doubt of the legitimacy of a Job and or Client, let us know by Reporting the Job.

For further support on preventing and reporting fraud please contact the UK’s National fraud reporting centre at http://www.actionfraud.org.uk/ or outside the UK Fraud Watchers at {fraudWatchers}