Jeffrey Langdon Email & Phone Number

16 years experience in database administration, architecture, and support in Microsoft SQL Server Versions (2000 - 2022) . Database Architect Skills: Database Design, Data Maintenance, Database Security, Database Management, Requirements Analysis, Project Management, and Presenting Technical Information.Architected SQL Server Windows Server Failover Clusters with Always On Availability Groups on-premises, Azure Managed Instances and Azure SQL Databases. Experience in Performance Tuning, Query Optimization, using Query Store, Wait Stat DMVs, Server Side Traces, and other related monitoring and troubleshooting tools.Ensure all database servers meet Service Level Agreement (SLA) Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).24 years experience developing and troubleshooting Transact-SQL Code. Proficiency in designing SSIS packages and SSRS reports.Developed PowerShell scripts to implement monitoring and maintenance automation on Windows and SQL Server servers. Proficiency in developing scripts importing the DBATools module.Configured and administered SQL Server monitoring utilities (Solarwinds Orion, Solarwinds Database Performance Analyzer, and Solarwinds SQL Sentry).Configured and administered Redgate SQL Toolbelt Essentials.Configured and administered Microsoft Team Foundation Server.16

Developed and administered all SQL Server instances and databases. Developed SQL queries, stored procedures, functions, views, and many other database objects. Optimized and performance tuned SQL Server databases and queries to improve application response times. Expert knowledge of the software development life cycle. Collaborated with project managers to identify requirements, design prototypes, and develop database models. Created database models and diagrams using SQL Server and Microsoft Visio.Developed, designed, and maintained multi-tier web applications in the .net framework using Visual Studio.Worked with the management information system department to maintain, upgrade, and troubleshoot software, hardware, and computer-related issues. Worked extensively with production support issues.

As .Net Programmer, I developed web applications, corporate web portals, and client server Windows applications utilizing Visual Studio.Net, SharePoint Portal Server, FrontPage, and Dreamweaver. Designed and developed SQL Server databases. Developed SQL queries, stored procedures, functions, and views. Performance tuned queries to improve application response times. Worked with the management information system department to maintain, upgrade, and troubleshoot software, hardware, and computer-related issues. Worked extensively with production support issues.

Bachelor Of Science (B.S.), Technical Management

Associate Of Arts (A.A.), Liberal Arts - Business