Sql Server Management
Resume:
BARRY LANDON
*****.******@*******.***
Dunwoody, Georgia 30350
SKILLS
Operating Systems: Windows 2000/2003/2008/2008 R2/2012/2012 R2 – Implementation, Administration, Development, Windows cluster, Backup\Restore, IIS6/IIS7/IIS8
Database: SQL Server 2000/2005/2008/2012 – Reporting Services, Integration Services, Implementation, Administration, Development (SQL queries, user-defined functions, triggers, views, stored procedures), Performance Monitoring\Analysis, SQL Server Cluster, Log Shipping, Database Mirroring, Backup\Restore
Programming languages: C#, VB.Net, XML, JavaScript Libraries (jQuery, Bootstrap, AngularJS, BackboneJS), T-SQL, PowerShell
Web Technologies: IIS6/IIS7/IIS8, ASP.Net MVC, HTML5, CSS3, XML, Web Services, JSON
.Net Framework 1.0, 1.1, 2.0, 3.5, 4.0, MVC2, MVC3, MVC4, MVC5, Entity Framework, ASP.Net Core
EXPERIENCE
Hewlett-Packard Enterprise, Alpharetta, Georgia – January 2010-Current
Senior SQL Server DBA (Lead)
Lead DBA for 6-person, international group maintaining 25+ database instances, 600+ individual databases.
Database performance specialist with regard to operation of 20+ IIS6/IIS7/IIS8 web servers
Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
Performance tuning and optimization using SQL Profiler and SQLDiag
Scheduled and executed SSIS Packages and Maintenance Plans using SQL Server Agent.
Created SQL Server Log Shipping plans and tested DR fail over process
Designed and developed SQL Server performance dashboard using SQL Server Reporting Services.
Thorough knowledge of Microsoft web technologies (IIS6/IIS7/IIS8, Active Server Pages, ASP.Net, web forms, web services, Web API, MVC, Entity Framework).
Designed and developed website monitoring application using ASP.Net MVC3, jQuery and HTML5. This application provides real-time up\down information on critical Production websites, which had not been previously available.
Designed and developed Server Naming and Provisioning (SNAP) tool using ASP.Net MVC3, jQuery and HTML5. SNAP is used by customer support team when creating new servers. SNAP helps ensure that no 2 servers share the same name\IP address. Over 1600 servers have been entered using this tool.
Upgraded Redirect Website (mentioned below) to ASP.Net 4.0. This site, which is still in use, allows our customer to register and redirect “vanity URLs”. Over 1200 URLs are currently managed by this site, with over 10 million hits to date.
Successfully migrated revenue generating websites and databases as part of OS upgrade project
Worked closely with developers and web site owners to provide DevOps-style collaboration.
Hewlett-Packard, Alpharetta, Georgia – May 2008-January 2010
SQL Server DBA/IIS Administrator – Syngenta\Jabil Accounts
Member of 6 person, international group maintaining 16 database instances, 600+ individual databases.
Day-to-day operation, management and performance of 6 IIS6/IIS7 web servers
As part of customer consolidation project, developed and implemented plan to migrate 300+ websites and 250+ databases from Alpharetta data center to data centers in Grenoble and L'Isle-d'Abeau, France
Worked closely with web site owners to provide DevOps-style collaboration with developers in 20 countries (customer consolidation project reduced number of development teams.)
Hewlett-Packard, Alpharetta, Georgia – December 2005-May 2008
SQL Server DBA/IIS Administrator – Syngenta Account
Day-to-day operation, management and performance of 6 database instances, 300+ databases.
Day-to-day operation, management and performance of 6 IIS6/IIS7 web servers
Developed and implemented plan to migrate 60+ IIS6 websites to IIS7.
Upgraded Redirect Website (mentioned below) to ASP.Net 1.1.
Worked closely with web site owners to provide DevOps-style collaboration with developers in 40 countries
Hewlett-Packard, Alpharetta, Georgia – June 2002-December 2005
SQL Server DBA/IIS Administrator – Syngenta Account
Day-to-day operation, management and performance of 6 database instances, 300+ databases.
Day-to-day operation, management and performance of 6 IIS6 web servers
Designed and developed Redirect Website in Active Server Pages (ASP). At the time it was taking our support staff 2+ hrs to build redirected websites. This site reduced that effort to <10 minutes.
ACTIVITIES\INTERESTS
Fitness, Golf, Darts, Physical Fitness, Spartan Races
Contact this candidate