Database Architect, Developer
2019 - PRESENTReliable IT- Developed a web-scraping tool using Python.
- Supported scraping data both from standard web pages and containing download links to zip files.
- Used Python to download zip files, extract CSV files from them and read the data.
- Used T-SQL to retrieve scraped data and insert it into the database.
- Created a scheduled job to run routine hourly, and retrieve any new data.
Technologies: Python, SQL Server 2017, T-SQLDatabase Architect, Developer
2019 - PRESENTGlobalscape- Updated, and optimized an intelligent file transfer application with a SQL database back end.
- Used a variety of tools, and techniques to make routines run more quickly, and efficiently.
- Created reporting tables to increase reports by up to 80%.
- Scripted nightly tasks to summarize the daily information for a quicker output.
Technologies: SQL Server 2016Database DBA, Application Developer, Project Manager
2015 - PRESENTSSI Investment Management- Managed and administered multiple SQL Server instances.
- Managed and updated the company website, including the database back end.
- Oversaw the development of the portfolio management, and trading applications.
Technologies: Delphi, .NET, T-SQL, SQL Server 2012Database DBA, Website Developer, App Developer
2015 - PRESENTPreferred Convention Services, Inc.- Designed, and created the database schema.
- Oversaw the database administration.
- Developed a web application using .NET.
- Designed, and developed the website.
Technologies: Visual Studio, .NET, SQL Server 2017Senior Database Administrator, Architect, Developer
2008 - PRESENTFORT Systems- Designed, and created the database schema.
- Oversaw the monitoring, upgrades, security, backups, and archiving for the database.
- Developed the database with a focus on queries, stored procedures, views, and performance optimization.
Technologies: T-SQL, SQL, SQL Server 2016PostgreSQL Architect, and Developer
2019 - 2019MyFitment- Optimized a very large database.
- Added missing indexes, optimized queries, and suggested schema changes.
- Improved the platform configuration to allow the database to run more optimally.
Technologies: Heroku, pgAdmin, PostgreSQL