Provided 24x7x365 on-call support 25 production SQL servers and over 75 test servers. Responsible for troubleshooting job failures on 400 production jobs across 330 databases.Supported over 39 Billion Transactions with a 99.8% uptime in the SQL environment in 2009.Responsible for maintenance of company's main billing application, supporting over $650 million in revenue annually.Implemented SQL code library through the use of TFS (team foundation server).Created baseline performance monitoring for all SQL servers in the production environment.Scheduled/monitored maintenance activities of SQL Servers including backup/restore, database consistency checks, and index de-fragmentation.Created and maintained transactional and snapshot replication to mission critical databases.Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors. Developed, tested and optimized stored procedures, views, triggers and user defined functions. Created logical and physical database designs. Developed and supported of DTS/SSIS packages. Responsible for in-place and old to new SQL Server 2000, 2005, 2008 upgrades.Experience applying service packs through maintenance.Mentored SQL Developers, review and provide feedback on all TSQL code, release code into production. Coded/deployed solution to backup/optimize/report errors on 762 patient care centers servers.Set up maintained and monitored Sarbanes-Oxley critical data archive. Experience with several facets of ITIL (change control, incident management).Created and maintained technical documentation and policy implementation.

24x7x365 support and trouble resolution of Enterprise Production Database as well as 762 Patient Care Center SQL Server Databases. Developed and optimized database structures, stored procedures, views, triggers and user defined functions.Created a library of T-SQL scripts that could be used to address recurring problems in production systems.Pushed recurrent issues to QA team in order to generate longer term .NET or TSQL fixes for application issues.Coded reports to notify IT personnel of critical financials system information.Builds and rebuilds of databases for Patient Care Centers.