Data Architect
Current• Provided database administration and programming in MS SQL Server databases (versions 2008-2017) and Azure Databases (Hybrid Environment): PaaS & IaaS. • Provided strategic direction for Development Teams and Data Architecture On premise and Azure. • Monitor database performance, troubleshooting, tuning MS SQL Databases. Implementing changes and applying new patches and versions when required. • Provided SSIS ETL for migrating/loading/archiving data. • Ensure that storage and archiving procedures are functioning correctly (Veeam & Pure Storage).• Virtual infrastructure management with VMware vSphere. Administration on Windows Servers (Windows Server 2008 – Windows Server 2019)• Monitor & maintain backups for disaster recovery. Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration. • Ensure security on production environments (certificates, SSL, Encryption, Carbon Black sensors, Users, Roles)• Expert Microsoft package (Analysis & Reporting & Integration Services)• Source Control for MS Databases objects and code (T-SQL), Backups & Restores, Monitoring and Documentation with Red Gate tools and SolarWinds platform. • Business Intelligence (BI): Tableau&SSRS. Creating dashboards monitoring main indicators about performance in databases platform.• Agile development methodology: JIRA Agile