Jose Ortiz-Torres

· Database monitoring daily.

· Using PowerShell for task automation.

· Database migration to newer versions on SQL OnPrem and Azure.

· Creating and configuring High Availability Groups.

· Meeting for testing and coordinate modifications with IRS stakeholders.

· Fully working from home.

• Monitoring and maintenance more than 200 SQL servers using SolarWinds Database Performance Analyzer and native SQL tuning/performance tools
• Keeping tools upgraded
• Creating alerts in SolarWinds Database Performance Analyzer
• Configuring SQL servers disk space, memory and cores needed for installation
• Create High Availability and maintenance for Windows Failover Clustering
• C# programming to develop new applications and change existing code as requested
• SQL migration from SQL 2008 – 2019
• Backup automation using Redgate SQL Backup tool and stored procedures
• Coordinating with third parties to migrate their system to newer SQL database version
• Databases / Servers support on 24/7 for all environments (QA/DEV/PROD)
• Support to SSIS, SSAS, SSRS and PowerBI as needed by users
• Applying Windows security monthly patches and SQL cumulative upgrades
• Security of DB's creating and maintaining security groups and admin users
• Maintenance for database indexes and creating new ones when needed or requested
• Experience with Azure SQL Vm’s and Managed Instances, backups
• Azure Data Factory pipelines creation
• Informatica MDM
• Working / creating / securing Azure databases
• PowerShell scripting to automate processes
• Fully working from home.

• Daily database monitoring procedures
• Automation using PowerShell scripting for different processes as system health, disk space, failed jobs, etc
• Migrating database objects to newer version of SQL
• Validating and setting database mirroring configuration
• Creating and maintenance of system alerts
• Upgrading different environments with production data
• Creating and configuring High Availability Groups.

• Provided 24X7 support to the company production Server environment which includes over 100 servers in three different regions and thousands of databases
• Review procedures in database management system manuals for making changes to database
• Select and enter codes to monitor database performance and to create production database
• Developed, tested and deployed PowerShell scripts to automate the installation of patches, deployments, etc.
• Created PowerShell applications to assist server admins with daily task such as log size monitoring, last rebooted date, backup creation, etc
• Configured, tested and deployed SQL Server transactional replication
• Install, maintain and troubleshoot SQL Server 2016 clustered environments
• Participated in weekend deployments, upgrades and supported maintenance windows, when on call
• Power BI reporting Tool to extract data from production environment
• Installing new applications as needed
• Schedule and perform regular server maintenance
• Execute monthly compliance installation of patches to SQL servers
• Design DB infrastructure (planning disk space and location of data and log files)
• Perform problem assessment, resolution, and documentation in existing ETL packages, mapping and workflows in production using SSIS.