Provided consulting to demonstrate that the same level of performance could be achieved within a more cost-effective environment
Created a proof-of-concept on an Azure database, while simulating the central SQL database; the team designed the tables on Azure with the proper data types, while translating more than 3000 lines of Oracle PL/SQL code to T-SQL code, primarily targeting improved performance
With the existing database, geographical data is frequently collected from different sources to local Oracle databases and then transferred to a central Oracle database
In the central database, a process (3000 lines of PL/SQL code) runs every 20 seconds, performing calculations on up to 3 minutes of collected data
This process calculates and summarizes the data (including geographical functions) and updates central tables accordingly