Vitor Tadeu Fiel Fava

Senior SQL Server Developer

Mastery

Sep 2024 - Apr 2025 (8 months)

• Conducted in-depth analysis of complex T-SQL code across critical business workloads, identifying performance bottlenecks and applying advanced tuning strategies that significantly improved execution times and reduced resource consumption. • Rewrote legacy T-SQL procedures and functions with a performance-first approach, applying best practices in indexing, query refactoring, and set-based logic to enhance scalability and maintainability. • Performed advanced execution plan analysis using SQL Server Management Studio (SSMS), Query Store, and other diagnostic tools to trace inefficiencies, leading to substantial gains in system responsiveness and throughput. Cloud & Cross-Platform Integration

t

SQL Server Database Specialist

torc

Oct 2023 - Aug 2024 (11 months)

• Designed and deployed an Azure SQL Database solution for a SaaS provider, utilizing Elastic Pools to optimize resource usage across multiple clients, resulting in a 30% reduction in costs. • Migrated on-premises SQL Server databases to Azure SQL Database, ensuring seamless integration with existing cloud services and improving overall system resilience. • Implemented and managed Elastic Pools for a financial services company, dynamically scaling resources based on workload demands and ensuring consistent performance during peak times. • Developed automated scripts to monitor and manage Azure SQL Databases and Elastic Pools, improving efficiency in resource allocation and reducing manual intervention by 50%. • Led the configuration an

H

SQL Server Database Specialist

Horus Solution

Feb 2023 - Oct 2023 (9 months)

• Created a data warehouse solution for a retail client, enabling more efficient reporting and data-driven decision-making. • Developed complex ETL processes to integrate data from multiple sources, enhancing the client's business intelligence capabilities. • Managed a project to optimize and refactor a client's billing system database, reducing processing time by 40%. • Provided training to junior DBAs on advanced indexing strategies, contributing to a 25% improvement in overall database performance.

MVP SQL Server Database and AI

Pythian

Sep 2015 - Feb 2023 (7 years 6 months)

• Managed the migration of on-premises SQL Server instances to Azure SQL Database for a multinational corporation, optimizing cost-efficiency and scalability. • Deployed Azure SQL Managed Instances for a global retail client, providing a hybrid cloud solution that enhanced security and performance. • Configured Azure SQL Active Geo-Replication to ensure business continuity and disaster recovery for critical applications. On-Premise Projects: • Led the implementation of Always On Availability Groups for a global financial institution, ensuring high availability and disaster recovery across multiple data centers. • Performed in-depth audits of SQL Server environments for various clients, identifying and addressing security vulnerabilitie

MS SQL Server Specialist

Indra

Jan 2013 - Sep 2015 (2 years 9 months)

• Planned and executed the migration of legacy SQL Server databases to Azure SQL Database, improving performance and reducing operational costs. • Developed a scalable cloud-based solution using Azure SQL Database to handle peak loads during promotional events, ensuring zero downtime. • Configured Azure SQL Database auditing and threat detection, enhancing the security posture of critical applications. • Deployed Azure SQL Database Hyperscale for large-scale data storage, providing high availability and performance for the company's analytics platform. On-Premise Projects

Senior MS SQL Server Database Developer

Netshoes

Dec 2011 - Jan 2013 (1 year 2 months)

• Designed and implemented a hybrid solution using Azure SQL Database to handle cross-region data replication, ensuring data availability and consistency. • Migrated key financial databases to Azure SQL Database, leveraging its scalability and security features to handle increased transaction volumes. • Integrated Azure SQL Database with on-premises systems using Azure Hybrid Connections, ensuring seamless data flow and business continuity. • Conducted a cost-benefit analysis for migrating to Azure SQL Database, resulting in significant cost savings and improved performance. On-Premise Projects

Senior MS SQL Server Database Developer

Politec

Dec 2009 - Dec 2011 (2 years 1 month)

• Managed the development of a central data repository for a government agency, enabling real-time reporting and data sharing across departments. • Designed a scalable database solution for a nationwide health monitoring system, handling millions of records efficiently.

I

Senior MS SQL Server Database Developer

ICE Special Cards

Apr 2009 - Jun 2009 (3 months)

• Led a global team of DBAs, coordinating with more than two DBAs to support major customers in maintaining robust on-premises SQL Server environments. • Executed strategic functions and administration, providing recommendations on technical directions, product reviews, studies, analyses, and formal presentations, while also developing comprehensive support documentation. • Designed, developed, and maintained complex SQL Server databases and applications, ensuring they met the high standards required by global clients. • Planned and created new database schemas, tables, stored procedures, triggers, and views to support business-critical applications. • Optimized SQL Server performance by identifying and resolving bottlenecks, fine-tuni

I

SQL Server Database Administrator/Account Leader

IBM MS

Nov 2007 - Apr 2009 (1 year 6 months)

• Acted as the Account Leader, serving as the primary contact for clients and overseeing the preparation and implementation of on-premises SQL Server projects. • Developed and deployed a comprehensive monitoring tool for SQL Server databases, resulting in a significant efficiency gain of 1095 hours per year for the DBA team. • Performed strategic functions and administration, offering expert recommendations on technical directions, product evaluations, studies, and formal presentations, along with detailed support documentation. • Designed, developed, and maintained complex SQL Server databases and applications, ensuring they aligned with client requirements and industry best practices. • Planned and implemented new database schemas, t

D

MS SQL Server Database Developer

DCOM Projects

Jun 2007 - Nov 2007 (6 months)

• Collaborated with a team of SQL Server developers to support large enterprise customers, focusing on maintaining and optimizing their on-premises database environments. • Produced ad-hoc reports to support executive decision-making, providing critical insights based on accurate and timely data. • Developed data import packages to handle large volumes of data, ensuring seamless integration with existing database systems. • Administered SQL Server database servers, managing performance, backup and recovery processes, and disaster recovery planning to ensure data integrity and availability. • Developed ETL routines to facilitate the extraction, transformation, and loading of data, supporting the organization's business intelligence init

Vitor Tadeu Fiel Fava

About

Detail

Timeline

Résumé