Hire Talent

Thiago Rocha Alves

MongoDB DBA

Teresopolis, Rio de Janeiro, Brazil

15+ Years Exp

Summary

Thiago is a Database Administrator with expertise in SQL Server and extensive hands-on experience in MongoDB, including administration, replication, and backup strategies. He has a proven track record in performance tuning, query optimization, high availability, and disaster recovery across SQL and NoSQL environments. He is skilled in integrating and managing PostgreSQL, MySQL, Cosmos DB, and Azure SQL DB, with additional exposure to AWS, Google Cloud, and Oracle. He is adept at scripting in Python for automation, managing production systems, and implementing secure, scalable data architectures. He is known for solving complex issues and collaborating with cross-functional teams in Agile/Scrum settings.

Technical Skills

Detailed View

SQL

Data Modeling

Database Administration

ETL

MySQL

Power BI

Data Warehousing

Python and Bash

Powershell

PostgreSQL and MySQL

MongoDB (including Atlas)

Oracle

AWS RDS

PostgreSQL

Other Skills

English

Spanish

Portuguese

Work Experience

Database Administrator

Technology Sector Company

Full Time | 02/03/2021 - Present

United States

Managed and maintained multiple MongoDB and SQL Server database instances, ensuring high availability, disaster recovery, performance tuning, and scalability.
Administered MongoDB clusters and performed routine backups, restores, and upgrades across Linux and Windows environments.
Supported cloud-based database services including AWS RDS and Azure SQL DB, focusing on deployment, configuration, monitoring, and performance.
Engineered ETL pipelines integrating MongoDB, Databricks, Azure Data Factory, and Python for ingesting and transforming large datasets.
Designed and implemented data models using Star and Snowflake schemas, supporting both tabular and multidimensional formats to meet business needs.
Developed business intelligence solutions using Power BI, Microsoft Fabric, AAS, Tableau, Datasets, and Dataflows.
Connected Power BI to SSAS, AAS, and other databases via Live Connection, Direct Query, and Import modes for dynamic reporting.
Utilized DAX, SQL, MDX, SSAS Cubes, SSIS, and SSRS for advanced analytics and reporting functionalities.
Applied programming skills in Java, JavaScript, VB, and HTML to build customized data and reporting solutions.
Led T-SQL development, including stored procedures, triggers, DML/DDL scripting, functions, and advanced indexing strategies.
Tuned complex MongoDB and SQL queries using tools like SQL Profiler, mongotop, and mongostat to optimize performance.
Ensured database security and compliance through encryption, audit logging, role-based access controls, and vulnerability patching.
Troubleshot critical production issues across MongoDB, SQL Server, and cloud environments, collaborating with stakeholders, developers, and infrastructure teams.
Worked with a diverse tech stack including NoSQL databases (MongoDB, Cassandra, Redis), relational systems (Oracle, SAP HANA, PostgreSQL, MySQL), and cloud platforms (AWS, Azure, Google Cloud, Synapse, Snowflake).
Operated within Agile/Scrum environments, leveraging Git, GitHub, GitLab, JIRA, Azure DevOps, Azure Repos, and TFS for collaboration, source control, and CI/CD pipeline management.
Supported hybrid data architectures across AWS, Azure, and on-premises environments, with proactive monitoring and issue resolution.

Database Administrator

Tiplan

Full Time | 01/04/2013 - 25/02/2021

Rio de Janeiro, State of Rio de Janeiro, Brazil

Administered and maintained MongoDB and SQL Server databases across Linux and Windows environments, ensuring high availability, disaster recovery, and performance optimization.
Delivered end-to-end Business Intelligence (BI) and data engineering solutions using Power BI, DAX, SSIS, SSAS, SSRS, Python, and Azure services, tightly integrated with backend databases.
Supported AWS RDS and Azure SQL DB deployments, managing backups, monitoring, and configuration across cloud-based and hybrid architectures.
Designed and modeled enterprise data warehouses and OLTP schemas, implementing Star and Snowflake models to support real-time analytics and reporting.
Developed and managed ETL pipelines using Databricks, Azure Data Factory, SSIS, Pentaho, and Python, loading data into MongoDB, SQL Server, and PostgreSQL.
Conducted proactive troubleshooting and incident resolution in production MongoDB and SQL environments, collaborating closely with infrastructure and application teams.
Tuned MongoDB queries using indexing, aggregation pipelines, and monitoring tools like mongotop, mongostat, and Atlas Performance Advisor.
Optimized complex SQL Server queries and indexing strategies using SQL Profiler, Execution Plans, and Query Store.
Implemented robust security policies including role-based access control (RBAC), encryption, and auditing in both MongoDB and SQL environments.
Managed replication, backups, sharding, and upgrade processes for MongoDB clusters in on-prem and cloud-hosted instances.
Led full lifecycle database projects including schema design, normalization, migration, patching, and version upgrades.
Oversaw CI/CD database pipelines, version control, and automation using Git, Azure DevOps, and Jenkins.
Ensured data integrity, enforced retention policies, and conducted capacity planning for mission-critical applications.
Supported diverse workloads across AWS, Azure, and on-prem infrastructure, delivering consistent monitoring, alerting, and system health checks.

Analyst

ERP System Development Company

Full Time | 22/12/2010 - 05/09/2012

Brazil

Provided technical support and performed on-site client visits for installation and maintenance of customized ERP systems.
Managed and configured SQL Server databases, ensuring optimal performance and availability.
Executed T-SQL development and query optimization for business operations.
Led database migration projects from diverse data sources into SQL Server environments.

Education

Diploma in Computer Systems Technology

UFF

Master's degree in Data Science & Artificial Intelligence

FIAP

Certifications

Power BI Data Analyst Associate

Microsoft | Issued On : 10/10/2022

Microsoft Certified: Azure Data Engineer Associate

Microsoft | Issued On : 11/12/2023

Microsoft Certified: Azure Fundamentals

Microsoft

Microsoft Certified: Administering Microsoft SQL Server

Microsoft

Microsoft Certified: Querying Microsoft SQL Server

Microsoft

Microsoft Certified Professional

Microsoft

Microsoft Technology Associate

Microsoft

Database Fundamentals

Microsoft

Cambridge English: First

Cambridge English Brazil

Hire Faster. Innovate Faster.

Hyqoo AI streamlines the entire process, moving seamlessly from precise skill matching to interviews and onboarding. The moment your request enters the system, our intelligent algorithms spring into action, identifying the ideal talent with laser focus. With Hyqoo AI, you spend less time searching and more time building your dream team. Get the best talent, faster, and focus on innovation