Amaury Germano Junior

I am responsible for overseeing and managing the company’s entire database environment in Brazil, ensuring high availability, performance, security, and operational continuity across all critical systems. My main activities include: Administration of databases running SQL Server 2016, 2019, 2022, and Azure SQL Database Access control management using customized roles Development and automation of database maintenance routines Implementation and management of Backup/Restore strategies SQL Server version upgrades and migrations Environment refresh for QA and development environments Data Masking (DataMasking) to ensure compliance and data protection Query tuning and performance optimization, providing recommendations to development teams Design, creation, and management of monitoring solutions using Grafana, InfluxDB, and Telegraf Administration of SSIS packages (SQL Server Integration Services) Preparation of analytical and operational reports for stakeholders Configuration and management of Always On Availability Groups Failover Cluster Instance (FCI) administration Planning, validating, and executing database changes and deployments Handling incidents, troubleshooting, and technical support for critical issues Development of dashboards using Power BI Data analysis and insights generation Management and maintenance of Data Warehouse (OLAP) environments

Providing Level 3 (N3) database support for small, medium, and large companies across multiple industries. Faitec has strong expertise in the hospitality sector, working with TOTVS CM and Winthor systems. Main Responsibilities and Activities: Administration of SQL Server databases from versions 2008 to 2017 Database version upgrades and migration planning Implementation of high availability solutions: Always On, Database Mirroring, and Log Shipping SQL Server performance tuning using PerfMon counters and DMVs Preparation of detailed reports about customer environments, covering hardware and software performance, and recommending improvements based on Microsoft best practices Development of administrative routines in T-SQL for SQL Server database management Strategic database migrations with minimal downtime Feasibility analysis for version upgrades Administration of PostgreSQL environments (versions 9.5 and 9.6) and MySQL 9.7 Administration of Oracle databases (10g, 11g, and 12c) Test environment refresh (Oracle, SQL Server, PostgreSQL, and MySQL) Full environment health checks Database Backup/Restore operations Execution of database-related projects across multiple technologies

Administration of SQL Server environments (2000, 2005, 2008 R2) and Oracle 11g Development and maintenance of administrative routines in SQL Server T-SQL query tuning and performance optimization Backup and restore operations for SQL Server and Oracle databases Management of Windows Failover Cluster (WFC) environments Planning, validating, and executing database changes Handling service requests and incident resolution Managing tablespaces in filesystem and ASM environments Administration of tables involved in Oracle GoldenGate replication Applying patches and updates to Oracle environments

Development and maintenance of administrative routines for SQL Server 2008 R2 and 2012 instances Execution of performance tuning in SQL Server environments Deployment of database releases using TFS (Visual Studio) Creation of reports using Reporting Services (SSRS) Planning, validating, and approving database changes Providing support to the development team Performing database refreshes from production to Dev/Hom/QA environments Handling internal support tickets from the development team and application support via Service Center Environment migration and upgrade activities

Responsibilities: Conduct on-site visits to multiple clients to perform performance analysis Work on internal and external database projects Focused expertise in SQL Server performance tuning Perform performance diagnostics in critical environments Prepare weekly Health Check reports Apply SQL Server, Storage, and Windows Server best practices Migrate critical environments, including implementation of SQL Server Mirroring, Log Shipping, and Replication Implement SQL Server 2012 Always On Availability Groups

Responsibilities: Work on medium and large-scale database projects Perform performance analysis in critical environments Analyze execution plans for optimization opportunities Prepare performance reports with improvement recommendations Apply SQL Server, Storage, and Windows Server best practices Migrate critical environments with minimal disruption Implement administrative routines for SQL Server 7.0, 2000, 2005, 2008 R2 and Sybase 12.5 Install and configure SQL Server instances Implement high availability solutions such as Log Shipping, Mirroring, and Replication Install and configure high-availability cluster environments Handle support tickets and incident resolution Perform database Backup and Restore operations Validate and execute database changes across environments

Responsibilities: Perform mailbox backup and restore operations using CommVault Provide end-user support for hardware, software, and applications Install and configure DELL servers Install and support the Microsoft Office suite for users Administer and configure SQL Server instances Execute database backup and restore operations Configure cluster environments to ensure high availability Grant and revoke access for users and applications Analyze T-SQL code and propose improvements Assist with supervised installation and configuration of corporate routers and switches Create and manage user accounts in Active Directory Manage access permissions on the File Server Administer virtual machines using Hyper-V and VMware

Realização de intercâmbio cultural com o objetivo de aprimorar o idioma inglês. Curso realizado na Escola ILSC Education Group em Sydney, Austrália. Residindo por 1 ano (março de 2017 a março de 2018) e interagindo 100% do tempo com nativos e estudantes de outras nacionalidades. Além de estudar, também trabalhei com serviços gerais sendo necessário interagir com clientes diariamente.