Technical Analyst
- Utilized SQL Server Analysis Services (SSAS) for multidimensional data analysis and worked with Cube technology (tabular models, dimensions) to monitor ETL processes from data extraction to cube availability, ensuring smooth data flow and identifying process bottlenecks.
- Analyzed delays in the ETL workflow, providing insights and recommendations that enhanced process efficiency and improved forecasting capabilities.
- Developed and maintained comprehensive ETL documentation, including workflows, procedures, and performance metrics, ensuring consistent knowledge transfer and optimized process execution.
- Used MS SQL for querying and analyzing SLA availability and runtime increase to support critical decision-making.
- Managed failover clusters, handling active nodes and performing failovers to ensure high availability and minimize downtime.
- Monitored system performance and SQL performance using SolarWinds SQL Sentry, proactively identifying performance issues and optimizing the ETL process and overall system efficiency.
- Provided production support by troubleshooting and resolving technical issues, significantly reducing system downtime and improving user experience.
- Involved in OS and SQL patching activities on all Data Warehouse (DWH) servers, ensuring system stability and security