Skip to content
View ritojoao's full-sized avatar
5 followers · 6 following

Achievements

Achievement: QuickdrawAchievement: Pull SharkAchievement: Arctic Code Vault Contributor

Achievements

Achievement: QuickdrawAchievement: Pull SharkAchievement: Arctic Code Vault Contributor

Block or report ritojoao

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ritojoao/README.md

Hi, I'm Rito 👋

Staff Database Reliability Engineer who builds platforms. I keep databases fast, boring and recoverable, and I turn the work around them into self-service.

  • Deep: PostgreSQL and MySQL (RDS, Aurora), DynamoDB
  • Daily: MongoDB and Amazon DocumentDB
  • Platform: Apache Airflow as the engine, Backstage as the front door, Python in between
  • Also: Prometheus monitoring, partitioning, migrations, AI agents for database maintenance
  • Certified: AWS Solutions Architect Professional, Astronomer DAG Authoring for Apache Airflow 3, AWS Database Specialty (2023-2026), MongoDB skill badges in indexing design and CRUD (Credly)

Things I've shipped

  • Migrated 280+ production MySQL databases from RDS to Aurora: cutover under 5 minutes, rollback via reverse replication, about 40% lower cost (AWS blog).
  • Fixed DynamoDB throttling on a hot path by splitting reads and writes (CQRS) (TDC talk).
  • Built a hot/warm/cold data lifecycle so large tables stay small and cheap.
  • Led an internal developer portal with 40+ self-service capabilities used by 4 teams, cutting database provisioning from days to minutes.
  • Run database maintenance as Airflow DAGs with AI agents in the loop (TDC talk).

Writing and talks

Open source

84 upstream PRs 12 merged 48 projects thanked by maintainers 5

Contributing upstream to the tools I run in production: pg_partman · postgres_exporter · dynamodump

Critical database infrastructure
Project Pull request Merged by Kind words
Patroni
patroni/patroni		 Skip ensure_unique_name() with the Kubernetes DCS @hughcapet
mydumper
mydumper/mydumper		 Skip index checksum verification when --skip-indexes is used @davidducos
mydumper
mydumper/mydumper		 Honor --ignore-set when --optimize-keys=SKIP is used @davidducos
mydumper
mydumper/mydumper		 Handle SIGTERM and non-interactive SIGINT without holding locks or reporting success @davidducos 🙏 @frankii91 "Thanks @ritojoao."
mydumper
mydumper/mydumper		 Fix table-level trigger checksum options @davidducos
python-mysql-replication
julien-duponchelle/python-mysql-replication		 fix: parse MariaDB 11.7 Q_GTID_FLAGS3 and Q_CHARACTER_SET_COLLATIONS status variables @dongwook-chan 🙏 @dongwook-chan "Thanks for the focused fix and regression test."
MCP-PostgreSQL-Ops
call518/MCP-PostgreSQL-Ops		 fix: scope pg_class joins by schema in get_table_schema_info @call518 🙏 @call518 "Thanks @ritojoao for the fix and the clear reproduction!"
MCP-PostgreSQL-Ops
call518/MCP-PostgreSQL-Ops		 fix: scope constraint lookups in get_table_schema_info to the table @call518 🙏 @call518 "Nice work tracking this one down."
MCP-PostgreSQL-Ops
call518/MCP-PostgreSQL-Ops		 Apply wait_event_type filter to get_wait_events session summary on PG 17+ @call518 🙏 @call518 "Good catch on the PG 17+ path drifting from the older one."
pg_repack
reorg/pg_repack		 Cancel in-progress index builds on SIGINT with --jobs @za-arthur
community.postgresql
ansible-collections/community.postgresql		 fix(postgresql_alter_system): compare with the pending value when a restart is required @hunleyd
Amazon DocumentDB tools
awslabs/amazon-documentdb-tools		 metrics-collector v2.5.2: report the observed data window, not only the requested period (#209) @tmcallaghan

In review · 69 open pull requests in 45 projects · All my PRs

Patroni, mydumper, gh-ost, postgres_exporter, pg_repack, ProxySQL, WAL-G, pgroll, pgstream, PyMySQL, PynamoDB, dynamodump, awslabs/mcp, Aurora DSQL tools, connectors and ORMs, aws-advanced-python-wrapper, pg_partman, pgBouncer, pgcli, psycopg, CloudNativePG, Postgres Operator, Liquibase, go-sql-driver/mysql, go-mysql, mariadb-operator, redis-operator, Apache AGE, ldap2pg, prometheus-rds-exporter, pev2, pgbadger, pgAdmin, powa-web, libpg_query, asyncpg, aiomysql, pg_auto_failover, pg_cron, pg_activity, pgcopydb, Percona XtraDB Cluster Operator, sqlc.

🇧🇷 Em português

Oi, sou o Rito 👋

Staff Database Reliability Engineer que constrói plataforma. Mantenho bancos de dados rápidos, previsíveis e recuperáveis, e transformo o trabalho em volta deles em self-service.

  • Fundo: PostgreSQL e MySQL (RDS, Aurora), DynamoDB
  • Dia a dia: MongoDB e Amazon DocumentDB
  • Plataforma: Apache Airflow como motor, Backstage como porta de entrada, Python no meio
  • Também: monitoração com Prometheus, particionamento, migrações, agentes de IA para manutenção de banco
  • Certificações: AWS Solutions Architect Professional, Astronomer DAG Authoring for Apache Airflow 3, AWS Database Specialty (2023-2026), badges de MongoDB em design de índices e CRUD (Credly)

O que já entreguei

  • Migrei mais de 280 bancos MySQL de produção do RDS para o Aurora: cutover abaixo de 5 minutos, rollback por replicação reversa, custo cerca de 40% menor (blog da AWS).
  • Resolvi throttling do DynamoDB num caminho crítico separando leitura e escrita (CQRS) (palestra no TDC).
  • Montei um ciclo de vida de dados quente/morno/frio para tabelas grandes ficarem pequenas e baratas.
  • Liderei um portal interno com mais de 40 capacidades self-service usado por 4 times, levando o provisionamento de banco de dias para minutos.
  • Rodo manutenção de banco como DAGs do Airflow, com agentes de IA no meio do fluxo (palestra no TDC).

Textos e palestras

Open source

84 PRs upstream 12 merged 48 projetos 5 agradecimentos de mantenedores

Infraestrutura crítica de banco de dados
Projeto Pull request Merged por Palavras gentis
Patroni
patroni/patroni		 Skip ensure_unique_name() with the Kubernetes DCS @hughcapet
mydumper
mydumper/mydumper		 Skip index checksum verification when --skip-indexes is used @davidducos
mydumper
mydumper/mydumper		 Honor --ignore-set when --optimize-keys=SKIP is used @davidducos
mydumper
mydumper/mydumper		 Handle SIGTERM and non-interactive SIGINT without holding locks or reporting success @davidducos 🙏 @frankii91 "Thanks @ritojoao."
mydumper
mydumper/mydumper		 Fix table-level trigger checksum options @davidducos
python-mysql-replication
julien-duponchelle/python-mysql-replication		 fix: parse MariaDB 11.7 Q_GTID_FLAGS3 and Q_CHARACTER_SET_COLLATIONS status variables @dongwook-chan 🙏 @dongwook-chan "Thanks for the focused fix and regression test."
MCP-PostgreSQL-Ops
call518/MCP-PostgreSQL-Ops		 fix: scope pg_class joins by schema in get_table_schema_info @call518 🙏 @call518 "Thanks @ritojoao for the fix and the clear reproduction!"
MCP-PostgreSQL-Ops
call518/MCP-PostgreSQL-Ops		 fix: scope constraint lookups in get_table_schema_info to the table @call518 🙏 @call518 "Nice work tracking this one down."
MCP-PostgreSQL-Ops
call518/MCP-PostgreSQL-Ops		 Apply wait_event_type filter to get_wait_events session summary on PG 17+ @call518 🙏 @call518 "Good catch on the PG 17+ path drifting from the older one."
pg_repack
reorg/pg_repack		 Cancel in-progress index builds on SIGINT with --jobs @za-arthur
community.postgresql
ansible-collections/community.postgresql		 fix(postgresql_alter_system): compare with the pending value when a restart is required @hunleyd
Amazon DocumentDB tools
awslabs/amazon-documentdb-tools		 metrics-collector v2.5.2: report the observed data window, not only the requested period (#209) @tmcallaghan

Em revisão · 69 pull requests abertos em 45 projetos · Todos os meus PRs

Patroni, mydumper, gh-ost, postgres_exporter, pg_repack, ProxySQL, WAL-G, pgroll, pgstream, PyMySQL, PynamoDB, dynamodump, awslabs/mcp, Aurora DSQL tools, conectores e ORMs, aws-advanced-python-wrapper, pg_partman, pgBouncer, pgcli, psycopg, CloudNativePG, Postgres Operator, Liquibase, go-sql-driver/mysql, go-mysql, mariadb-operator, redis-operator, Apache AGE, ldap2pg, prometheus-rds-exporter, pev2, pgbadger, pgAdmin, powa-web, libpg_query, asyncpg, aiomysql, pg_auto_failover, pg_cron, pg_activity, pgcopydb, Percona XtraDB Cluster Operator, sqlc.

Sempre topo uma boa conversa sobre banco de dados em produção.

Popular repositories Loading

  1. coronavirus coronavirus Public

    Estudos sobre corona

    Python 2

  2. BotBandejao BotBandejao Public

    Bot para agendamento automático de almoço.

    Python 1

  3. Crud-em-Node Crud-em-Node Public

    Aprendendo os conceitos de node para criação de uma crud

    CSS

  4. learnyounode learnyounode Public

    Exercícios resolvidos do treinamento do leranyounode

    JavaScript

  5. DAMIC DAMIC Public

    Python

  6. EasyMenu EasyMenu Public

    Aplicativo desenvolvido durante treinamento na Mastertech

    JavaScript