Gerardo N. Barros Filho Email & Phone Number

State Of São Paulo, Brazil

• Oversaw and maintained SQL Server databases, including virtual machine (VM) servers, implementing best practices for database planning, design, and capacity management, to reduce risks and improve operational stability.• Developed and automated backup routines, index maintenance, and integrity checks, enhancing data security and minimizing manual intervention.• Reduced disk space usage by over 3.5 terabytes through effective analysis and resizing of data files and transaction logs across 200+ databases.• Implemented advanced security configurations and improved log monitoring across all database servers, significantly strengthening the overall security posture.• Managed filegroups and compression, improving storage efficiency.• Successfully led the migration of on-premises databases to SQL Server 2022 with minimal downtime, ensuring data integrity throughout the process.• Collaborated with teams in Agile (Scrum) environments, contributing to project success through sprint planning and regular stand-ups to ensure alignment with business objectives.

Dublin, Condado De Dublin, Irlanda

• Developed and implemented administrative routines using T-SQL and PowerShell in an AWS EC2-hosted SQL Server Always On high-availability environment, reducing manual administrative tasks by 80% and increasing automation by 10%, which improved productivity and allowed for a focus on strategic initiatives.• Achieved a 31.6% average reduction in the size of production databases by implementing data compression, resulting in significant disk space savings and avoiding additional storage costs on AWS.• Secured 100% of database backups by implementing encryption certificates, ensuring compliance with industry standards and protecting sensitive data from unauthorized access in the cloud environment.• Conducted indexing and query optimizations, performing on-demand performance tuning that improved database performance by over 80%.• Mentored a peer in T-SQL best practices, fostering their growth and enhancing the team's overall skill set.• Collaborated with the development team, providing technical support and recommending improvements to optimize database performance.• Contributed to Agile (Kanban) workflows, utilizing Kanban boards to manage tasks, and participating in daily stand-ups and weekly meetings to improve project coordination.

São Paulo, Brasil

Delivery of official training for SQL Server T-SQL, development, and administration utilizing versions 2008R2, 2012, 2014, 2016, 2017, and 2019.Key Projects:• Demonstrated expertise as a Microsoft Certified Trainer, delivering comprehensive training to dozens of students for over 17 months.• Maintained a consistent participant satisfaction rating of 99% or higher, as measured through post-training evaluations, reflecting the quality of the learning experience and the ability to simplify complex technical concepts.• Played a pivotal role in fostering a culture of continuous learning, contributing to the professional growth of individuals, and ensuring alignment with the latest Microsoft technologies and best practices.• Customized course labs to match individual student needs, resulting in 100% positive feedback on the labs' effectiveness, demonstrating the successful tailoring of training materials to varied learning styles and ability levels.

São Paulo

Led the IT infrastructure team for SPTrans, a leader in public transportation with one of the largest urban bus fleets globally, overseeing the security, performance, and efficiency of critical SQL Server database systems.Key Achievements:• Enhanced database security by 90% through the redesign of server configurations, user management, and elimination of unnecessary permissions, significantly reducing security risks.• Led a five-person IT infrastructure team, fostering collaboration by implementing a monthly reporting system and organizing dedicated meetings to address performance and resolve challenges, driving transparency and accountability.• Coordinated the successful migration of the company’s core HR system, serving as the primary IT liaison, ensuring seamless communication and collaboration between users and third-party providers.• Ensured high availability and optimized performance of critical database systems by proactively conducting maintenance, troubleshooting, and performance tuning.Additional Responsibilities:• Managed the IT infrastructure team.• Managed database migrations, ensuring adherence to best practices.• Defined and implemented database standards and policies.• Collaborated with security auditors for regular assessments and vulnerability management.

São Paulo Area, Brazil

Delivery of official training using SQL Server versions 2008R2, 2012, 2014, 2016, and 2017 for T-SQL, development, and administration.Key Projects:• Successfully served as a Microsoft Certified Trainer for 9 years, positively influencing the development of skills of hundreds of students.• My ability to convey complicated technical topics clearly and engagingly earned me 95%+ consistently favorable feedback for dynamic and successful training delivery, providing a conducive learning atmosphere.• The customization of the course labs to meet the students' needs was well appreciated by 100% of them, resulting in a noticeable improvement in content understanding.

São Paulo Area, Brazil

At TOTVS, a forefront Brazilian software company renowned for global enterprise solutions, I contributed significantly by providing support, maintenance, and troubleshooting services while actively participating in the creation of database environments within TOTVS' private cloud. My role extended to enhancing administrative routines, implementing heterogeneous high-availability solutions, and overseeing the administration of mission-critical systems.Key Projects:• T-SQL development, enhancing automated database management routines.• Pioneered the creation and optimization of procedures for database administrators, streamlining operational efficiency.• Facilitated knowledge transfer to junior and mid-level team members, contributing to skill development and team growth.

Guarulhos

• Spearheaded the planning, design, configuration, and capacity management of the SQL Server environment, including VM servers, for the second busiest airport in the Southern Hemisphere, ensuring high availability and seamless operation for mission-critical systems.• Proactively managed SQL Server databases and VM servers, implementing policy-based management, configuring alerts, and overseeing capacity management to monitor disk space, transaction logs, and performance, ensuring smooth operation and avoiding downtime.• Managed SQL Server databases and virtual machine (VM) servers, conducting regular capacity assessments and optimizing performance through strategic database planning and configuration, ensuring scalability and system efficiency.• Initiated and led a performance tuning project that resulted in a staggering 90% reduction in response time for billing system queries, significantly improving efficiency and user experience.• Identified and addressed the root cause of timeout issues in the air traffic management system, eliminating 100% of blocking timeouts and implementing recommendations that were adopted in other airports worldwide.• Defined and enforced database access controls based on business processes and security requirements, safeguarding sensitive airport data.

São Paulo

Installation, setup and troubleshooting of SQL Server 7.0, 2000, 2005, 2008, 2008R2, Sybase ASE 12.5 and MySQL instances. Maintenance and development of administrative routines, data collection, database migration, performance tuning, improvements, mission critical and high avalability environments. Creation and delivery of technical capacity training.

Determined time database migration project. Responsible for the migration of one of São Paulo's biggest journals' database.

São Paulo Area, Brazil

Installation, ongoing maintenance and troubleshooting of SQL Server 7.0, 2000, 2005, 2008, Sybase ASE 12.5, and MySQL servers. Maintenance and development of administrative routines.

Development, analysis, maintenance and troubleshooting of a documentation generator system, using C# and Visual Basic .Net and SQL Server 2000 / 2005. Database maintenance and performance tuning.