Doug Ledbetter Email & Phone Number

Kansas City, Mo, Us

Kansas City, Mo, Us

London, Gb

Cincinnati, Ohio, Us

Responsibilities include:• Install, configure, monitor, and maintain SQL Server 2012, 2014, 2016, 2017, and 2019 for production and dev/test environments• Perform database security audit and work with the Security team to move individual logins into Active Directory groups and ensure Least Privilege• Audit SQL Server instances for configuration best practices• Investigate performance issues and optimize T-SQL and/or adjust indexes based on execution plan analysis• Create automation as necessary to improve the data estate. For example: database maintenance (indexes, statistics, CHECKDB)• Responsible for ensuring backups are valid• Handle typical daily DBA requests (e.g., access permissions, disk space, adjusting configurations, etc.)• Automatically collect multiple data series for analysis (e.g., projecting database growth over time, etc.) using SQL Agent jobs• Assist in the migration of production data & configuration from SQL Server 2012 & 2014 to version 2017• Create policies and practices to ensure consistency• Create database documentation for othersTechnologies used: MS SQL Server (2012, 2014, 2016, 2017, & 2019), PowerShell, SSIS, SQL/T-SQL queries, stored proceduresSkills used: Full range of production and dev/test DBA work. Worked to build relationships with other teams in IT (e.g., developers, etc.).

Lenexa, Kansas, Us

Lenexa, Kansas, Us

• Installed, configured, monitored, and maintained SQL Server 2012 and 2016 for production and dev/test environments• Utilized Always on Availability Groups with a geographically dispersed three node configuration (HA/DR)• Investigate performance issues and optimized T-SQL and/or adjusted indexes based on execution plan analysis• Configured automated database maintenance (indexes, statistics, CHECKDB, set appropriate recovery mode)• Responsible for managing backups and ensuring they were valid• Responsible for managing monitoring tool (Quest Spotlight) by making adjustments to alarm thresholds, upgrades, etc.• Active on multiple Agile teams as the database expert to provide database architecture advice for high performing solutions• Handled typical daily DBA requests (e.g., access permissions, disk space, adjusting configurations, etc.)• Automatically collected multiple data series for analysis (e.g., projecting database growth over time, etc.) using SQL Agent jobs• Involved in the migration of production data & configuration from SQL Server 2012 to version 2016• Created documentation for the DBA team and others• Created reports using SSRS and SQL Agent jobs• Responsible for ensuring RPO and RTO• Some experience with the database products available in MS Azure• Active on multiple Agile teams as the database expert to provide database architecture advice for high performing solutions.Technologies used: MS SQL Server (2012, 2016), PowerShell, Microsoft Dynamics AX 2012 R3, SSRS, SQL/T-SQL queries, stored procedures, Windows server administration, some MySQLSkills used: Full range of production and dev/test DBA work in addition to my team lead responsibilities: approve PTO requests, created tasks for the team, lead team meetings, participated in IT leadership meetings, performed yearly performance evaluations for team members, etc.. Worked to build relationships with other teams in IT.

Kansas City, Mo, Us

Designed developed, tested, implemented and maintained optimal data infrastructure and SQL Server solutions that addressed business needs Responsibilities:- Regular database maintenance (integrity check, index optimization & statisticsupdates, backups, etc.)- Application administrator (IBM Cognos, Deltek Costpoint, Deltek Vision)- Perform SQL Server upgrades to stay within MS maintenanceTechnologies used: MS SQL Server (2005, 2008 R2, 2012, 2016), SSRS, SQL/T-SQL queries, stored procedures & functions, Windows Server administration. Skills used: Worked both independently and on a team to solve problems, create documentation, generate reports, secure systems manage & upgrade applications and test products. Optimize T-SQL queries, stored procedures & functions.

Kansas City, Missouri, Us

Responsibilities: - Designed developed, tested, implemented and maintained optimal data infrastructure and SQL Server solutions that addressed business needs- Estimated the size of the effort required to complete complex enterprise wide database solutions- Reviewed requirements for multiple projects and ensured that database solutions were consistent and fell within the defined standards of the organization - Coordinated production implementation efforts with user community and communicated implementation time lines and tasks- Provided advice on design, applicability, commonality, and usability of SQL database solutions across the business- Regularly and independently interacted with business partners of varying associate/management levels to ensure clarity of the problem/opportunity and business, data and functional requirements that addressed the business needs- Established version control of all database objects and established coding standards for team. Provided documentation for existing and new projects.- Established standards for SSIS packages whereby they retrieved configuration data from an SQL Server database.- Created new SSRS report for senior management to evaluate classroom student-to-leader ratios. Loaded data from various sources with SSIS and created stored procedures that fed the data to the SSRS reportTechnologies used:- MS SQL Server 2008 R2 & 2014- SSIS- SSRS- SSMS- SQL/T-SQL Queries (stored procedures, functions, ad hoc queries)- Visual SourceSafe- Visual Studio- TFSSkills used:Worked both independently and on a team to support management with data reports and solutions to solve complex problems, create documentation & procedures, team leadership, data cleansing, secure systems, test products & report/fix bugs. Responsible for multiple areas including: SQL Server performance monitoring, T-SQL Development, Report Development, ETL using SSIS, Planning Upgrades and maintaining data system stability.

Louisville, Co, Us

Worked on marketing database projects for Alcon/CIBA Vision/Novartis, Bayer Animal Health, Clorox, DuPont Pioneer, Government Employees Health Association (GEHA), H&R Block, Invisalign, Michelin, Moen, T-Mobile and others. Performed support, troubleshooting, maintenance and updates to these projects in a MS SQL Server 2005 environment. Wrote and modified existing T-SQL (stored procedures/functions, reports, data manipulation, etc.). Supported Moen email campaigns for both trade (25k emails) and consumer (800k emails) market segments. Administrated the applications that handled data ETL processes for these clients and others.Worked directly with Dell during the requirements specification, implementation, deployment and maintenance of several data and email marketing tools. Managed Dell email promotions in-house on hybrid Linux & Windows platform, sending marketing materials out to 92k email addresses on a monthly basis. Reduced the processing time for these email campaigns from three days to three hours. Monitored and administered two Linux and six Windows Server 2003 systems all dedicated to Dell e-marketing efforts. Provided program support directly to Dell stakeholders and participated in weekly status conference calls with Dell. In addition, traveled to multiple locations for on-site planning and application transition purposes. Administrated the applications that handled online loyalty programs for multiple groups within Dell. Analyzed technical processes and provided written documentation for existing systems. Provided functional/technical specifications for project proposals.Technologies used: MS SQL Server 2005, MySQL Server Administration, SQL/T-SQL Queries (stored procedures, functions, ad hoc queries), Visual Studio 2008, Team Foundation Server (TFS), Linux (Red Hat), Apache, MySQL, PHP, Perl, Windows Server 2003 Administration, Exim, IIS, DNS, SSL, HTML, JavaScript, CSS, DreamWeaver, Photoshop, Adobe Acrobat

Placed at DATACORE Marketing, LLC to assist with several data and email marketing projects for Dell in a Linux, Apache, MySQL, PHP (LAMP) environment. After the consulting period, Doug was hired full-time by DATACORE Marketing. Note that Doug was hired to work in the LAMP (Linux, Apache, MySQL, PHP/Perl) environment and did so for about 1.5 years but was then asked to move over to the Microsoft environment due to changing priorities within DATACORE Marketing. Doug made the transition and learned the new technologies quickly. He was contributing in the Microsoft environment within a very short time (see KBM Group experience above for greater detail).Technologies used: Linux, Apache, MySQL, PHP, Perl, MS SQL Server 2005, SQL/T-SQL queries, Windows Server 2003, Exim, IIS, DNS, SSL, HTML, JavaScript, CSSSkills used: Worked both independently and on a team to solve problems, create documentation, generate reports, do data cleansing, support products, secure systems, test products & report bugs.

Had significant responsibilities and multiple roles to perform due to the small size of the company. Provided project planning, technical specification, development, implementation, testing and operational support for new products: web hosting service, custom billing management system, etc. Managed and worked with a junior developer during part of this period. Administered multiple Linux systems with approximately 1,500 customers. Worked with customers on custom programming projects and provided estimates. Provided advanced product support for multiple web applications. Cut costs by utilizing open source, free or in-house custom built software.Technologies used: Linux, Apache, MySQL, Perl, CPAN, PHP, SQL queries, DNS, SSL, CGI, HTML, JavaScript, CSS, DreamWeaverSkills used: Management of subordinate, written communications, problem resolution, advanced product support, entire software development cycle, report generation, system security, product testing & bug reporting.

Olathe, Kansas, Us

Completed successful redesign of entire web site. Incorporated dynamic, database-driven content into the university site. Employed creative measures to encourage return traffic to site. Provided web analytic reporting. Managed junior programmer and an assistant. Worked within a very tight budget by taking advantage of open source, free or in-house custom built software.Technologies used: HTML, JavaScript, Linux, Apache, Perl, MySQL, server administration, Photoshop, DreamWeaverSkills used: Management of two subordinates (one programmer), budgeting, scheduling & planning development projects, entire software development cycle, working with customers to determine specifications, web design, programming, web activity reporting.

Olathe, Kansas, Us

Instrumental in connecting the university to the Internet. Established web presence and managed Internet email services. Supported faculty, staff and students with technology. Improved technical education to students, faculty and staff. Supported dial-up Internet service provided to faculty, staff and students.Technologies used: Windows 3.x, 95, 98, ME, Mac System 7, Mac OS 8, VAX VMS, Linux, HTML, JavaScript, Perl, MySQL, server administration, PhotoshopSkills used: Desktop computer troubleshooting (PC & Mac), verbal and written communications, web design and development, programming.

Ms-10961 Automating Administration With Windows Powershell

Bachelor Of Arts, Computer Science