Scroll To View More
Neal Barnett, Software Developer in Los Gatos, CA, United States
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

Experience

  • SQL, 20 years
  • T-SQL, 17 years
  • Database Administration (DBA), 15 years
  • Agile, 7 years
  • MySQL, 7 years
  • PostgreSQL, 6 years
  • Azure, 4 years
  • Python, 3 years
Los Gatos, CA, United States

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

  • Database Architect, Developer

    2019 - PRESENT
    Reliable 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: T-SQL, SQL Server 2017, Python
  • Database Architect, Developer

    2019 - PRESENT
    Globalscape
    • 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
  • Database DBA, Application Developer, Project Manager

    2015 - PRESENT
    SSI 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, Delphi
  • Database DBA, Website Developer, App Developer

    2015 - PRESENT
    Preferred 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 Studio
  • Senior Database Administrator, Architect, Developer

    2008 - PRESENT
    FORT 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-SQL
  • PostgreSQL Architect, and Developer

    2019 - 2019
    MyFitment
    • 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

Experience

  • Python Web Scrape into SQL Server (Development)

    Scraped both file download links (zip files containing CSV files) and standard web pages using Python, then script inserts into database tables, formatting data as added. Used setup tables to run scripts with parameters.

  • An Intro to SQL Window Functions (Publication)
    SQL window functions are calculation functions similar to aggregate functions but, unlike normal aggregate functions like "group by," have access to individual rows and can even add some of their attributes into the result set. In this article, Toptal Freelance SQL Developer Neal Barnett explains the benefits of SQL functions, describes when you’d use them, and gives you real examples to help with the concepts.

Skills

  • Languages

    SQL, T-SQL, Python, HTML, CSS, ColdFusion, Delphi, C#, JavaScript
  • Tools

    Adobe CQ, Tableau, Microsoft Power BI, Jira, GitHub
  • Platforms

    Windows Server, WordPress, Joomla, Heroku, Linux, Azure
  • Storage

    PostgreSQL, MySQL, Database Administration (DBA), SQL CLR, AWS RDS
  • Other

    Project Management, Machine Learning, Power BI, International Affairs, Web Scraping
  • Frameworks

    Genesis Framework, .NET, Ruby on Rails 5
  • Paradigms

    Agile, DevOps, Continuous Delivery (CD), Continuous Integration (CI)
  • Libraries/APIs

    jQuery

Education

  • Masters's degree in Business Administration
    2000 - 2001
    University of San Francisco - San Francisco, CA
  • Bachelor's degree in Statistics and Computer Science
    1980 - 1984
    UC Berkeley - Berkeley, CA
Certifications
  • Microsoft MCSA
    FEBRUARY 2019 - PRESENT
    Microsoft
  • Public Speaking Certification
    NOVEMBER 1991 - PRESENT
    Dale Carnegie
I really like this profile
Share it with others