Закрыт

Architecture Consultation - SQL Server, SSIS, Azure Databricks, Data Lake, Data Factory, AutoSys, DevOps

Job Description:

[Certification on Azure Solution Architecture will be Preferred]

As the Subject suggests, I am searching for an Architecture Consultant for a 2hrs Consultation Session.

~ Someone who is having proven and vast experience in SQL Server (Both On-Premises and Azure Cloud SQL) and other Azure Services such as Data Lake, Data Bricks, Data Factory, DevOps, etc.

Additionally, Knowledge of Autosys will be a plus!

Only searching Individuals and NOT any company/consultancy farm. So please don't keep sending requests from such farms.

Scenario is:

1. We are currently operating in an environment where we have On-prem SQL Server. People are running a lot of analytics in SQL on that. Those are event-driven executions and are triggered/controlled by Autosys.

2. Recently, for another few applications - they started storing data in Data lake /Data Bricks. There too, we have a need to run some analytical queries and for that, on an Adhoc basis, some users/developers run a few Python-based queries using Data Factory.

3. We want to integrate these together and bring all such analytical queries in one place, run from there, and store results.

4. Several options we put on the table... Such as (a) using OnPrem SSIS and running SQLs using Execute SQL Task And running Python-based queries via executing process tasks etc. (b) completely moving to Azure Data Factory and then use it for running both SQL and Python.

5. Also there are questions about where to store results... should it be in SQL Database (be On-prem Or Azure) Or should it be in Data Lake/Data Bricks?

6. If we move to Azure based environment - What/how the cost would be approximate?

~~ So we'd like to consult with you about all these above. If you feel you are confident to share your opinion here and add necessary value and answer all Architecture questions above - then only please apply.

Навыки: SQL-сервер Microsoft, SSIS (SQL Server Integration Services), Solutions Architecture, Microsoft Azure, Python

О клиенте:
( 0 отзыв(-а, -ов) ) Singapore, Singapore

ID проекта: #35346754

8 фрилансеров(-а) готовы выполнить эту работу в среднем за $169

Bhatti1987

I have total 12 plus years of experience especially in Development, DWH, ETL, SSIS, SSAS, SSRS, SQA, Database development & maintenance. • Very strong in Open Interfaces, SQL, PL/SQL, Stored procedures/packages, writin Больше

$250 SGD за 2 дней(-я)
(11 отзывов(-а))
2.8
vladyslavpiddub9

Hi There, I am professional python coder with skills including Solutions Architecture, Microsoft SQL Server, Python, Microsoft Azure and SSIS (SQL Server Integration Services). Please contact me to discuss more regardi Больше

$150 SGD за 5 дней(-я)
(1 отзыв)
1.0
unixsam

I have an experienced team, I trust that my team can deliver all of your requirements on te with the desired quality. Hire use and you will not regret it. Personaly i am certified Azure solution architect (az-305) and Больше

$112 SGD за 7 дней(-я)
(1 отзыв)
0.6
jayendran1977

I have more than 16 years of experience in Microsoft Platform(SSIS, SSRS, Power-Bi, Visual Basic 6.0, Excel VBA[Macro] and SQL Server, MySQL). I am strong in Microsoft SQL server database's T-SQL, Stored Procedure and Больше

$140 SGD за 7 дней(-я)
(0 отзывов(-а))
0.0
vedeekasofttech

I have more than 15 years of experience in application performance also i have good team for Android and flutter mobile app, web API, Microsoft platform applications development, deployment, performance tuning in .Ne Больше

$100 SGD за 7 дней(-я)
(0 отзывов(-а))
0.0
tirthodebnath

I can build a smooth ETL pipeline that can help extract data from any source system(eg: Hive Database, Relational database server) hosted in any cloud platforms(eg: GCP, AWS, AZURE) & on premice servers also. The pipel Больше

$200 SGD за 7 дней(-я)
(0 отзывов(-а))
0.0