Scott Spicola

About Scott Spicola

Working with Microsoft SQL Server, VB.NET, C#, ASP.NET, Classic ASP, development tools and technologies since with the last 10 years primarily working on SQL Server development (SSMS/SSIS/SSRS and to a limited extent SSAS).

Experience

1. Software Developer Iii

   Charles Schwab

   Dec 2017 — Present · Lone Tree, CO, US

   Achievements: Expanded my database knowledge from SQL server to include Oracle PL/SQL using TOAD. My Oracle experience includes 11g and 12c and we are currently preparing for an upgrade to 19c. Played a key role in the USAA integration by developing and running processes to correctly load and configure preferences for managed accounts. Currently very involved in the integration with TDA. The development and research for TDA have been similar to the USAA work but on a much larger scale. Re-wrote a large number of complex processes as SSIS packages. This allows much faster and easier development, especially on processes that use different platforms. This also nearly eliminated the Kerberos issues we were facing.Responsibilities: Working primarily in a group that owns 14 different internal applications as the only DB Developer. My job roles include both troubleshooting and fixing any problems, as well as the design and development of any new database objects on SQL and Oracle databases. Responsible for 4 SQL server upgrades, moving from 2012 to 2016 or 2019. This responsibility included moving and often re-writing the jobs, accounts, and SSIS packages from the existing server to the new server. A separate team was responsible for moving the data.

Education

• Pueblo Community College

  Associate's degree, Business Administration and Management, General, 3.6

  1998 — 2000