Jay Robinson

Jay Robinson

Fountaintown, IN, United States
Hire Jay
Scroll To View More
Jay Robinson

Jay Robinson

Fountaintown, IN, United States
Member since November 10, 2016
Jay is a seasoned developer with a concentration on T-SQL and C# development. He focuses on data-tier development, and has considerable experience in improving the performance and maintainability of large-scale applications built around relational data models.
Jay is now available for hire
Portfolio
Experience
  • Transact-SQL, 19 years
  • .NET, 16 years
  • C#, 10 years
Fountaintown, IN, United States
Availability
Part-time
Preferred Environment
Visual Studio, SQL Server Management Studio
The most amazing...
...app I developed was an entire site dedicated to a team of players of a sports management game, with multivariate linear regression done entirely in T-SQL.
Employment
  • Senior Systems Engineer
    (A Major Software Company)
    2008 - PRESENT
    • Contributed to a SaaS platform that scales across hundreds of RDBMS instances and thousands of application servers, with a particular focus on asynchronous features that operate on data in bulk—often millions of rows of data.
    • Participated in the successful zero-downtime deployment of dozens of major releases of that platform.
    • Designed, developed, deployed, and maintained a REST API for a data warehouse.
    • Mentored other developers on T-SQL best practices, provided in-house training for development and support teams, and contributed to official internal T-SQL standards for development.
    • Improved the performance of dozens, if not hundreds, of stored procedures, through a variety of methods; including for example, better alignment of code with existing indexes, modification of indexes and creation of new ones, addressing parameter sniffing issues, caching results in the application layer where appropriate, addressing issues related to linked servers, and more.
    Technologies: SQL Server, .NET Framework, C#
  • Systems Engineer
    Leaf Software
    2005 - 2008
    • Replaced the use of an off-the-shelf data tier product with a faster, more efficient solution which was able to be deployed in the existing app with minimal interruption to the customer experience.
    • Maintained the app, as part of a small team of developers, which tracked financial transactions for an automotive financing organization—troubleshooting and resolving issues, adding features, and improving stability and performance.
    • Added a feature that would "phone-home" exceptions to our bug tracking software—allowing our team to begin addressing those exceptions before being notified by the customer.
    Technologies: SQL Server, .NET Framework, C#
  • Project Manager
    Frakes Engineering
    2001 - 2005
    • Contributed to the development of policies and procedures to meet certification guidelines for an industry association.
    • Provided network administration for the organization, supporting technologies such as an Active Directory domain, Exchange Server, IIS, SQL Server, and ISA Server.
    • Developed and deployed applications in a wide variety of industries—including pharmaceuticals, automotive, pulp and paper, chemicals, and agriculture.
    • Developed the T-SQL portion of an application that managed an automated-storage-and-retrieval system for an automotive manufacturing facility; including stored procedures that provided the business logic for the robots.
    • Hacked, as directed, a Unix system in order to gain the authorization needed to export the existing data from an IBM Informix database for the aforementioned ASRS, and then manually performed the ETL to import this data into my SQL Server database so that the customer did not need to manually inventory the entire contents of the ASRS as part of the transition.
    Technologies: Windows Server Suite, Visual Basic .NET, C#, SQL Server
  • Project Engineer
    Rockwell Automation
    1997 - 2001
    • Provided technical support and network administration for the local office—supporting a variety of technologies, such as Novell Netware, a Windows domain, and several DOS applications running under Windows 95 and Windows 98 OS's.
    • Developed and deployed applications in a wide variety of industries; including pharmaceuticals, automotive, food and beverage, and glass manufacturing.
    • Developed and deployed a SQL Server/IIS/ASP application that displayed both charts and graphs in near-real-time, accessible by Netscape Navigator browsers on OS/2 clients.
    • Developed and deployed an application for an assembly line, using Visual Basic 6 which gave the customer enough confidence—despite a negative history with another product group—to invest in future projects with my organization for the next several years.
    • Developed and deployed, as part of the first implementation of a PCI-bus CNC controller, a Visual Basic 6 application that facilitated communication between the controller's software—which used an obsolete and unstable Microsoft technology, DDE—and my organization's standard controller software which used a C-based API.
    Technologies: SQL Server, Visual Basic 6, Rockwell Software, IIS, ASP
Experience
  • SQL Saturdays (Other amazing things)
    http://www.sqlsaturday.com/

    I present technical sessions at PASS SQL Saturday events, as well as local chapter meetings.

    My past SQL Saturday sessions and a summary of each session are listed below.

  • SQL Saturday | Fast and Furious Dynamic SQL (Other amazing things)
    http://www.sqlsaturday.com/358/Sessions/Details.aspx?sid=17606

    We all appreciate a well-defined and well-tuned stored procedure. But sometimes the problem calls for a more dynamic solution. What are those problems and how do you generate SQL to solve them? After attending this session, you will be able to identify situations that call for dynamic SQL and address them with rapid, maintainable, and secure code.

  • SQL Saturday | Playing in Traffic: Lessons from High-Speed, High-Volume Applications (Other amazing things)
    http://www.sqlsaturday.com/402/Sessions/Details.aspx?sid=36655

    DBA - Database Development

    How do you as a developer take database activity into account when designing and writing your code? What works well on a small scale can often fall down as traffic picks up. In this session, attendees will learn methods for making their SQL scripts run faster, avoid blocking, and remain stable in a busy environment

  • SQL Saturday | Adding Lightness: Better Performance Through Compression (Other amazing things)
    http://www.sqlsaturday.com/474/Sessions/Details.aspx?sid=39982

    Application & Database Development

    This is a deep dive into data compression in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in busy production systems.

  • SQL Saturday | EXEC and sp_executesql: An ad hoc rally (Other amazing things)
    http://www.sqlsaturday.com/474/Sessions/Details.aspx?sid=42288

    Application & Database Development

    The EXEC statement provides plenty of flexibility, and sp_executesql offers even more benefits on top of that. But both have their drawbacks, their nuances, and their impact on performance. After this session, you will know what to expect from the query processor when using these features in your code and how to get the most performance out of them.

  • SQL Saturday | Playing in Traffic: Lessons from High-Speed, High-Volume Applications (Other amazing things)
    http://www.sqlsaturday.com/421/Sessions/Details.aspx?sid=36653

    How do you as a developer take database activity into account when designing and writing your code? What works well on a small scale can often fall down as traffic picks up. In this session, attendees will learn methods for making their SQL scripts run faster, avoid blocking, and remain stable in a busy environment.

  • SQL Saturday | Adding Lightness: Better Performance Through Compression [PowerPoint] (Other amazing things)
    http://www.sqlsaturday.com/478/Sessions/Details.aspx?sid=41446

    Application & Database Development

    This is a deep dive into data compression of the SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in busy production systems.

  • SQL Saturday | Adding Lightness: Better Performance Through Compression [Demo] (Other amazing things)
    http://www.sqlsaturday.com/530/Sessions/Details.aspx?sid=47362

    Application & Database Development

    This is a deep dive into the data compression features of the SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in your production systems.

Skills
  • Languages
    Transact-SQL, C#, Visual Basic 6 (VB6), HTML, Visual Basic .NET (VB.NET), PHP, JavaScript
  • Frameworks
    .NET, Django REST Framework
  • Tools
    Visual Studio, Git, Microsoft Team Foundation Server, Apache
  • Platforms
    Windows, WordPress, Linux
  • Storage
    Microsoft SQL Server, SQL Server Management Studio, PostgreSQL
  • Paradigms
    Agile
  • Misc
    SOAP
Education
  • Undertook courses in Computer Science
    Purdue University - West Lafayette, IN, USA
    1995 - 1996
  • Undertook courses in Computer Science
    Indiana University Bloomington - Bloomington, IN, USA
    1993 - 1996
I really like this profile
Share it with others