Skip to content
View ritojoao's full-sized avatar

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

52 upstream PRs 8 merged 30 projects thanked by maintainers 2

Contributing upstream to the tools I run in production: pg_partman · postgres_exporter · mongodb_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."
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 · 43 open pull requests in 27 projects · All my PRs

Patroni, mydumper, gh-ost, postgres_exporter, pg_repack, ProxySQL, WAL-G, pgroll, PyMySQL, PynamoDB, dynamodump, awslabs/mcp, aws-advanced-python-wrapper, pg_partman, pgBouncer, pgcli, CloudNativePG, Postgres Operator, Liquibase, go-sql-driver/mysql, go-mysql, pgstream, mariadb-operator, redis-operator, Apache AGE, ldap2pg, prometheus-rds-exporter.


🇧🇷 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

52 PRs upstream 8 merged 30 projetos 2 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."
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 · 43 pull requests abertos em 27 projetos · Todos os meus PRs

Patroni, mydumper, gh-ost, postgres_exporter, pg_repack, ProxySQL, WAL-G, pgroll, PyMySQL, PynamoDB, dynamodump, awslabs/mcp, aws-advanced-python-wrapper, pg_partman, pgBouncer, pgcli, CloudNativePG, Postgres Operator, Liquibase, go-sql-driver/mysql, go-mysql, pgstream, mariadb-operator, redis-operator, Apache AGE, ldap2pg, prometheus-rds-exporter.

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