Louisville, Kentucky, United States
Experienced, well-rounded PostgreSQL administrator/developer using best practice skills in relational schema design and normalization, PL/pgSQL programming for ETL and trigger procedures, query performance tuning and optimization, and more to maintain and organize the critical data that businesses need to succeed in the analytics age.
• Team-of-1 responsibility for the management of all company data assets in PostgreSQL, both on-prem and in cloud (AWS RDS/EC2) • ERD/Schema design and planning for expansion of relational data, proprietary and purchased • Author custom ETL processes in PL/pgSQL to integrate vendor data sets • Query performance tuning, troubleshooting, and optimization assistance to predictive modeling team
Maintained, developed, and supported postgres environment and provided database support to application developers and business analysts.
Developed application for content collection, input file generation, and other needs in support of company's proprietary statistical sports models.
Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and documenting programs.