Staff Mysql Dba
CurrentPerformance tune and architect large multi-shard and high throughput MySQL databases with billions of records.Write and optimize countless data extraction queries for large and high throughput customer facing databases processing 10's of thousands of transactions per second per database.Migrated 500+ databases from Salt Lake data center to AWS us-east-1.Manage Dozens of lambda and step functions for data export and resource management.Built an internal single page application to assist with data sharing for resource management.Managed patching and engine upgrades from MySQL 5.5 to Percona Server 5.6. Built out monitoring and backup management platform.Championed standardized monitoring tools in order to use data to demonstrate performance.Mentor colleagues on query building and proper data access architecture.Perform audits of data security for sensitive genomic and PCI data.Architect and build secure minimum viable access policies using AWS IAM.Manage data exports to and retrieval from S3 using tools like Glue and Athena.