Accomplished Database Administrator with a proven track record at Flextronics, adept in SQL Server, Azure SQL, and Amazon RDS. Expert in deploying high availability solutions and enhancing database performance. Demonstrates exceptional troubleshooting skills and a commitment to maintaining system security and integrity. Skilled in both technical innovation and strategic planning.
Overview
4
4
years of professional experience
1
1
Language
Work History
DBA III
Solera
Ciudad De México. (Remote)
06.2024 - Current
Responsible for working with Infra team to set up environments for new projects.
Perform database instance migrations from unsupported SQL Server versions to new SQL Server versions.
Experience on High Availability Disaster Recovery Solutions. Failover Clusters and AlwaysOn Availability Groups and Replication.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure performance, availability and security.
Support on 24x7 environment and critical production systems.
Document the procedures and processes.
Troubleshooting skills.
DBA III
Global Hitss
Guadalajara, Jalisco.
07.2023 - 06.2024
Resposible for SQL Server installation, upgrade, and patching on versions 2016, 2017, 2019 and 2022.
SQL instance and database decommissions.
Perform database instance migrations from unsupported SQL Server versions to new SQL Server versions.
Configure and monitor High Availability and Disaster Recovery solutions in Always-On and Failover Cluster environments.
Manage maintenance plans; re-index, update stats, check-db and tunning db strategies to ensure optimal database performance.
Responsible for backup strategies for all environments small, medium, and large databases.
Perform T-SQL code reviews to change that will be implemented in quality and production environments.
Audit and grant access through SQL Logins, AD Groups and Windows Users in SQL Server, MySQL and Postgres SQL.
Diagnose address and troubleshooting SQL performance issues using DM views, Resource monitor and Idera monitor tools.
Deploy code through pipelines using Jenkins.
Implement and apply Dynamic Data Masking on SQL databases with NPI (non-public information) data using Dataveil Microsoft tool.
AWS
Experience in deploy RDS databases in AWS with the engines MySQL and PostgreSQL.
Export and import MySQL databases in AWS.
Audit and grant access in PostgreSQL and MySQL databases in the AWS.
Troubleshooting RDS performance issues.
Database Administrator, IT
Flextronics
Zapopan, Jalisco, Mexico.
06.2021 - 07.2023
SQL Server installation, upgrade, and patching on SQL Server 2016, 2017, 2019 and 2022.
Create and configure new databases.
Work with replication (set up, adding articles and troubleshooting issues).
Work with incidents (fixing space issues, blocks, performance issues).
Audit and grant access to SQL and Windows Logins.
Work on backup and recovery strategies.
Create new linked servers and SQL Jobs.
Create documents for the new process in Azure SQL.
Azure
Migration from On-Premises databases to Azure SQL Database.
Deploy, verify, and configure Azure SQL Databases and Managed Instances on different service tiers.
Implement network and security management for Azure SQL using firewall rules and private links.
Audit and grant access in Azure SQL Databases and Managed instances.
Restore a database or object in a point in time as well as
configure LRT in Azure SQL DBs.
Create, configure, manage, and monitor elastic jobs.
Experience with Windows Server administration using Active Directory.
Senior SQL DBA / Applications Analyst at Mission Support and Test Services, LLCSenior SQL DBA / Applications Analyst at Mission Support and Test Services, LLC