Papy Songo

Mssql Database Administrator @Morgan Stanley

NY, US

Optimize T-SQL queries & automate DBA processes to enhance database performance by 15%, reducing query execution time.• Implement SQL Server Reporting Services (SSRS) to deliver comprehensive data analysis & reporting, boosting business intelligence by 35%.• Configure High Availability Disaster Recovery (HA/DR) solutions, including Log Shipping, Transactional Replication, & Always on Availability Groups, ensuring 99.9% uptime.• Perform regular Database Consistency Checks (DBCC) to maintain database integrity, reducing corruption incidents by 20%.• Automate maintenance plans to rebuild/reorganize indexes, update statistics, & perform cleanup tasks, increasing workflow efficiency by 30%.• Support ETL processes & deploy SSIS projects to enable seamless data migration & transformation across environments.• Collaborate with Azure Virtual Machines (VMs) for on-demand resource utilization & seamless migrations, reducing deployment time by 40%.• Utilize SQL Server native tools (SSMS, Query Store) & DMVs for performance analysis to identify and resolve bottlenecks, achieving a 25% improvement.• Resolve user-requested tickets by executing DML/DDL scripts in QA & Production environments, maintaining a 99% SLA compliance rate.• Create & Manage database components, including Stored Procedures, Tables, Views, Functions, Triggers, & Indexes, to enhance query performance.• Deploy Windows Failover Clustering to ensure high availability & system resiliency, minimizing unplanned downtime by 15%.• Implement backup & recovery models using tools like SQL Server Rubrik, ensuring data integrity & enabling recovery within <30 minutes.• Manage SQL Server instances on Hyper-V & VMware, optimizing virtualized environments for 30% better resource utilization.• Design & deliver interactive dashboards using Power BI & Tableau to provide actionable insights for critical business decisions.