Find Jobs
Hire Freelancers

Make determination on approach to feed reporting database - SQL Server Broker or Integration Services

$250-750 USD

Zrušeno
Zveřejněno skoro před 5 roky

$250-750 USD

Zaplaceno při doručení
We process approximately 200,000-300,000 questions and answers a day from across the US in a learning database through an IIS based web interface on cloud servers. We'd like to move these records and their associated data to another cloud server and reporting database so we can take more time processing the data and create more reports and charts that would otherwise impact our production server and web interface. We intend to flatten (transform) the data so we can get a better feel for what the data indicates at any point in time. The questions are answered 24x7 but there are "light" times around midnight and on the weekends but still quite active. We've looked at SQL Service Broker and triggers to move and transform the data as it changes as well as SQL Integration Services and SQL Data Tools to do the same. The output of this project should consider our system environment and describe the pros and cons of each approach. It should conclude with a high-level design of the recommended approach and a description of how it would work without needing to take into account the specifics of the database and its structure. Experience with Service Broker is the most important since it harder experience to find. Our longer term objective is to have the right person build the accepted design.
IČ projektu: 19245258

O projektu

13 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
13 freelanceři nabízejí v průměru $579 USD za tuto práci
Avatar uživatele
Hello, Dear How are you? I have read your project description and am ready for discussing with you about project. I have experienced in developing .NET, Database Administration, Microsoft SQL Server, SQL. I will work very hard and best for you. Best Regards
$500 USD v 10 dnech
4,9 (12 recenze)
6,3
6,3
Avatar uživatele
I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) Let me know if you want to discuss further. My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$555 USD v 10 dnech
5,0 (33 recenze)
5,1
5,1
Avatar uživatele
Nice to meet you. I've read the project description and can develop definitely. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, front & back-end web development services and complete the site in time. Please contact with me. Thank you very much.
$277 USD v 10 dnech
4,8 (19 recenze)
4,7
4,7
Avatar uživatele
Hi iam expertise onsql server and integration services please let me know indetail so that icould help u
$555 USD v 10 dnech
4,9 (21 recenze)
4,5
4,5
Avatar uživatele
Hi, I am very interested to work on your project. I have 17+ years experience in Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobile development, web design, development tools. There are more then 1000 projects(small/medium/high complexity) successfully implemented and few of them related with yours can be seen on my freelancer.com portfolio. * * Note that my bid is relative and will be adjusted after detailed estimation of implementation effort/coast ** Let's start our collaboration by sending me all details in a written document which will be used as reference during project implementation Thank you! AdiC
$750 USD v 30 dnech
5,0 (4 recenze)
3,8
3,8
Avatar uživatele
Hi there, We've read the details of your project and its really interesting for us. We don't have experience with Service Broker but have the guys to do the R&D on it and start working. Looking forward to work with you. Thank you!
$722 USD v 10 dnech
3,8 (2 recenze)
4,5
4,5
Avatar uživatele
hello,how are you. i read your bid carefully. i am C#, .Net, SQL Server expert and have full experience for 7 years. C#, .Net, SQL Server is my top skill and i can handle your project fully. I can provide most quality and high fast. if you want to success, please contact me. Then, I will give you good result. hire me.
$500 USD v 10 dnech
3,9 (3 recenze)
3,1
3,1
Avatar uživatele
Hi. i am a full web developer with over 5 years on freelancer.com. ****In SPECIAL very familiar with .NET, ASP.NET, C#, MSSQL, MVC***** I have read your description and have interests in your project. I have rich experiences in projects similar to yours. I am ready for your project now. I would like to have a discussion on chat to get more about your project. Thanks. Best Regard
$300 USD v 10 dnech
4,6 (1 recenze)
2,3
2,3
Avatar uživatele
Hi there, depending on frequency of data replication, I can give you detailed overview. For now it will be good to design DWH and SSIS packages to fill it. SSIS is right tool, because jou can transform data in proces of replicating, T in ETL. I can design both, with 20 years of working experience in BI reporting, and DWH/ETL projects. So if you need my expertise, we can talk. All the best, Dubravko
$500 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I have experience to migrate data from server to server or premises using different ETL tools or programming language such as C#.
$500 USD v 8 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED STATES
Ann Arbor, United States
0,0
0
Ověřená platební metoda
Členem od kvě 14, 2006

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.