Summary
Overview
Work History
Education
Areas of Expertise
Timeline
Generic

Chaddrick Palmer

Deerfield Beach

Summary

SQL Database Administrator with 5+ years of experience in installing, configuring, and maintaining SQL Server environments across cloud and on-premises infrastructures. Proven expertise in performance tuning, stored procedures, indexing strategies, and high availability design. Adept at architecting end-to-end BI solutions from scratch—designing schemas, integrating ETL pipelines, normalizing and cleansing enterprise datasets, and linking to Power BI for dynamic reporting. Experienced in leveraging Databricks for data engineering workflows, automation, and AI-driven analytics. Committed to delivering scalable, high-performance database systems that optimize business data flow and support mission-critical operations.

Overview

7
7
years of professional experience

Work History

Senior SQL Server DBA

MDHealthBilling
11.2023 - Current
  • Installed, configured, and maintained SQL Server environments for production and development use.
  • Built an end-to-end Business Intelligence solution from scratch: architected schema, designed Data Warehouse, and implemented ETL flows to support business reporting.
  • Developed automated ETL pipelines and data workflows using Databricks, improving transformation efficiency and supporting BI dashboards in Power BI.
  • Performed advanced data preparation—normalizing, deduplicating, and cleansing large datasets to ensure consistency and accuracy.
  • Integrated Power BI with the data model to deliver interactive dashboards and analytics for business stakeholders.
  • Migrated the BI solution from development to production (Express) environment ensuring minimal disruption and optimal performance.
  • Developed and optimized complex stored procedures, queries, and indexing strategies to reduce execution time and boost performance.
  • Leveraged AI tools (ChatGPT) for scripting assistance, SQL troubleshooting, and process automation—enhancing DBA productivity.
  • Automated maintenance tasks using T-SQL and PowerShell, including index management and backup strategies.
  • Participated in disaster recovery planning and implemented security measures like TDE and Always Encrypted.

Lead DBA Cloud Engineer

StartsWithABC
04.2020 - 08.2023
  • Deployed and managed SQL Server workloads on Azure and AWS, including IaaS and PaaS environments.
  • Executed PITR backups and recovery for critical systems; implemented Always On Availability Groups and Transactional-replication for HA/DR.
  • Built and maintained ETL pipelines using Azure Data Factory for real-time and batch data processing.
  • Created secured environments using RBAC, AAD, and Dynamic Data Masking.
  • Monitored and tuned performance using SQL Profiler, Query Store, and third-party tools.

SQL Server Developer

Everest
03.2018 - 02.2020
  • Led team of DBAs managing high-performance OLTP and OLAP environments.
  • Configured and tested HA/DR solutions including Log Shipping and Failover Clustering.
  • Conducted large-scale database migrations to Azure SQL and AWS RDS with minimal downtime.
  • Managed VLDBs, designed Data Warehouses using Snowflake and Star Schema, and ensured ETL integrity with SSIS.

Education

SQL Server & Azure Cloud Architecture Mentoring
Onsite, Ft Lauderdale

SQL Server Internals Development Workshop
Onsite, Ft Lauderdale

AZ104 Azure Administrator Certification Training
Microsoft Virtual Academy

DP300 Azure DB Admin Certification Training
Microsoft Virtual Academy

Advanced Automated Administration With PowerShell
Skillsoft Global Knowledge Virtual Training

High Availability And Disaster Recovery Strategies
SQLSkills

Performance Tuning And Optimization For SQL Server
Pluralsight

Data Modeling And Schema Design in SQL Server
DataCamp

Implementing And Managing Azure Databricks
Microsoft Learn

Building Reports With SSRS
Udemy

Database Security And Auditing
SQLSkills

SSAS Multinational Models
Virtual Training

Designing BI Solutions With Microsoft Sql Server
Coursera

Areas of Expertise

SQL Installations • SQL Server • Query Optimization • Performance Tuning • Stored Procedures & Indexes • Database Maintenance • ETL Flows • Data Normalization & Cleansing • BI Architecture • Power BI Integration • Azure SQL • SSIS/SSAS/SSRS • ChatGPT & AI Tools • Dev/Test to Prod Migrations • Cloud Database Platforms • High Availability & Disaster Recovery • Data Warehousing • Data Modeling • T-SQL • PowerShell Automation

Timeline

Senior SQL Server DBA

MDHealthBilling
11.2023 - Current

Lead DBA Cloud Engineer

StartsWithABC
04.2020 - 08.2023

SQL Server Developer

Everest
03.2018 - 02.2020

SQL Server & Azure Cloud Architecture Mentoring

SQL Server Internals Development Workshop

AZ104 Azure Administrator Certification Training

DP300 Azure DB Admin Certification Training

Advanced Automated Administration With PowerShell

High Availability And Disaster Recovery Strategies

Performance Tuning And Optimization For SQL Server

Data Modeling And Schema Design in SQL Server

Implementing And Managing Azure Databricks

Building Reports With SSRS

Database Security And Auditing

SSAS Multinational Models

Designing BI Solutions With Microsoft Sql Server
Chaddrick Palmer