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.

Habilidades: Microsoft SQL Server , SSIS (SQL Server Integration Services), Solutions Architecture, Microsoft Azure, Python

Sobre o Cliente:
( 0 comentários ) Singapore, Singapore

ID do Projeto: #35346754

8 freelancers estão ofertando em média $169 nesse trabalho


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 Mais

$250 SGD in 2 dias
(11 Comentários)

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 Mais

$150 SGD in 5 dias
(1 Comentário)

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 Mais

$112 SGD in 7 dias
(1 Comentário)

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 Mais

$140 SGD in 7 dias
(0 Comentários)

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 Mais

$100 SGD in 7 dias
(0 Comentários)

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 Mais

$200 SGD in 7 dias
(0 Comentários)