Gerardo N. Barros Filho Email and Phone Number
montréal, quebec, canada
Gerardo N. Barros Filho's Location
Guarulhos, São Paulo, Brazil, Brazil
About Gerardo N. Barros Filho
I am a seasoned SQL Server database administrator, developer, and engineer with over 18 years of experience.My technical proficiency spans ANSI SQL, Transact-SQL (T-SQL), as well as the administration and mission-critical environments, with experience in both On-Premises and cloud (AWS and Azure) database scenarios. I'm an expert on the definition of backup schedules and the development of automatic administrative routines.My analytical thinking and understanding of SQL Server internals help and accelerate the troubleshooting process.I am particularly interested in performance tuning, and as a former developer I am able to carefully investigate queries and write efficient and performant code.My certifications (MCP, MCITP, MCSA, and Azure Database Administrator Associate) validate my determination to stay ahead of the curve.My passions include not just database programming and management, but also knowledge sharing. As a Microsoft Certified Trainer (MCT), I've been delivering official SQL Server courses since 2011, empowering DBAs, developers, and students. I also actively contribute to the database community by providing workshops and speaking at SQL Saturday, a top event for database technical professionals.My purpose is more than just maintaining stable and optimized database settings; I am committed to sharing knowledge and promoting innovation wherever I go.
Gerardo N. Barros Filho's Current Company Details
Opticca Consulting Inc.
View
SQL Server DBA | Database Engineer | MCT | Speaker
montréal, quebec, canada
- Website:
- opticca.com
- Employees:
- 34
Gerardo N. Barros Filho Work Experience Details
-
Sr. Sql Server DbaOpticca Consulting Inc. Mar 2024 - Present• 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.
-
Senior Sql Server DbaDing.Com Sep 2021 - Jan 2024Dublin, 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. -
Microsoft Certified Trainer (Mct)Green Tecnologia (Treinamento E Consultoria) Apr 2020 - Aug 2021São Paulo, BrasilDelivery 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. -
Technical Project AdministratorSptrans Jun 2018 - May 2021São PauloLed 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. -
Microsoft Certified Trainer (Sql Server)Ka Solution Jan 2012 - Dec 2020São Paulo Area, BrazilDelivery 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. -
Sql Server Database AdministratorTotvs Nov 2017 - May 2018São Paulo Area, BrazilAt 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. -
Database AdministratorGru Airport - Aeroporto Internacional De São Paulo Jan 2013 - Oct 2017Guarulhos• 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. -
Sql Server / Sybase / Mysql Database AdministratorUoldiveo Mar 2010 - Nov 2012São PauloInstallation, 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. -
Sql Server Database AdministratorBrastorage Jun 2012 - Jul 2012Determined time database migration project. Responsible for the migration of one of São Paulo's biggest journals' database. -
Sql Server / Sybase / Mysql Database AdministratorTech4B - Technology For Business Aug 2009 - Mar 2010São Paulo Area, BrazilInstallation, 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.
-
.Net DeveloperHexa Solution Apr 2006 - Aug 2009Development, 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.
Gerardo N. Barros Filho Education Details
-
Faculdade EniacIt
Frequently Asked Questions about Gerardo N. Barros Filho
What company does Gerardo N. Barros Filho work for?
Gerardo N. Barros Filho works for Opticca Consulting Inc.
What is Gerardo N. Barros Filho's role at the current company?
Gerardo N. Barros Filho's current role is SQL Server DBA | Database Engineer | MCT | Speaker.
What schools did Gerardo N. Barros Filho attend?
Gerardo N. Barros Filho attended Faculdade Eniac.
Who are Gerardo N. Barros Filho's colleagues?
Gerardo N. Barros Filho's colleagues are Peter Nkeng, Karishma Bhole, Paula Ciampini, Matheus Torres, Natacha Lambert, Alison Cassidy, Scott Johansson.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial