Guilherme Augusto Carniato Francalacci

Professional Summary

An analytical and technically proficient IT professional with 12+ years of experience, now focusing on Database Engineering and Administration roles. Proven ability in SQL, database support and administration (MySQL, PostgreSQL), and ensuring data integrity and system stability for critical UAT environments. Experience includes troubleshooting complex database issues, automating data validation tasks, and supporting database operations within AWS cloud contexts (RDS awareness, EC2). Eager to apply a strong problem-solving aptitude and growing expertise in database performance, optimization, administration, and cloud database solutions to contribute to robust, scalable, and well-maintained database systems. Actively pursuing AWS Certified Cloud Practitioner.

Areas of Expertise

Technical Skills

Professional Experience

• Edenred Payment Technologies, United Kingdom

  2024 – Present

  UAT Support EngineerDatabase Focus

  Ensured the operational stability, integrity, administration, and performance of database environments (MySQL, PostgreSQL) supporting critical UAT platforms. Leveraged SQL for complex data operations, developed automation for database tasks, and supported database infrastructure, including AWS-hosted elements.

  • Engineered Data Integrity & Validation Processes: Designed and implemented SQL-driven validation processes to ensure data accuracy and consistency within UAT databases, supporting reliable testing for financial applications.
  • Resolved Critical Database Incidents & Optimized Queries: Diagnosed and resolved complex issues related to database connectivity, data corruption, and query performance bottlenecks in UAT, occasionally suggesting indexing or query refactoring to improve efficiency.
  • Automated Database Support Tasks: Developed Postman scripts and contributed to Java/JavaScript-based internal tools to automate routine data validation, test data setup, and basic database health checks, enhancing operational efficiency by ~20%.
  • Supported Cloud Database Operations (AWS): Monitored, maintained, administered, and troubleshooted UAT databases operating on or interacting with AWS services (EC2, IAM for secure access), ensuring data availability and consistent performance.
  • Documented Database Procedures & Best Practices: Contributed to the 'UAT Bible' by documenting database schemas (UAT context), administration guides, troubleshooting steps, and standard operating procedures, reducing recurring issues by ~15%.

• Edenred Payment Solutions, United Kingdom

  2021 – 2023

  UAT Analyst

  Provided technical UAT support, focusing on data validation, database integrity, and root cause analysis of data-centric defects within test environments for 10+ major projects. Ensured proper functioning of databases for testing purposes.

  • Led Data-Centric UAT Efforts: Drove the validation of data integrity for new software releases, utilizing SQL to analyze data structures, compare datasets, and ensure adherence to defined schemas and business rules.
  • In-Depth SQL-Based Defect Investigation: Employed advanced SQL queries to trace data flows and investigate the root cause of complex data-related defects, providing detailed technical analysis to development for efficient resolution.
  • Contributed to Test Data Environment Strategy: Assisted in defining processes for test data generation and management, ensuring UAT databases accurately modeled production scenarios for effective system testing.

• Self-Employment, Multiple Countries

  2014 – Present

  ICT Analyst and Developer / Database Consultant

  Delivered IT solutions to diverse clients, including database design (conceptual), setup, configuration, and administration (MySQL, PostgreSQL), alongside developing data-driven applications.

  • Designed and Implemented Client Database Solutions: Assessed client requirements to design conceptual data models and implement functional MySQL/PostgreSQL database schemas, including setup, configuration, security hardening, and ongoing administration for web applications and internal systems.
  • Developed and Optimized Data-Driven Applications: Built and maintained full-stack applications with robust database backends, focusing on efficient data access patterns and query optimization.

• Msp Cine Video, Brazil

  2014 – 2019

  IT Field Support & Infrastructure Engineer

  Managed and supported critical IT infrastructure, including servers hosting databases. Ensured data integrity, availability, and contributed to backup and recovery procedures. Utilized virtualization technologies (VMware, Hyper-V, Oracle VirtualBox).

  • Ensured High Availability of Database Hosting Infrastructure: Maintained server and network infrastructure supporting critical database systems, achieving 98% operational stability and minimizing risks to data.
  • Participated in Data Backup & Recovery Processes: Assisted in the monitoring, testing, and execution of data backup and recovery procedures for key business database systems.

Education & Certifications

• AWS Certified Cloud Practitioner – Amazon Web Services (In Progress – Expected July 2025)
• B.S. in Computer Network Technology – FATEC, Brazil | 2018
• B.S. in Marketing and Advertising – UNIP, Brazil | 2015
• A.A.S. in Computing Technology – ETEC, Brazil | 2012
• Cisco CCNA: Routing & Switching – (Multiple Modules) | 2016-2017

Professional Development

Currently Learning: React, Node.js, Advanced SQL, Database Performance Tuning Concepts, AWS Database Services (RDS, Aurora), Database Security Best Practices

Languages

English: Fluent    Portuguese: Fluent