Personal details
Tiago G.
About
A dedicated individual with 8+ years experience in SQL Development with a very strong Microsoft SQL Server, T-SQL, reporting, data insights and analysis, data migration, SQL performance tuning and some database administration based experience. Experience in SQL Development for the banking industry, financial industry and real estate. Experience in international projects and working in multicultural environments.
Work Experience
• Implementing various logics (ACID principle) through stored procedures, views, triggers, jobs and user defined functions using Microsoft SQL Server.
• Manage end-to-end complex data migration between more than 10 sources, conversion, data modeling and perform source system data analysis in order to
manage source to target data mapping.
• Documenting technical requirement specifications and detailing designs for database design changes through more than 20 Confluence pages.
• Diagnosing SQL Performance Tuning to reduce query times by more than 75%.
• Standardized ETL processes and tools to automate data extraction and manual reporting.
• Collect and analyze data from different sources to use in final reports.
• Performed data cleaning necessary for data migration by assessing information from 5+ sources in the financial sector.
• Developed and debugged complex T-SQL (Microsoft SQL Server) objects and scripts used to maintaining data integrity in all databases (with more than 150
millions records) contained in servers (stored procedures, triggers, functions, indexes, views, jobs) using the ACID principle.
• Tuned Dev/UAT/Production servers for more than 50% performance improvement.
• Build & troubleshooted SQL Server Reporting Services.
• Automated packages for deployment in UAT and PROD environments.
• Implemented of "Evolutionary Database Design" on existing databases using migrations (flywaydb) and CI/CD pipeline creation/management.