Chad Baldwin Email & Phone Number

Los Angeles, Ca, Us

Dallas, Tx, Us

Specialized in research and development with a focus on performance tuning for SQL Server. Designed and implemented systems for identifying and solving complex database issues through innovative proof-of-concept systems and strategic process improvements. Demonstrated ability to deliver outside-the-box solutions that enhance data management and operational effectiveness.• Developed a system to monitor millions of SQL Server indexes, enabling the identification and removal of unused indexes to optimize database performance and resource allocation. Leading to a significant reduction in superfluous write activity by removing unnecessary indexes while ensuring no performance regression.• Engineered an advanced analytics tool to evaluate physical index structures, successfully identifying and resolving issues with duplicate, overlapping, and mergeable indexes, which significantly enhanced query efficiency and storage utilization.• Designed and implemented a robust system for synchronizing and consolidating system metadata from hundreds of SQL Server instances into a central repository. This tool aids in monitoring and managing schema and configuration drift, improving consistency and control across the database environment.

Kansas City, Mo, Us

Primarily working with SQL, C# and PowerShell; improved products by working with development and product teams to engineer back-end services, build databases and design schemas. Implemented ETL processes for importing, cleansing and normalizing automotive dealership data to be processed by our proprietary calculation engine.• Collaborated with 3rd party data providers to build integrations for tasks such as SalesForce data syncing, email/address sanitization, data appends and ETL processes• Helped maintain and improve an elaborate calculation engine written in SQL to support new features and settings• Tuned existing SQL code to run faster and more efficiently reducing both runtime and resource usage through query and index tuning by analyzing execution plans, server statistics, dynamic management views (DMV's), SQL Server First Responder Kit and SentryOne Plan Explorer• Worked on many ETL projects using SQL, C#, PowerShell and batch scripting• Contributed to complex back-end services written in C# utilizing technologies such as Elasticsearch, RabbitMQ, Redis, Amazon SNS, Amazon SES, Amazon S3, Docker, Selenium web scraping, and handling files via FTP• Experience with using collaboration and CI/CD tools including Jenkins, Slack, Upsource, Jira and Confluence• Worked primarily with SQL Server versions 2008, 2012, 2014 practicing good HA/DR policies, using replication and Always On availability groups• Used AWS tools for troubleshooting, logging and deployment such as CloudWatch, CodeDeploy, and managing/monitoring servers through EC2

Kansas City, Mo, Us

As an IT Support Analyst I was responsible for quickly triaging and troubleshooting issues in client data. Worked directly with clients over the phone to assist fixing data delivery issues. Built systems and tools to automate detection of bad data quality and reduce the work needed to fix.• Worked heavily with SSRS to write custom reports for all business needs ranging from simple tablix reports to intricate reports with benchmarks, charts, and complex expressions• Established a reporting data warehouse to ensure consistent metrics across all reports

Riverside, California, Us

• Provided both remote and in person desktop and mobile support for hundreds of users• Assisted in implementing virtualization solutions including ESX(i), VMotion, VMWare• In charge of installing, configuring and managing network monitoring software for hundreds of network devices using Nagios• Eliminated the need for hiring Cisco consultants by learning to support the Cisco devices through personal research, and formal courses offered at the local college• Created custom reports for various departments needs using SQL Reporting tools (SSRS)• SharePoint Services• Support and implementation of asset management appliances (Dell KACE KBOX). Including custom scripts and remote desktop imaging.

• Helpdesk and computer repair• Managed network updates/repairs• Management of phone/VoIP system• Maintained websites/portals and other online applications

A family owned business from 1963 to 2020. Worked in the kitchen and the bar, as a cashier and a cook. Helped with business paperwork, quickbooks, building spreadsheets, and in recent years during the COVID pandemic, helped to run social media to keep business going strong with a delivery only business.