Database Architect and 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 2016, Query Plan, Amazon S3 (AWS S3), Microsoft SQL Server, Looker, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), SQL DML, Data Queries, SQL Performance, Performance TuningCIO
2016 - PRESENTFORT Systems- Oversaw company security, including firewalls, WAFs, and external firms.
- Handled IT Infrastructure, both internal and cloud.
- Interfaced with vendors, resources, developers, and internal staff.
- Managed IT and infrastructure projects for the entire company.
Technologies: IT Management, IT Project Management, Google Cloud Platform (GCP), Amazon Web Services (AWS), HerokuDatabase Administrator, Application Developer, and 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 portfolio management and trading applications.
Technologies: Delphi, .NET, T-SQL (Transact-SQL), SQL Server 2012, Query Plan, SQL Server Integration Services (SSIS), SolarWinds, Unit Testing, Microsoft SQL Server, Looker, SQL Server Reporting Services (SSRS), Dashboards, SQL DML, Data Queries, SQL Performance, Performance TuningDatabase Administrator, Website Developer, and 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 2017, Query Plan, SQL Server Integration Services (SSIS), Microsoft SQL Server, Looker, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), SQL DML, Data Queries, SQL Performance, Performance TuningSenior Database Administrator, Architect, and 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 (Transact-SQL), SQL, SQL Server 2016, SolarWindsPostgreSQL 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