Thiago De Almeida Arcari Email & Phone Number

São Paulo, Brasil

- Led DBRE Team Initiatives: Directed the DBRE (Database Reliability Engineering) team, conducting personalized 1:1 technical sessions to drive continuous improvement and elevate the team's technical proficiency.- Knowledge-Sharing Platform: Created and facilitated the Data Train agenda, organizing weekly sessions to promote knowledge exchange on emerging database technologies and best practices.- SQL Performance Optimization: Enhanced SQL query performance using advanced tuning techniques, implementing best practices to achieve measurable gains in system efficiency and speed.- Automated Maintenance Routines: Developed automated routines for UPDATE STATISTICS and reindexing (rebuild/reorganize) using Elastic Jobs, ensuring consistent database health with minimal manual intervention.- Proactive Resource Monitoring: Established comprehensive monitoring metrics in Grafana, enabling proactive resource analysis and system tuning for optimal database performance.- Critical Incident Resolution: Managed and resolved high-impact incidents across SQL (Azure SQL, PostgreSQL) and NoSQL (Redis, Cassandra, ElasticSearch/OpenSearch, MongoDB) environments, minimizing downtime and maintaining system stability.- Python-Driven Automations: Developed Python scripts to streamline operations, including TTL management in Redis and importing AuditLogs for root cause analysis in Azure SQL Database, enhancing operational efficiency.- Database Migration Expertise: Successfully migrated SQL Server databases to Azure SQL and transferred data between SQL and Cassandra, ensuring data integrity and seamless transitions across platforms.- In-Depth Azure SQL Knowledge: Leveraged advanced understanding of Azure SQL Database tiers and limitations, utilizing Database Watcher (preview) to monitor and optimize database performance.

São Paulo, Brasil

- Global Client Collaboration: Partnered with international clients via Meeta Solutions, delivering tailored database services to meet specific business needs and expectations.- SQL Query Tuning for Performance: Optimized SQL queries to significantly enhance system responsiveness and efficiency, ensuring better performance for critical applications.- Stored Procedures Development: Designed and implemented complex stored procedures to handle application logic directly in the database, enhancing processing efficiency and reducing application load.- Real-Time Monitoring Solutions: Developed SQL procedures to power near real-time data monitoring dashboards, providing clients with timely insights and supporting data-driven decisions.- Database Architecture Design: Architected scalable database structures to support robust application development, ensuring adaptability and performance at scale.- Log Shipping Consulting: Provided expert guidance in setting up and maintaining Log Shipping, ensuring reliable disaster recovery and data redundancy.- SQL Server Version Migrations: Managed smooth migrations across SQL Server versions (from 2008 to 2012, and 2012 to 2014), preserving data integrity and minimizing disruption.- User Access Policy Restructuring: Reorganized database user access policies, reducing privileged access to enhance security and enforce compliance standards.- Integration with Call Center Systems: Leveraged expertise in Avaya and ECH to extract and integrate data into real-time dashboards, delivering actionable insights for call center operations.- ETL Process Development: Built Integration Services packages for ETL processes, transforming and loading data to central databases for unified reporting and analysis.- Ongoing Client Engagement: Conducted weekly client meetings to gather requirements, provide progress updates, and ensure alignment with project goals.

São Paulo, Brazil

- SQL Server DBA Consultant for Financial and Inventory Operations: Served as the DBA consultant at Saraiva, overseeing critical database functions to ensure smooth financial and inventory closure processes, maintaining high operational accuracy.- Legacy System Management in SQL Server 2000: Developed and implemented custom monitoring scripts to manage SQL Server 2000, effectively compensating for the absence of Dynamic Management Views (DMVs) and ensuring consistent system health monitoring.- Replication Management Across Complex Environments: - Pull Replications: Designed and managed Pull replications on SQL Server 2000 to enable efficient data synchronization across systems. - Push and Merge Replications: Supervised extensive Push and Merge replications across hundreds of interconnected databases, ensuring data integrity and consistency across the network.- Backup and Routine Administration: Conducted comprehensive database backup procedures and performed essential administrative tasks to maintain data security and system stability.- On-Call Database Support: Provided reliable on-call support during scheduled weeks, ensuring timely resolution of database-related issues and minimizing downtime.- Database Performance Optimization: Enhanced database efficiency by refining administrative routines, achieving measurable performance gains in daily operations.

- First DBA Role: Launched my DBA career by managing SQL Server environments and working with data integration and reporting tools, laying a strong foundation in database administration.- Pentaho Integration and Reporting: Leveraged Pentaho (Kettle Spoon) to create reports and seamlessly integrate data with SQL Server, enhancing data accessibility and reporting capabilities.- Automated Billing with MySQL Triggers: Developed MySQL triggers for call center billing, automating operator identification and applying correct minute rates for calls, which streamlined billing accuracy and efficiency.- SQL Server 2000 Administration: Ensured database stability and optimized performance by managing reindexing jobs and updating statistics on SQL Server 2000.- Mailing List Management for Campaigns: Imported and organized mailing lists to support active call center campaigns, enabling targeted and efficient campaign execution.- Campaign Performance Reporting: Created data-driven performance reports based on statistical analysis, delivering actionable insights into call center conversions to improve campaign outcomes.- Automated Audio Backup with Bash: Developed bash scripts to automate backups of call recordings (CDR) from the Asterisk VoIP system, ensuring secure, reliable access to requested client recordings.

Master Of Business Administration - Mba, Big Data (Data Science)

Bachelor'S Degree, Computer Science

Scientific article "Autonomous Navigation of an Intelligent Agent: A Comparative Study Using Fuzzy Logic and A Search Algorithm"*.