Find Jobs
Hire Freelancers

AWS expert / web app developer to create a REST-enabled database and integrate a basic helpdesk app

$250-750 USD

Cancelled
Posted about 10 years ago

$250-750 USD

Paid on delivery
Summary: I need an AWS expert / web application developer to build an AWS-hosted database with a REST API. It should enable secure access to the database via specific Android apps on the data upload side and an Excel viewer on the reporting side (N.B. you are not expected to build the Android apps nor the Excel viewer). In addition, you should build or integrate a basic web app with a simple UI for "helpdesk" staff to access and manually change the Android user-generated data in the database. Context: For an NGO in Bangladesh, I am managing a project for which we are creating two Android apps, which dispersed field staff will use to sync sales reports and activities back to a central database. The NGO's managers will be able to access this information through an Excel viewer, as well as receiving alert emails, so that they know what is happening in the field. More details of the tasks involved: 1. Discuss with me if the following sequence makes sense on AWS, and suggest & explain any changes which you feel will improve or simplify the project. Then, subject to any agreed changes: 2. Open a free-tier Elastic Beanstalk application using my account, with a database and an object-oriented web application framework. (I will create an ID for you to access my AWS account). Alternatively, if you feel there are good reasons to do so, open “micro” instances of EC2 and RDS, and set it all up manually. 3. Create tables in a new database called "xyz_dev", matching example tables that I will have provided to you. Then create a REST service for the “xyz_dev” database, using an existing framework that supports the creation of REST APIs. 4. Deploy standard web-application security and stability/recovery measures (e.g. automated backups & snapshots, load balancing, password policies, encryption keys, firewall, etc. I have zero expertise so we will need to discuss this topic, and I will rely on you to suggest and implement a sensible solution.) 5. Help to trouble-shoot a few SQL scripts. I will write the SQL scripts, but my SQL skills are "rusty" so I may need support for specific issues. Some scripts will create reporting tables (e.g. sales per region per week, number of beneficiaries reached, etc.), and other scripts will verify if specific alert conditions have been triggered (e.g. list field workers who have recorded zero activity during the previous day). 6. Configure SES to send emails to various email addresses when these reports are created and these alerts are triggered. (e.g. notify the relevant manager if one of his/her field workers has recorded zero activity during the previous day; or notify the whole management team when the main reporting tables have been updated, once a week.) 7. Help to trouble-shoot VBA and REST-connection issues for an Excel viewer tool for the managers, which I will have created. (The tool will have drop-down lists, it will pull relevant information from the reporting tables in the database into a hidden worksheet, and it will then manipulate and display this information in appropriate summary tables & graphs.) 8. Create (or integrate an existing open-source) web app which: o Allows Helpdesk staff to view & change user details, add new products to the database, edit transactions, etc. o Allows users to change their own passwords, view & change their own transaction data, etc. o Allows Helpdesk staff to track issues in a Helpdesk issue-tracking app. 9. Work with the Android developer to integrate the syncing of the Android apps to and from the database. 10. Create an updated “xyz_test” version of all of this every two weeks, so that it can be tested by the NGO's internal pilot team, while we continue working on new features & fixing bugs on “xyz_dev”. 11. Towards the end of the project, create a “xyz_prod” production version of this (probably as a "small" instance, not a "micro" any more), so that we can pilot and deploy the system across the organization. .
Project ID: 5443114

About the project

12 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average $905 USD for this job
User Avatar
Let's start .
$2,061 USD in 10 days
5.0 (41 reviews)
8.2
8.2
User Avatar
hi: i'm an expert in aws as well as web development. I can design and develop an AWS-hosted database with a REST API
$555 USD in 10 days
5.0 (108 reviews)
6.7
6.7
User Avatar
Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service exciting my customers. Please contact in PMB to discuss details. Best Regards, Zeke
$515 USD in 10 days
4.5 (177 reviews)
7.4
7.4
User Avatar
A proposal has not yet been provided
$1,300 USD in 30 days
5.0 (144 reviews)
6.2
6.2
User Avatar
I am a professional software engineer with 9+ years of experience. I am very talented programmer with the following skills c, c++ , java , UNIX, Linux,SSH, PHP, Jsp , Js , advanced js like jquery, extjs, AWS etc. My skill set and experience are best suitable for your requirement. Please assign this task to me I will make sure your work will be completed to your full satisfaction.
$526 USD in 10 days
4.8 (3 reviews)
1.5
1.5
User Avatar
Greetings from Denver, CO! My name is Phil Hendren and I have 10 years experience working in mission critical web apps and website infrastructure. Currently I am employed full time as a Linux Admin for a web operations team with an ecommerce/publishing outfit in Boulder, Colorado. I work specifically with the AWS services that you noted in your requirements on an almost daily basis. I am confident that I can complete your project to your specifications within 14 days for $1000 (I know that might be above your budget -- but I am worth it). I would build your solution using the AWS OpsWorks service if possible, as it would provide more flexibility than elastic beanstalk. The key for this project is doing the work within a git repository (do you have a github account?) Thank you very much for your time and I encourage you to take a few moments to read over my Freelancer porfolio at your convenience.
$1,111 USD in 10 days
5.0 (1 review)
0.8
0.8
User Avatar
I am an AWS Certified Associate Solution Architect. Certificate Number : AWS-ASA-2*** I am working as an AWS Cloud Consultant providing consulting solutions to clients on AWS, dealing with almost every AWS service may it be S3,RDS,Cloudfront,Cloudsearch,SES,EBS etc. I have an extensive knowledge on Migration setups ( LAMP environments) as I have done more than 50 migrations during my experience of nearly 4 years I am pretty new to freelancing as I joined it recently just few days back but I assure you that I am really good at it just trust in me & you will see the results. Recently completed two migration projects on AWS through freelancer.
$722 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BANGLADESH
Dhaka, Bangladesh
5.0
3
Payment method verified
Member since Nov 26, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.