20 years experience designing, implementing and optimizing SQL and NoSQL databases for large-scale custom applications and package software.
Relational database schema design, complex query optimization, data migrations, SQL Server, MySQL, Postgres, AWS Glue, Athena, Aurora, DynamoDB, Redshift, Kinesis, Apache Spark, map reduce, MongoDB, Snowflake, ETL
- Profile the database to identify queries with poor performance or high resource utilization
- Review scheduled jobs/tasks for ineffeciencies
- Identify and implement optimizations to address the above (could be adding indexes, altering procedures to reduce locking, changing the vacuum parameters, etc)]