Norman G.

Sql Server Performance Tuning Engineer @Barclays Investment Bank

Refactored stored procedures, views, triggers and user defined functions for maximum performance and implementation of Microsoft best practices. • Investigated root cause of database related application errors (SQL timeouts, deadlocks, unexpected data condition etc.), provided documentation explaining root cause and recommended fixes (including recommending changes to application stored procedures) to avoid future recurrences. • Developed SQL Server stored procedures to capture historical DMV statistics to pinpoint performance issues as they relate to CPU, Memory, IO, indexes (missing, unused, redundant, duplicate, over-lapping, statistics & fragmentation), implicit conversions, table scans, RID & Key lookups