SQL Support

Provided: Advisory and Technical Support for SQL Server Analysis Services (SSAS/AAS), Database Engine CoreFocus: Connectivity, Query Optimization ,Performance Tuning, Design Issues, Development Specialty: Discovery of Root Cause Analyses Typical Day: Debugging , Handling customer escalations and able to marshal resources to quickly and effectively address issues, Windows OS and Networking experience

Primary DBA for Analyzing and troubleshooting the day-to-day operations for 300+ SQL Instances on Microsoft SQL Servers running 2000-2017 as well as Azure. Preformed Installation, configuration, migration and lifecycle support.· Automated various daily tasks using PowerShell with Active Directory and Batch Scripts· Created and maintained install template library, then upgraded to SYSPREP installs, along with other automation with PowerShell and enhancing existing SQL scripts · Proficient with Group Policy and Active Directory Administrator· Automated server installs and configuration process went from 8 days to 4 hours since joining the team· Developed the migration process of database backups to be moved from on-premise to CLOUD· Migrated and created new system security to control user access and maintain and monitored user access to the database in compliance with PHI/PCI/PII (HIPAA)· Tested Restore, Recovery in addition to Disaster Recovery plans for Single and Clustered systems· Improved daily maintenance jobs by reducing the duration in some cases 8-12 hours to under 3 hours using self-developed as well as Ola Hallengren and Brent Ozar scripts· Monitored business-critical applications to identify on-going issues and be proactive for future Performance Tuning needs· Supervised running of long-running ETL jobs and resource-consuming SQL Queries· Worked closely with Application owners on Performance tuning recommendations to avoid future memory issues and make the necessary changes in Database like table reorg, add enough spaces to database · First-Responder to Troubleshooting with Windows Event logs, SQL Error logs, SQL Profiler

Led a team of 15 Support Agents coached and counseled agents to facilitate better quality calls based on metrics and personal feedback. The team was responsible for the day-to-day support of major area healthcare company with 10k+ users.

Developed training materials and new processes for aiding new hires which increased calls times, faster ticket turnover and avoided miss assignments of issues.

Provided end-user technical support for various inhouse applications within a newly formalized Support Center, Supporting medical professionals within the confines of HIPPA standards. Heavily focused on Microsoft operating systems and network security-related issues.