Beatriz Adriana Gonzalez Garcia

• 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.

• 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.

• 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.