Database 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: SQL Server 2012, T-SQL, .NET, DelphiDatabase 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: SQL Server 2017, .NET, Visual StudioSenior 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: SQL Server 2016, SQL Studio, T-SQLPostgreSQL 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: PostgreSQL 11.2, pgAdmin, Heroku
Neal Barnett
Software Developer in Los Gatos, CA, United States
Member since March 28, 2019
Neal is a senior consultant and database expert who brings a wealth of knowledge and over two decades of experience to the table. He is well versed in security, performance optimization, upgrades, platform configuration, and schema changes, and he has touched every aspect of database handling, from architecture and hands-on development to project management.
Neal is now available for hire
Portfolio
- GlobalscapeSQL Server 2016
- SSI Investment ManagementSQL Server 2012, T-SQL, .NET, Delphi
- Preferred Convention Services, Inc.SQL Server 2017, .NET, Visual Studio
Experience
- SQL, 20 years
- Database Administration (DBA), 15 years
- Windows Server, 12 years
- Linux, 9 years
- MySQL, 7 years
- Agile, 7 years
- PostgreSQL, 6 years
Availability
Part-time
Preferred Environment
MS SQL, Windows, Linux, Azure, AWS, pgAdmin.
The most amazing...
...database project I've worked on was one which enabled legal wine-shipping throughout the US.
Employment
Skills
Languages
SQL, T-SQL, HTML, CSS, ColdFusion, Delphi, C#, JavaScript, PythonTools
Adobe CQ, Tableau, Microsoft Power BI, Jira, GitHubPlatforms
Windows Server, WordPress, Joomla, Heroku, Linux, AzureStorage
PostgreSQL, MySQL, Database Administration (DBA), SQL CLROther
Project Management, CI/CD Engineer, Machine Learning, International AffairsFrameworks
Genesis Framework, .NET, Ruby on Rails 5Paradigms
Agile, DevOps, Continuous Delivery (CD), Continuous Integration (CI)Libraries/APIs
jQuery
Education
- Masters's degree in Business Administration2000 - 2001University of San Francisco - San Francisco, CA
- Bachelor's degree in Statistics and Computer Science1980 - 1984UC Berkeley - Berkeley, CA
Certifications
- Microsoft MCSAFEBRUARY 2019 - PRESENTMicrosoft
- Public Speaking CertificationNOVEMBER 1991 - PRESENTDale Carnegie
