You will get On-Premises SQL Server to Cloud Data Lakehouse Migration
Rising Talent
Project details
Turn Slow, Complex Databases into Scalable, High-Performance Analytics Engines
As an enterprise Data Engineer and Database Architect with over 25 years of hands-on experience, I design, migrate, and optimize end-to-end data systems that power critical business decisions.
As an enterprise Data Engineer and Database Architect with over 25 years of hands-on experience, I design, migrate, and optimize end-to-end data systems that power critical business decisions.
Database Type
MySQL, MS SQL, MS Access, SQLite, PostgreSQL, MongoDB, Azure Cosmos DBWhat's included $600
These options are included with the project scope.
$600
- Delivery Time 3 days
- Number of Revisions 0
- Number of Tables Added 50
24 reviews
(17)
(4)
(2)
(0)
(1)
This project doesn't have any reviews.
LS
Luke S.
May 6, 2024
MS Access - Outlook 2016 VBA Code to Create an Appointment
WL
William L.
Jul 2, 2022
Advanced Word macros to reformat structured text in Word tables
DF
Dr. Randall F.
Oct 5, 2020
MySQL/MS Access Database Expert needed
IN
Igor N.
May 11, 2020
MS Access help
Great job! I will hire again in the future.
TM
Thabo M.
Nov 20, 2019
Microsoft Outlook Reporting
About Denis
Data Engineer |Data Scientist & AI/ML | DBA | PowerBI | .NET in Europe
86%
Job Success
Kyiv, Ukraine - 6:31 am local time
1. 𝐅𝐢𝐧𝐚𝐧𝐜𝐢𝐚𝐥 𝐃𝐚𝐭𝐚 𝐏𝐫𝐨𝐜𝐞𝐬𝐬𝐢𝐧𝐠: Designed and implemented an ETL pipeline using AWS Glue and PySpark to handle high volumes of transactional data, transforming it into a structured format for real-time analysis in Amazon Redshift.
2. 𝐄-𝐜𝐨𝐦𝐦𝐞𝐫𝐜𝐞 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬: Built a data pipeline to extract, transform, and load (ETL) customer behavior data into MySQL, incorporating Python scripts for in-depth analytics and reporting.
3. 𝐇𝐞𝐚𝐥𝐭𝐡𝐜𝐚𝐫𝐞 𝐃𝐚𝐭𝐚 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧: Led a migration of medical records from legacy databases to Amazon Redshift, creating an optimized ETL pipeline to ensure data consistency and improve query performance.
𝐄𝐗𝐏𝐄𝐑𝐓𝐈𝐒𝐄
✔️ 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - Developing insightful and interactive dashboards/reports to provide real-time analytics and data visualization.
✔️ 𝐏𝐨𝐰𝐞𝐫𝐀𝐩𝐩𝐬 - Developing custom business applications with PowerApps enabling seamless integration with existing systems.
✔️𝐏𝐨𝐰𝐞𝐫 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐞 - Designing and implementing automated workflows to streamline repetitive tasks and improve operational efficiency.
✔️ 𝐒𝐒𝐈𝐒 (𝐄𝐓𝐋) - Building and managing complex ETL processes with SSIS to ensure accurate data integration and transformation from multiple sources.
✔️ 𝐒𝐒𝐑𝐒 - Generate comprehensive and dynamic reports to provide detailed insights and performance monitoring.
✔️ Extensive experience with 𝐌𝐒 𝐒𝐐𝐋 𝐒𝐞𝐫𝐯𝐞𝐫, 𝐓-𝐒𝐐𝐋 𝐩𝐫𝐨𝐠𝐫𝐚𝐦𝐦𝐢𝐧𝐠, and 𝐒𝐐𝐋 𝐒𝐞𝐫𝐯𝐞𝐫 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐓𝐮𝐧𝐢𝐧𝐠.
✔️ Designing and implementing Data Pipelines (ETL)
✔️ Database Performance Tuning/Database Optimization
✔️ Data Warehousing and Dimensional Data Modelling
✔️ Performing DBA Activities (Scheduled Jobs, Housekeeping, Backups, Security)
𝐂𝐎𝐑𝐄 𝐒𝐊𝐈𝐋𝐋𝐒
✅ Databases – MS SQL, MySQL, Oracle, MongoDB, Redshift, PostgreSQL, AWS Aurora, Sybase, Absolute DB
✅ ETL Tools – SSIS, Azure Data Factory, Azure Data Bricks, AWS Data Pipeline, AWS DMS, AWS Glue, Talend, Apache Airflow, Windows Services
✅ Visualization Tools – DOMO, Power BI, SSRS, Tableau, Crystal Reports
✅ Project Management Tools – Git, Azure DevOps, Click Up, Trello, Jira, Bitbucket
𝐀𝐃𝐃𝐈𝐓𝐈𝐎𝐍𝐀𝐋 𝐒𝐊𝐈𝐋𝐋𝐒
✅ AI Tools – Loveable AI, Cursor AI, Windsor AI, Domo AI
✅ AWS – Lambda, API Gateway, VPC/EC2, RDS, S3, Athena, Simple Queue Service, Simple Notification Service, Simple Email Service
✅ Azure – Functions, Blob Storage, Logic Apps, Service Bus, Notification Hubs, Virtual Machine, Synapse Analytics
✅ Back-end – Java, Python, .NET Framework, .NET Core/MVC, ASP Zero/Boilerplate, REST/SOAP API, ADO.NET, LINQ, Entity Framework, Dapper, ASP, Shell Scripting
✅ APIs – OpenAI, Twilio (SMS), Google Maps, DOMO API, Map Box API, Open Weather
✅ Front-end – HTML, CSS/Bootstrap, jQuery/JavaScript, Vue.js, Kendo/Telerik, Webix, Razor Pages
- Fluent English (excellent speech, writing, and reading)
- Support and guidance on each step of the development process.
- Support & maintenance post development.
Let's get in touch to develop your next global enterprise solution!
Steps for completing your project
After purchasing the project, send requirements so Denis can start the project.
Delivery time starts when Denis receives requirements from you.
Denis works on your project following the steps below.
Revisions may occur after the delivery date.
Kickoff & Discovery Session
What happens: We review business goals, architecture requirements, and security policies. Deliverable: Confirmation of system access, finalized project scope, and key success metrics
Architecture & Technical Strategy Design
What happens: I analyze your current database schemas, query execution plans, or pipeline bottlenecks to map out the target solution. Deliverable: Technical architecture diagram, data flow mapping, and proposed database/ETL optimization plan.