11/05/2025 updated
100 % available
Microsoft Fabric BI Consultant Sr SQL Server DBA / Data Engineer
Rio de Janeiro, Brazil
Only remote
Computer Systems TechnologyAbout me
thiagorocha.alves@hotmail.com www.linkedin.com/in/thiagorocha-alves +15 years of experience. Microsoft Fabric, Power BI, Azure DB, SQL Server, Synapse, ADF, ADB, Lakehouse, Data Warehouse. Designing, modeling, architecting. Data Science, Real-Time Analytics, DAX, datasets, dataflows, governance.
HTMLJava (Programming Language)JavaScriptApplication Programming Interfaces (APIs)Amazon Web ServicesAtlassian JiraAuditingBusiness RequirementsSoftware as a ServiceProfilingComputer ProgrammingContinuous IntegrationCryptographyInformation EngineeringExtract Transform Load (ETL)
▪ Designed and implemented Microsoft Fabric solutions end-to-end:
▫ Lakehouse & Data Warehouse for unified storage, Delta tables, OneLake integration.
▫ Data Factory pipelines for ingestion from APIs, on-premises SQL Server, Blob Storage, and SaaS sources.
▫ Data Engineering with Spark/PySpark notebooks, transformations, and performance tuning.
▫ Access management, permissions, and Audiences in the APP.
▫ Semantic Models developments and Visualizations
▫ Workspaces administration
▫ Deployment Pipelines
▪ Power BI Administration and SQL Server Database Administration
▪ DAX, SQL, SSMS, SSAS Cubes, MDX, SSIS and SSRS.
▪ Data modelling, Data Warehouse, Data Engineer.
▪ Designed and implemented data models aligned with best practices and business requirements.
▪ Star Schema and Snowflake schema implementations. Tabular and Multidimensional models
▪ Power BI projects connecting to SSAS, AAS, DBs and Files. (Live, Direct Query and Import)
▪ ETL tools: Power Query, SQL procedures, Data Factory, DataBricks, Python, PySpark, Pentaho
▪ Programming logic in Java, JavaScript, VB, HTML and other frameworks.
▪ Synapse, SQL Server DBA and developer, managing multiple instances.
▪ Query tuning, Profiler and performance checks.
▪ Hight Availability, Disaster recovery, maintenance, deployment, and security.
▪ SQL Language, (Window Functions, CTEs, Joins).
▪ T-SQL Programming (Stored Procedures, Functions, Triggers, Indexes, DML and DDL)
▪ Indexing strategy, Data security. Data Encryption, Auditing, Upgrade process.
▪ BQ, Snowflake, Oracle, SAP Hana, PostgreSQL, MySQL, Cosmos, MongoDB, GraphQL.
▪ Scrum environment, JIRA, TFS, DevOps, CICD, GitHub, GitLab, Azure Repos.
▪ Azure SQL DB, ADF and ADB, AWS.
▪ Managing, integration, and governing data.
- Constant work with stakeholders, users, dev and infra teams and other members.
Experience
Professional experience10+ years
Freelancer since2010
Languages
GermanBasic knowledgeEnglishNative speakerPortugueseNative speakerSpanishGood
Project history
Connecting to different data sources, building information presentation panels and dashboards using
many graphical components and ETL (Extract, Transform and Load) data.
SSAS Cubes, DAX Metrics and T-SQL ETL.
Power BI visuals.
Data Factory
DataBricks
SQL SERVER
many graphical components and ETL (Extract, Transform and Load) data.
SSAS Cubes, DAX Metrics and T-SQL ETL.
Power BI visuals.
Data Factory
DataBricks
SQL SERVER
SQL SERVER DBA, T-SQL Programming, Stored Procedures, DML, DDL, Microsoft SQL Server, query performance, backup, Database, data compression, ETL, Data Warehouse, OLAP, SSIS, SSAS, SSRS, Power BI devellopment.
Database migration.
Database migration.
SoftWale - Rio de Janeiro, Brazil
* Technical support, customer visits, installation and maintenance of custom systems, configuration
and administration of databases.
* Responsible for performing database migration from various sources to SQL Server.
Company focused on ERP System development
EDUCATION AND TRAINING
01/07/2019-22/08/2019 Analyzing and Visualizing Data with Power BI
Microsoft - Edx
* Connect, import, shape, and transform data for business intelligence (BI)
* Visualize data, author reports, and schedule automated refresh of your reports
* Create and share dashboards based on reports in Power BI desktop and Excel
* Use natural language queries
* Create real-time dashboards
* Technical support, customer visits, installation and maintenance of custom systems, configuration
and administration of databases.
* Responsible for performing database migration from various sources to SQL Server.
Company focused on ERP System development
EDUCATION AND TRAINING
01/07/2019-22/08/2019 Analyzing and Visualizing Data with Power BI
Microsoft - Edx
* Connect, import, shape, and transform data for business intelligence (BI)
* Visualize data, author reports, and schedule automated refresh of your reports
* Create and share dashboards based on reports in Power BI desktop and Excel
* Use natural language queries
* Create real-time dashboards