Virginia Guarneri

Configuring Gomocha FPS software solutions and ensuring they meet client specifcations. Training end-users on software capabilities and best prac tices. Addressing compatibility and system integration issues. Guiding clients through the onboarding journey for products or services. Ensuring clients understand the value of the service or product. Providing tips for best practices and ensuring clients reach initial success milestones.

Designed Indexing Strategies: Optimized query performance by creating and maintaining effcient indexing structures, including clustered, non-clus tered, and fltered indexes, while eliminating unused or redundant ones. Im plemented Partitioning Solutions: Enhanced data management and query performance by applying table and index partitioning strategies to han dle large datasets effectively. Maintained Indexes: Regularly analyzed and rebuilt fragmented indexes or reorganized them to sustain optimal query performance and reduce resource usage. Tuned Query Performance: Moni tored and refned query execution plans to ensure effcient data retrieval by leveraging indexing and partitioning. Automated Monitoring and Mainte nance: Used SQL Server tools and scripts to monitor performance, identify bottlenecks, and automate index and partition maintenance tasks.

Optimized Database Structures: Supported the DBA team by ensuring databases were structured effciently to meet current and future business requirements, monitoring and improving backup, recovery, data manage ment, performance, and re-indexing processes. Automated Database Ad ministration: Performed SQL Server DBMS administration and implement ed automation solutions using Python, PowerShell, and Ansible (AWX), in cluding logical and physical database design, table space management, in stance tuning, and resolving CMDB inconsistencies. Delivered Business In sights: Developed and maintained Power BI dashboards to provide action able insights into business KPIs, highlighting current and historical CMDB discrepancies and enabling data-driven decisionmaking. Ensured System Reliability: Monitored database environments to identify performance bot tlenecks, implemented tuning strategies, and collaborated with teams to proactively address system challenges and improve overall reliability.