Kevin Banh

Managed 7,000+ test and production MySQL databases, processing over 2 TB of data daily Migrated 100+ MySQL databases from Windows to Linux, moving more than 20 TB of data Reduced database rebuild on-call hours by 90% by streamlining MySQL clustering processes

Database Administrator at Paycom (2024-04 – Present)

• Managed 7,000+ test and production MySQL databases, processing over 2 TB of data daily
• Migrated 100+ MySQL databases from Windows to Linux, moving more than 20 TB of data
• Reduced database rebuild on-call hours by 90% by streamlining MySQL clustering processes
• Migrated and upgraded 3 TB of data from SQL Server 2016 to SQL Server 2022 using continuous log streaming to minimize the cutover window
• Led Neo4j graph database solution from proof-of-concept to production, implementing HA clustering and DR strategies
• Built an automated Python remediation process that detects and resolves database alerts across multiple platforms
• Developed Ansible playbooks to automate MySQL and Neo4j server provisioning and configuration
• Designed and maintained MySQL and Neo4j HA/DR architectures through clustering, failover, and backup strategies
• Performed MySQL version upgrades from 8.0.32 to 8.4.6
• Managed access control for 2,000+ users across multiple database platforms including Couchbase, Neo4j, MySQL, SQL Server, and PostgreSQL
• Built performance monitoring dashboards with Prometheus and Grafana, improving incident response times and environment uptime

Data Analyst at PakEnergy (2022-03 – 2024-04)

• Built and optimized SSIS ETL pipelines, reducing weekly client data processing time by 80%
• Developed complex SQL queries using window functions, recursive CTEs, conditional logic, and advanced aggregations to transform and migrate legacy data
• Led 10+ client database implementations, designing data migration pipelines from Excel and database sources into SQL Server databases
• Led database cleanup and normalization initiatives, consolidating duplicate client records and improving data quality

BA in Mathematics – University of Oklahoma (2019-08 – 2021-12)