Færdiggjort

DB and DW setup in AWS via IaaS script (Terraform or other)

We have a project data modelling cross platform application that we are in the early stages of building. The application will be storing data in both transactional databases and in a data warehouse where we will be looking to build various Power BI dashboards and reports from.

Presently we have a blank AWS free tier account and some simple table data in Excel / Access, and need to move this into a database, then from that database via some simple ETL's we want to get the data into a data warehouse environment, so we can begin to build the Power BI Dashboards and reports that our cross platform (web and mobile apps) will consume.

We are open to what database we should install, be it Maria DB, My SQL, Postgres, SQL Server or other.

What we seek from this assignment is to find someone experienced in creating IaaS scripts (terraform or other) to setup two environments (Dev and Production) with the agreed database and Data Warehouse servers in place and ready to receive data.

We will load our excel / access data to the database, but would need help with setting up the Data Warehouse (fact & dimension tables plus ETL) for one of the tables to prove operational working of the DB and DW.

Deliverables:

-------------------

1) Database and Data Warehose technologies recommended and selected (agreed)

2) Minimal Costs of operation but expandable to suit future demand

3) Terraform or other IaaS Code scripts to create Dev & Prod Environments with operational DB and DW in line with CI/CD and DevOps practices

4) Costs of operation easily manageable - knowledge transfer about how to manage our AWS costs etc.

5) Willingness to partner with us on future assignments (such as management of the AWS environment and/or other ETL's and DW data models)

Assignment Notes:

------------------------------

1) While we are in development mode we are looking to save costs, as such we have an AWS free tier account. Having said that if we need to purchase tools and or services to get the beset development environment we are willing to appraise the merits of purchasing additional pay for services.

2) Whilst we are looking for someone experienced in setting up AWS DB and DW services (as well as designing DW fact/dimensions and ETL's) we are happy if the assignment winner utilises exisitng code scripts such as those that can be found on library sites such as [login to view URL]

Successful Candidate attributes:

---------------------------------------------------

* Experienced with AWS platform and environement configuration

* Experienced with Terraform or other appropriate IaaS scripting

* Experienced with Database and Datawarehouse setup

* Experienced with Datawarehouse Fact / Dimension table modellng and setup

* Experienced with building / coding the ETL's between the selected database and datawarehouse

Evner: Aws Lambda, Database Administration, Data Warehousing, Amazon Web Services, Databaseudvikling

Se mere: test script installshield project, delete script php project, php script auction project, php script simple project manager, free java script menu project, inno setup sql express script, inno setup instal sqlexpress script, inno setup custom form script, testimonial script full project, database script installer project, shell script database project linux, setup apointment online script, setup aws server, flash action script restart project, script donation project escrow, script donation project escrow charity, action script video project, script needed project, terraform project setup

Om arbejdsgiveren:
( 1 bedømmelse ) Auckland, New Zealand

Projekt ID: #31504507

Tildelt til:

ahmedkamran9

Hi, I'm a UK based certified Azure data engineer and a certified Power BI developer, currently working at a British company as a Data Engineer and using AWS technologies to build serverless data pipelines and ETL proce Flere

$750 NZD in 7 dage
(0 bedømmelser)
0.0

5 freelancere byder i gennemsnit $700 timen for dette job

mihalm

Hello My name is Michael and i represent a team of professional software developers from Ukraine. Our main expertise is building scalable and reliable data processing/etl flows both on premise and on cloud environment Flere

$750 NZD in 7 dage
(1 bedømmelse)
4.2
wmohamederpgate

Hi We can design the solution with postgres and power bi I have more than 12 years of experience and ready to help kindly contact me I need more information

$750 NZD in 7 dage
(4 bedømmelser)
3.0
jensypatel90812

Hey, I have checked your requirement and understand that as well. I have done SIMILAR work past. Do you want to see the DEMO WORK??? Will show you Thanks.

$500 NZD in 7 dage
(0 bedømmelser)
0.0
giitsolutions06

Cloud Computing(AWS, GCP, Azure): Some of AWS services that we have expertise: EC2, ELB, ELK, CloudWatch, Route53, CloudFront, S3, Lambda, WAF, VPN, DX, EBS, LightSail, ECS, Beanstalk, IAM, Config, AutoScaling etc. We Flere

$750 NZD in 7 dage
(0 bedømmelser)
0.0