Senior Data Engineer Sevilla, Spain

Kan vara tillgänglig

(Uppdaterat 2023-06-29)

Senior Data Engineer

Sevilla, Spain

Modersmål Italian, English, Spanish

  • SQL, Data Engineering, Data DevOps, Azure, AWS, GCP
  • Google Cloud Certified - Associate Cloud Engineer
  • +10 years SQL Server, Oracle, MicroStrategy

Kompetenser (18)

Microsoft SQL Server

SQL Server

BI

Data Analysis

Oracle

DATABASE

SQL

DATABASE MODELING

MS SQL Server

Business Intelligence

TECHNICAL DOCUMENTATION

METRICS

PL/SQL

Snowflake

STATISTICS

BIOMEDICAL

Python 3.0

DATA SCIENCE

Sammanfattning

Senior Azure SQL DBA and Developer, worked for years in Fortune companies designing and maintaining scalable data infrastructures based on Azure Stack (Azure SQL, Synapse) and Amazon Web Services (Redshift, Snowflake). Completed successfully on-premise to cloud migrations including ETL pipelines. DataOps approach to database development. 15+ years of experience with Microsoft SQL technologies. 5+ years DevOps tools and Agile projects. 5+ CI/CD tools experience (GitHub, Azure DevOps, Liquibase). Languages: Italian native, English fluent (negotiation), Spanish fluent (negotiation)

Professionell bakgrund

Senior Data Engineer
Pfizer

2022-01 - 2023-01

Being part of the team providing insights in the supply chain, rebuilt the Python pipeline introducing CI/CD tools and mindset with focus on DataOps. Migrated the application database from on-premises Linux to Kubernetes on AWS, reducing load times by 50%, adding exception handling, monitoring and logging.
Migrated all SQL and job scripts from Redshift to Snowflake, reducing database size, reducing backup times and overall network costs. Mentored colleagues on best practices in big data and infrastructure.
● Redshift, Snowflake, PostgreSQL ● Python ● SQL query debugging and performance improvement ● Monitoring database KPI metrics ● Large Database migration to cloud ● DevOps, Kubernetes, infrastructure as code
Data Lead and Architect
Yara International

2021-01 - 2021-01

Leading a team of 8, audited, reviewed and documented their existing data infrastructure. Proposed and bootstrapped a plan to increase efficiency and reduce costs. Introduced a ticketing system for requests/issues accountability. Streamlined relationships with other departments in the company. Helped stakeholders in defining enterprise wide KPIs. Automated and debugged AWS Glue pipelines, reducing day to day operations, added monitoring and logging. Cleaned up redundant and obsolete pipelines.
Azure Data Engineer
Caterpillar

2019-01 - 2020-01

Built new version of a legacy system used to store, retrieve, and update data about products, bills of materials, and services. Tuned database design and processes needed to move data from the legacy system to the Azure Cloud. Azure SQL change tracking, incremental load. Added DevOps and DataOps as the standard procedure for database deployment. Application performance optimization, rewriting SQL queries and proposing a plan to resolve endemic data problems and save cloud costs.
DBA, Backend Developer
BEAM Interactive

2017-01 - 2019-01

SQL Query performance Wrote the SQL and JSON backend for CustomEyes tuning Configurator, a sales automation tool that won an award in● Database Analysis and 2020: (https://www.mmm-online.com/mmm-awards/gold-professional-sales-tool- modelling 2020/). Using T-SQL stored procedures, and system versioned tables, the backend● JSON allowed disconnected and connected mode data sync. Azure SQL data model ● API design, optimization and monitoring. Introduces DataOps procedures and standards.
SQL Database Expert
Equature (DSS Corporation)

2017-01 - 2018-01

Overhauled the dynamically generated database to improve speed and accessibility to both the ingestion system and content delivery platform.
Streamlined solution to segregate capture data from static data. Optimized hardware, Op. Sys. and database layers to obtain sub-second response. SQL Server DBA tasks and queries optimization.
● Large Database performance troubleshooting ● Redshift, Aurora ● CI/CD DataOps ● Python ● Containers ● Teamwork with other departments ● ETL, data pipelines ● Big Data applications in the Cloud ● Data infrastructure and architecture ● SQL DBA ● Database Modelling / Tuning ● Microsoft Azure SQL ● Microsoft SQL Server ● Windows Server ● Data Ingestion ● Scripting ● C#
Data Engineer, Data Analyst
COTY

2016-01 - 2016-01

Advanced FI KPIs Migration of the accounting/financial reports from SAP BW to● Remote multi-site teamwork MicroStrategy: data modelling, semantic layer and ● Communication with document/dashboards creation. Accounts Payable, Accounts stakeholders and Receivable, Supply Chain advanced KPIs. Coordinating external database designers in requirements gathering different time zones. Translated stakeholder requirements into reliable and actionable insights.
Data Architect, Engineer, Analyst
AGQ LABS

2014-01 - 2015-01

SQL Query performance Requirements gathering, analysis and development of several data tuning analysis projects to support the management in Logistics, Production, ● Database Analysis and Financials departments: data modelling, ETL, training. Maintenance of troubleshooting the existing BI stack on MS SQ Server. ● SSIS DBA tasks and optimization. ● MicroStrategy
Database specialist Business Intelligence Architect
Public Health Services of Andalucía

2009-01 - 2014-01

Oracle, SQL Server, Azure Design and create an MVP for hospital data analysis application and● Automated DB maintenance, infrastructure, based on MicroStrategy and SharePoint with SSO and T-SQL, PowerShell Privacy laws compliance. More Departmental pipelines integrations● DevOps with the Hospital Information System, HL7. Micro services architecture. Oracle, ● API integration PL/SQL, C#. Bitbucket source code repository. ● Streams integration
Database developer, programmer
INyDIA

2010-01 - 2013-01

Project management Robot Automation, integration of multiple diagnostic appliances to● API Hardware integration Xiril Workstation (Thermoshaker, barcode scanner, ). Conceived and● DevOps developed a database to provide a unified sample reporting, based on MS Access and XML/XSLT. Development of a new application to manage and service an array reader: motor driver in C++, integrations in C#.
Author
PACKT Publishing

2012-01 - 2012-01

Microsoft SQL Server From concept to writing, proofreading, and releasing. Creation of● Data Modelling, KPIs additional material: videos, cod, examples. Coordinating with PACKT● Writing, Editing, editor team in Asia, managed to release the book ahead of schedule. Reviews Data warehouse, data modelling, SQL Server, advanced analytics in MicroStrategy.
● LinkedIn profile: https://www.linkedin.com/in/davidemoraschi/ ● Blog: https://moraschi.com/blog, YouTube channel: https://www.youtube.com/@DavideMoraschi

Certifikat

MCPS
Microsoft Certified Professional
Microsoft Certified
MicroStrategy Certified Engineering Principal (MCEP)
(MCEP)
MicroStrategy Certified Engineering Principal

Kontakta konsult

/