Closed

Email Database Management

Right now I'm having over 80 million records (email, firstname, lastname, optin info, optin date, optin URL, city, state, zipcode, phone ,etc). All of them are in csv and txt format. I would like to build a data management system (frontend run via web, PHP and Laravel, backend via either MariaDB or mongoDB, something that's scalable in case I need to add more servers later) that can help me manage my data better. Some functions I have in mind are

1) I can create/edit/delete/export/merge a "List"

2) I would like to be able to import the files to that "List" via the web, and the system will dedup => import only the records that don't exist in the system (primary key will be emailed) => show me the details

3) During the import, it will automatically mark the email as "Hardbounce" / "Never Mail" if it found the email existed in those 2 tables from the database. If not, the status will be "Active"

4) I would like to be able to segment a "List" or "Lists" from certain conditions, such as

"Email", "State","City","Zipcode","Status"

"Like","Equal","Not Equal","Not Exist In List"

After the segmentation, I would like to be able to either save it as a new List or Export it.

As far as the infrastructure goes, it must:

1) Scalable, I want to be able to expand the number of servers to store the DB

2) Compartmented, I want the frontend and backend separately, the front end can run on a VPS if it must.

3) Front end must be written in PHP, the framework can be Laravel-framework.

4) Documented, I want to be able to re-setup the whole thing myself in case something happens that cause the whole system to crash.

This is an on-going project as there will be more features being added/upgrade/ or remove completely. Make sure you add enough comments in there to help with the process.

ทักษะ: HTML, Laravel, MySQL, PHP, สถาปัตยกรรมซอฟต์แวร์

ดูเพิ่มเติม : mail chimp login, email marketing, mailchimp, google email list management, email list management best practices, email list management for nonprofits, email list management gmail, free email list management, database management design job, database management vba, html email content management system, sas database management, music database management, airline reservation system database management system, contact database management, database management project using excel, email list management, need complete project database management system hospital, database management requirements analysis, database management israel

เกี่ยวกับนายจ้าง:
( 40 บทวิจารณ์ ) Dhaka, Bangladesh

หมายเลขโปรเจค: #17549432

freelancer 19 คน กำลังเสนอราคาเฉลี่ยที่ $218 สำหรับงานนี้

ChiragLathiya

Please message me before awarding me this project Please message me before awarding me this project Please message me before awarding me this project Please message me before awarding me this project Please message เพิ่มเติม

$200 USD ใน 10 วัน
(267 บทวิจารณ์)
6.1
topithub

A well organized and professional work will be provided regarding the task requirements. I am ready for this job. There are some questions in my mind I want to discuss .

$166 USD ใน 10 วัน
(27 บทวิจารณ์)
5.9
MohanKumar28

Hi, I have gone through the requirements. Will do this database management using Laravel. I'm available to start now. Please share additional details. Regards, Mohan

$160 USD ใน 4 วัน
(57 บทวิจารณ์)
5.5
greenforest0204

Hello, Dear! I'm Dmitrii from Russian. I read your description and I'm an expert of Laravel so that I have many great experience about it. Now I'm ready to work for you and I can finish your job within your timefram เพิ่มเติม

$155 USD ใน 10 วัน
(22 บทวิจารณ์)
5.1
justdotweaks

I can do [login to view URL] you need and how much u pay?I can do [login to view URL] you need and how much u pay?I can do [login to view URL] you need and how much u pay?

$166 USD ใน 10 วัน
(28 บทวิจารณ์)
5.3
desislavivanov0

Hello! I am interested in your project. I will work hard to deliver reliable and consistent data structure along with indexes for optimization. I can do it with php and Mariadb or node and mongo. Contact me for more in เพิ่มเติม

$150 USD ใน 3 วัน
(7 บทวิจารณ์)
4.7
Barrybk

Senior database administrator in here with 8 years of experience in advance database management systems. Took a brief review of your requirements and I believe can achieve this task with 100% accuracy and early as poss เพิ่มเติม

$200 USD ใน 6 วัน
(9 บทวิจารณ์)
3.7
ritu3361

Hello!!!! Thank you for the opportunity. I checked your project of system as you explained. As per your requirement, I would like to tell you that I have a very strong experience of more than 3 years in the field o เพิ่มเติม

$150 USD ใน 10 วัน
(6 บทวิจารณ์)
3.4
Sterlinweb

Hello, After reading your requirements, we are looking forward to proceeding with this project. We have a TEAM of PASSIONATE WEB DESIGNERS/DEVELOPERS who provide 100% results. We have a STRONG EXPERIENCE of PHP Bas เพิ่มเติม

$166 USD ใน 10 วัน
(17 บทวิจารณ์)
3.1
abhisheksharma24

Dear client   i have more than 5+ years of experience as  FULL STACK DEVELOPER in It industry. i have good hands on experience on python ,Networking skills ,Linux Administration,aws ,photoshop and also have good hands เพิ่มเติม

$222 USD ใน 5 วัน
(1 บทวิจารณ์)
2.4
AMDigitalS

Hi, I am a developer and will build email database management. I will build it on both UI and server side. Thank you

$122 USD ใน 10 วัน
(8 บทวิจารณ์)
2.5
tophatsoft

We Best Growing IT Service Provider and we cover Our local area all clients and our developer ready to work 24*7 hrs and reputation is our work so hire us for best experience

$111 USD ใน 10 วัน
(3 บทวิจารณ์)
2.6
ArtemGB

Hey! My name is Artem, Im from Russia (Moscow). Nice to meet you sir. Studied your offer. Portfolio - https://www.freelancer.com/u/ArtemGB (This is not all the work, if you are interested in some specific เพิ่มเติม

$100 USD ใน 10 วัน
(1 บทวิจารณ์)
2.0
Joe925

Hi. Thanks for considering my bidding! I'm a web developer with several years' experience. Now I'm starting full-time freelancing recently. But if your project is concerned about expert skill rather than repetitous เพิ่มเติม

$333 USD ใน 10 วัน
(2 บทวิจารณ์)
2.2
jaydipfreelance8

Dear Employer ( can you share more details over private chat ) I've to learn more about the projects. waiting for your response

$1000 USD ใน 10 วัน
(2 บทวิจารณ์)
0.2
ak10790

Hello Sir , I have completed M.C.A from Pune University. I have a working Experience of 5+  years in software and web development. I believe that my qualification and skills are best match for your requirements. Fol เพิ่มเติม

$250 USD ใน 30 วัน
(0 บทวิจารณ์)
0.0
mohit10eng

Hi I’m interested

$51 USD ใน 3 วัน
(0 บทวิจารณ์)
0.0
deasho

hello , I've gone through your requirements and understood completely all the functionalities. and i want to let you know that we have 7+ years of experience in website design & development. we have exper เพิ่มเติม

$222 USD ใน 8 วัน
(0 บทวิจารณ์)
0.0
$222 USD ใน 10 วัน
(0 บทวิจารณ์)
0.0