Database Administrator

We have an Amazon Web Services hosting setup that provides an API-like connection to our clients. We are currently using:

Elastic Beanstalk: For the creation of separate work environments (Dev, Beta, Production) and the simplification of pushing updates to different environments via GIT.

EC2 auto scaling/load balancing: Scales the servers that provide access to the UI and the client connections.

Elasticache: Manages session data across EC2 instances. Also stores client IDs from our member database.

Route 53: Manages a collection of domains to be used by clients to connect.

RDS: Stores all settings for our tools as well as full logging for our client's connections

We currently are handling connections from about 60 users, each connecting multiple sites. We are probably looking at about 2 million hits to just the remote connections per day right now. We have about 140 more members who will be accessing this in the future, and the current users are likely to scale up. It's very important that we are able to handle that traffic while keeping our expenses manageable. Some of our clients send paid traffic to their sites, which can cause some significant load spikes on our end. EC2 scales easily, but the database can't keep up.

All the instances are running PHP applications and the RDS instances are using MySQL.

We need someone to help us to:

1. Find out the best option for our problem (cost, reliability, performance)

2. Help us to optimize the server (Mostly for RDS, but input on the EC2 setup will be appreciated).

We are open to recommendations of other AWS services if we can improve our cost/efficiency.

We're constantly developing new tools. Great work on this project would almost definitely result in more work in the future.

Excellent English (read/write) is required.

This is a fixed price project. Within 1 week we expect you to provide your recommendations and discuss them with us, along with your estimate of the associated costs and the time required for you to implement your recommendations. Together we will then decide on a plan and you would then carry out that plan and you would continue to administer the database for a further 3 weeks. So you are bidding on a project that will be completed within 4 weeks. There is no way for us to know in advance how much, or how little, time it will require so keep this in mind when you bid. It may require a few hours per week or many hours. We do not care. All we care about is whether, at the end of the 4 weeks we are happy with the value of the work done compared to what we paid for it. If we are happy, we will offer you a longer contract to administer the database.

We are very good to work for when we receive value for value. We have a history of hiring on oDesk under the names Excess Marketing and Integral Publishing.

Important. Subsequent to posting this project we have determined that Amazon's Redshift database is more suited to our needs. While we will be keeping RDS for our OLTP needs (settings storage, user databases, etc), we will also be using Redshift as we need fast, but fairly simple, read/writes more than complex transactions for our logging as that's where our bottleneck is. Essentially we need someone to review the work that our developer has already done and provide confirmation that it is optimized for efficiency or to provide recommendations for how to achieve greater efficiency. We need this completed within 2 weeks at most. Great work may lead to a further contract for ongoing database administration. The additional information in this paragraph supplants and supersedes any conflicting information in the original project description. If you have already submitted an application, please update it if necessary. Proficiency with Redshift is now a requirement.

From the updated summary of the project I had neglected to include that you will be responsible for implementing your recommendations as well.

Beceriler: Veri Tabanı Yönetimi, Veritabanı Geliştirme, Veritabanı Programlama, MySQL, PHP

Daha fazlasını gör: who's hiring right now, what is odesk all about, we will write your marketing plan for you, web developing costs, this day in history database, the best option to developing for web, remote php contract, remote full time php, odesk work week, odesk users, odesk how to, odesk history, odesk help, odesk fixed price contract, odesk fixed price, odesk cost, odesk contract, odesk client, odesk api php, need someone to write a contract, how would you write someone who's hiring, how to work with odesk, how to improve web traffic, how to find clients for marketing, how to connect to mysql database using php

İşveren Hakkında:
( 1 değerlendirme ) New Glasgow, Canada

Proje NO: #6524651



Hey Guys, I read your description. The work looks interesting. But before I proceed. Let me quickly give you some background about me. Hi, I have 14 years of Linux and web server management experience. Though I a Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 740%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)

10 freelancers are bidding on average $620 for this job


Hi we are currently doing the same type of work for one of our clients on Amazon AWS our conclusion was to get rid of the RDS and move data to non relational database, in this case this was feasible. we choosed Dy Daha Fazla

in %bids___i_period_sub_35% gün içinde526%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(171 Değerlendirme)

Hello, I have read your post and understood your requirement. I have great experience in handling Amazon Web Services/Wordpress /Magento/Joomla/Drupal/ HTML5/CSS3/PHP/Java/Python/Javascript/MySQL/ Kindly go Daha Fazla

in %bids___i_period_sub_35% gün içinde789%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(60 Değerlendirme)

Hi Sir, I have 4 years exp as DBA on both aws ec2 and joyent cloud. Currently i'm working as a DevOps to build our infrastructure in ec2. we are using apache traffic server to cachinge, elasticsearch with mongodb, r Daha Fazla

in %bids___i_period_sub_35% gün içinde666%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(46 Değerlendirme)

Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them. Hope they Daha Fazla

in %bids___i_period_sub_35% gün içinde736%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(35 Değerlendirme)

Hello, Greetings from geniuskline webtech solutions pvt ltd. Following are our past work, have a look. [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] ht Daha Fazla

in %bids___i_period_sub_35% gün içinde670%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)

I am specialize in C++,C#.net,ASP.Net,JAVA, PHP, MySQL, Wordpress, e-commerce websites and portals, payment gateways and customized web based applications. my aim to deliver quality products to our customers within spe Daha Fazla

in %bids___i_period_sub_35% gün içinde736%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(31 Değerlendirme)

Hey, I am an expert MySQL DBA and an optimization expert working on MySQL. I have worked on various linux platforms and MySQL versions. I have worked on MySQL servers running on RDS and EC2. I am a tech speaker and Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hi, We are a 1000 + employee firm. Charging 6$ an hour. Can start any technology immediately. Direct access to developers via skype, G talk and hotline – 24/7 availability for all 1000+ resource. We can bet you that Daha Fazla

in %bids___i_period_sub_35% gün içinde515%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Hello I am Brijesh Patel software developer of .net , I have 4+ Exp in .net and different technology, 1..Net Technologies 2. C, C++ , Core Java , Advanced Java , Python [url removed, login to view] , Wordpress, Joomla, Mengendo.etc.. 4. Daha Fazla

in %bids___i_period_sub_35% gün içinde700%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hi, I am a dynamic problem solver and seen your details can assured you to do it best for you exactly as you expecting with great quality and faster complete rate. I am started new here but doing Php(Frameworks a Daha Fazla

in %bids___i_period_sub_35% gün içinde526%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Daha Fazla

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)