Brett Reed Email & Phone Number

Southlake, Tx, Us

Southlake, Texas

● Automating and maximize database performance and efficiency for each individual environment ● Streamline compute processing and disk I/O within Azure saving client over $156,000 a year ● Reduce overall footprint for CPU, licensing, and hosting costs ● Average CPU cost savings for clients is over 50% ● Machine learning of expert query tuning, indexing to ensure optimal database performance ● Enhanced overall system/database security by building Azure DevOps Repositories/Pipelines for securing and deploying source code and scheduled password rotation● Automation routine tasks such as backups, patching, and maintenance plans ● Automated table partitioning ● Data and Log file I/O optimization ● Curb outages and amplifying high availability while trimming it budgets (FinOps) ● Correct or optimize server configurations to optimize MSSQL database performance ● Build and maintain PowerBI dashboards in order to identify key performance metrics for business-critical databases ● Audit multi-cloud environments (AWS, Azure) to identify overspending and optimize resource allocation● Performed regular database audits to ensure compliance with internal and external regulations● Collaborated with finance teams to forecast cloud spend and allocate budgets based on usage trends● Review server configuration and address misaligned configurations with industry best practices and targeted workloads● Provide and implement solutions for long-running, high CPU usage, and resource-intensive queries ● Review SQL Server wait statistics to identify bottlenecks and resource contention ● Analyze disk I/O performance to identify any latency issues and implement workable solutions to address ● Implement automated sliding partitioning for large tables to improve query performance and automate maintenance tasks ● Identify and address blocking or deadlock issues● Implement additional alerting for all aspects of server/database availability

United States

● Production performance audit● Audit database schema, indexes, stored procedures and queries in order to optimize the environments● Review server configuration and address misaligned configurations with industry best practices and targeted workloads● Provide and implement solutions for long-running, high CPU usage, and resource-intensive queries

Coppell, Texas, United States

● Eliminated database production outages for entire engagement ● Optimized databases exceeding 2TB using triage/troubleshooting strategies to enhance performance● Established roadmap, policies, & procedures for development team to use Microsoft Azure SQL Databases● Interviewed candidates for full-time DBA

Southlake, Texas, United States

● Engineered database modeling and schema design and then implemented automated code deployment for 182 tables and over 800 stored procedures, within AWS Codebase using agile methodologies, driving operational efficiency and business growth● Spearheaded strategic technology alignment with business objectives, overseeing Node.js and React.js platform development to improve user experience and time-to-market● Leveraged SQL Server knowledge to ensure 24/7 production stability, employing High Availability (HA) and Disaster Recovery (DR) features, replication, and performance enhancements● Engineered AWS-rooted infrastructure for VPCs, subnets, security groups, EC2 instances, backup and recovery, IAM, CodeCommit, bolstering security and scaling capabilities

Fort Worth, Texas, United States

● Boosted insurance agency sales revenue by 14% by devising an automated sales intelligence pipeline, aligning insurance agent lead processing with national sales techniques● Increased client retainment by 5% by pioneering standardized ETL processes using SFTP, Python, Lambda, and S3 for data processing 30+ insurance carrier files, enhancing client retention by identifying canceled plans and payment gaps ● Lead AWS-optimized database management, implementing DBAOAI managed services for AWS MSSQL instances, ensuring real-time monitoring, error alerts, and security ● Optimized databases exceeding 1TB using triage/troubleshooting strategies to enhance performance● Implemented Domain and Active Directory to secure environment● Windows/Linux/Meraki System administrator● Managed and guided development team

Coppell, Texas, United States

● Production performance audit and optimized 2 core databases 22TB and 25TB in size● Enhanced server and database output by curbing outages and reduced CPU consumption by 25%● Hired to eliminate database production outages and delivered on requirements

Fort Worth, Texas, United States

● Spearheaded a DBAoAI.com production performance audit and optimized a core database over 1TB● Reduced database CPU usage on core database server by 20%● Automated ETL process using SFTP, Python, Linux Shell, TSQL to parse XML files against MSSQL database records and to move/match recordings files to S3 ● Created PowerBI dashboards for the CEO to provide further details on sales team performance

Coppell, Tx

● Drove a 20% reduction in database CPU usage on core database server ● Saved over $100,000 in MSSQL licensing fees by consolidating and correcting licenses and migrating/updating SQL Server instances● Implemented on-site Always on Availability groups, SSRS and PowerBI Reporting Services● Created automated rolling partitioned for tables in excess of 2 billion records and 120GB● Outlined and implemented VMWARE best practices for SQL Server in order to increase disk performance● Designed and implemented RBAC standards for Activity Directory● Automated SQL Server installations and patching for SQL Server using Azure DevOps and PowerShell

● Drove success as the main point of contact for solving issues by orchestrating performance enhancement across 165 production clusters with 5,100+ MSSQL databases and boosting overall efficiency● Automated MongoDB deployment on Docker containers for 60+ instances, allowing seamless sharding, replication, encryption, and LDAP integration● Managed offshore team members, fostering skill development and growth within the team offshore team members, fostering skill development and growth within the team● Documented best practices and created naming standards for team● Created, scheduled, and managed change control tickets for team to address off hours● Engineered data repository for network communication, SQL Monitoring, system-wide Windows registry reporting, and disk space management via PowerShell for custom alerting on database critical resources● Led 18 projects involving multi-node clustering, system migrations, TDE encryption, Always On, and data replication, collaborating cross-functionally to achieve successful completion● Supported MSSQL, Sybase, DB2/ and Oracle● Championed a 2TB data center conversion/migration from Sybase to MSSQL