Luis

DBA Specialized in AWS Cloud and Automation

Luis Pixelated

Profile

[AWS CLOUD DBA]

  • Managed and optimized AWS RDS Aurora databases, ensuring high availability and scalability.
  • Automated cloud deployments using Terraform and Scalr, reducing deployment time and minimizing human error.
  • Migrated bash scripts to GitHub Actions, improving CI/CD workflows and enhancing task automation efficiency.
  • Configured Datadog for advanced system monitoring, including customized dashboards and proactive alerting to ensure optimal performance.
  • Continuously managed Oracle, PostgreSQL, MySQL databases, focusing on high availability and performance.

[MYSQL + ORACLE DBA]

  • Migrated all MySQL 5.6 servers to version 8.0.19.
    • Migrated slave servers first, then started replication.
    • Migrated source production servers with 2.5T of data between 23h and 4h00.
  • Implemented MySQL replicaset for enhanced features.
  • Started using shell util dump for quicker backups.
  • Other Infrastructure Tasks:
    • Created VM in AWS environment via Terraform.
    • Configured services via Puppet.
  • Oracle database 11G managment, backups, query tunning, monitoring

[ORACLE DBA EXADATA ENVIRONMENT]

  • In charge of the entire database environment.
  • Composition:
    • Oracle database 12c One node Cluster over Exadata technology.
    • PostgreSQL databases across NUTANIX virtualization platform.
      • Recent migration from PostgreSQL 9.6 to 10 using pg_upgrade tool.
    • MariaDB databases.
  • New environment setup with SALT; installations managed via SALT technology.
  • Investigated CockroachDB for distributed data over different platforms.
  • Transitioned to new technologies like Elasticsearch, Logstash, Kibana (ELK).
  • Utilized Docker containers.
  • Designed monitoring system for PostgreSQL databases using Telegraf, InfluxDB, and Chronograf.

[ORACLE ARCHITECT]

  • Analyzed 270 Oracle productive instances for performance tuning.
    • Added data check flows to assist the development team in optimizing module performance.
  • Planned to set up and install an AWR repository to register all SQL queries, grouped by applications.
    • This repository aids in identifying SQL performance issues or degradation over time.
  • Involved in a major Exadata project for migrating databases from standard installation to Oracle Exadata.
    • Assisted in application validation.
    • Aimed to consolidate certain databases as schemas or evaluate which can be set as pluggable databases, as Exadata will use Oracle version 12c.