Senior Director Of Database Technologies
Current• Responsible for data architecture for our online gaming and horse racing wagering platform: registration, funding and on-line wallet, transaction repository, VIP loyalty program, marketing campaign rules engine, back-office, handicapping and e-commerce pieces.• Manage several dozen clusters across multiple development, load-testing and production environments. In production these clusters auto-scale according to traffic.• Design mechanisms to enable integration among data modules and third-party content and function providers.• Enforce architectural guidelines and supervise DB implementation efforts by multiple development teams across Lexington and Louisville locations.• Responsible for researching and mapping out technology choices after seeing through successful multi-terabyte migration from on-prem Oracle MySQL clusters to AWS: we use a combination of Aurora for MySQL and PostgreSQL, DynamoDB with some RDS MySQL, we also implemented some database-adjacent services: lambda functions, DMS, RDS proxy; as well as extensive AWS/CLI scripting• Lead and supervise our TSDBA (Twinspires DBA) team comprised of database resources embedded across various development teams and reporting to me. My role is at the intersection of technical and managerial capacities: recruitment, performance reviews, mentoring and training.• Maintain a knowledge base to document growing complexity of our platform, as well as architectural diagrams and papers.• Coordinate and organize deployments and progression of changes through environments. • Database code optimization through a variety of approaches: indexation, query re-writing and MySQL settings tune-up upon analysis of a query optimizer trace and cost analysis.• Design and implement data partitioning and archival strategy, database object permission model and backup/disaster recovery strategy.