SQL Server DBA • March-2024
Description: Spearheaded a comprehensive review and reorganization of the database environment, aligning it with industry best practices and significantly mitigating issues and vulnerabilities. • Engineered and implemented automated routines for backup, index rebuilds, and database integrity checks, enhancing data security and operational efficiency. • Achieved a substantial reduction in disk space usage by analyzing and resizing data files and transaction logs across 200+ databases, resulting in a savings of over 3.5 terabytes. • Successfully executed security configurations and enhanced log monitoring for 100% of database servers within three weeks, substantially strengthening the overall security posture. • Optimized data storage efficiency through strategic management of database filegroups and compression settings. • Played a pivotal role in several on-premises database migrations to SQL Server 2022, ensuring seamless transitions with minimal downtime and maintaining data integrity.
SQL Server DBA • September-2021 to January-2024
Ding.com
Description: • Developed and implemented administrative routines in T-SQL and PowerShell, resulting in an 80% reduction in manual administrative duties and a 10% rise in automatic administrative procedures. This automation improved productivity and observability, allowing more time for strategic projects. • 31.6% average reduction in the size of production databases by implementing data compression. Due to the avoidance of the need to expand the disks for the database files, this also resulted in disk space savings and prevented cost increases. • Implemented encryption certificates for 100% of database backups in production and staging environments, reducing the risk of unwanted access, ensuring compliance with industry standards and data privacy regulations. This effectively protected critical data, improving the overall security posture. • Analyzed indexing and coding optimizations, and performed on-demand performance tuning activities, improving performance in more than 80%. • Provided technical support and improvement recommendations to the development team
Microsoft Certified Trainer (MCT) • April-2020 to August-2021
Green Tecnologia
Description: • Demonstrated expertise as a Microsoft Certified Trainer, delivering comprehensive training to dozens of students for over 17 months. Students reported skill improvement and positive impact on their jobs after the training. • Consistently delivered a 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. • 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 Administrator • June-2018 to May-2021
SPTrans
Description: As a Technical Project Administrator at SPTrans, a leader in public transportation with one of the world's largest urban bus fleets, I championed the security, performance, and efficiency of their mission-critical SQL Server database environment. Accomplishments: • Enhanced Database Security by 90%: Redesigned server configuration and user management, eliminating unnecessary permissions and enforcing best practices. This significant improvement significantly reduced security risks. • Streamlined Team Collaboration: Implemented a monthly results reporting system and facilitated dedicated meetings to discuss performance and address challenges. This fostered transparency and accountability within the five-person IT infrastructure team I managed. • Successfully Migrated the Core HR System: Played a vital role in the successful migration of the company’s core HR system, acting as the project's IT focal point. This involved coordinating with users and providers to ensure a seamless transition. • Maintained High Availability & Performance: Ensured optimal uptime and performance for SPTrans's critical database systems through proactive maintenance, troubleshooting, and performance tuning efforts. Additional Responsibilities: • 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 (MCT) • January-2012 to December-2020
Ka Solution
Description: • Building Practical SQL Server Skills: My passion for clear communication translated into consistently high student satisfaction, with 95%+ favorable feedback for my dynamic and engaging training delivery. But the true reward lies in empowering students to excel in their careers. • Targeted Course Customization: By tailoring course labs to each student's needs (resulting in 100% appreciation!), I ensured a deep understanding of the material. This directly translated into numerous students reporting a significant increase in their ability to apply SQL Server skills in their job-related activities.
Sr SQL DBA • November-2017 to May-2018
TOTVS
Description: • At TOTVS, a forefront Brazilian software company renowned for global enterprise ERP solutions, I contributed significantly by providing support, maintenance, and troubleshooting services while actively participating in the creation of database environments within TOTVS' private cloud infrastructure, to serve SaaS TOTVS ERP Protheus and RM. • 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 administrator • January-2013 to October-2017
GRU Airport
Description: As a Database Subject Matter Expert, I spearheaded the creation, optimization, and ongoing maintenance of the SQL Server environment for the second busiest airport in the Southern Hemisphere. This highly complex infrastructure supported critical operations across the airport, including billing, air traffic management, and more. • Performance Optimizer: I spearheaded a self-initiated performance tuning project that resulted in a staggering over 90% reduction in response time for billing system queries, significantly improving efficiency and user experience. • Problem-Solving Expertise: Identified and addressed the root cause of timeout issues plaguing the air traffic management system. My investigation led to the complete elimination (100%) of blocking timeouts and recommendations implemented in other airports worldwide. • Proactive Management: Implemented policy-based management and configured SQL Server alerts for proactive monitoring of disk space, transaction logs, database errors, and backups, ensuring the smooth operation of the environment. • Database Security Enforcer: Defined and enforced database access controls based on business processes and security requirements, safeguarding sensitive airport data. • Collaborative Expertise: Supported teams of developers and analysts by providing valuable insights, schema refinement recommendations, and performance tuning expertise.
Database administrator • August-2009 to November-2012
Technology 4 Business / UOLDIVEO
Description: • Creation, maintenance, and seamless deployment of administrative and data collection routines to hundreds of production servers. • Database migration, performance tuning, improvements, mission-critical and high-availability environments. • Conducted technical capacity training for SQL Server DBAs.