Systems and telecommunications engineer, with 9 years of experience in roles related to databases. (SQL Server, PostgreSQL, Oracle, MySQL, MongoDB, DocumentDB). On-prem and Cloud experience (AWS and Azure). Senior DBA, tech lead, consultant.
Advise clients on how to move their databases on premise to the cloud (AWS Cloud), using different strategies and selecting the type of engine they should use according to their needs. Research on new services that the industry could provide them. Use of AWS CloudFormation to provide and manage the infrastructure by using Git repositories.
Major achievementKnowledge of new tools for migration from on-prem to cloud such as Schema Cnversion tool, DMS, CloudFormation, among others.
Provide support to cases of all levels in PostgreSQL engines, mainly performance issues and cluster configuration, statement review and instantiation through pipelines. Diagnosis and solution of SQL Server problems on prem (versions from 2005 to 2019). Study of new tools such as Datadog and terraform to incorporate the team methodology
Major achievementInstallation and configuration of a client application under a clustering tool called Patroni.
AWS RDS PostgreSQL, AWS Aurora MySQL, AWS DocumentDB, MongoDB, AWS RDS SQL Server. Troubleshooting and lvl 1, 2 and 3 diagnostics. Python and bash scripting using DevOps methodology for process automation. As a DBA leader, I was in charge of providing KT to new teammates, document all of our procedures for supporting our internal customers, and attend technical meetings with vendors.
Major achievementDocument and run an AWS RDS PostgreSQL 9.3 to 12.0 migration procedure from the old RDS instance classes to the new graviton classes.