Full-stack SQL Developer in Madrid, Spain

Solution: Java, Ext JS, and SQL Server Enterprise system software that controls multi-system gateways using a SOAP proprietary protocol and direct pooling, controlling through six specifics gateways of each remote control lighting manufacturer. The SQL Server Enterprise database is a 2TB database with tables that have a billion records in partitioned tables.

Performance:
• 3,000+ remote PLCs are near real-time telecontrolled.
• 126,000+ source lightings are telecontrolled.
• 4 million+ events and measures are performed each year.
• Near real-time supervision and telecontrol are provided.

Additional accomplishments: I also designed and implemented an analytics BI portal for analysis and verification of the compliance indicators for the Madrid remote control lightning and ornamental fountains service. As the only developer on this very large and complex project for more than seven years, I delivered all the implementations, maintenance, and evolutions on a part-time basis.

Solution: Copy and keep your live, remote data up-to-date on your server using different SQL Server technologies. I implemented the entire project for Eldon (now nVent HOFFMAN).

SQL Server technologies:
• Ultra-speed data transfers using BCP parallel processes and multi-disks caches.
Three synchronization technologies:
• Amazon AWS-DMS Service is automatically controlled via Amazon API Gateway.
• Partial ultra-speed full update.
• Checksum of each record calculated in each server, transferring only the changes.

Technical details:
• All data processes were programmed in T-SQL.
• Java back end supports the front end and links with Amazon AWS-DMS using the Amazon API Gateway.
• Node.js utilities control quick actions of Amazon AWS-DMS, using the Amazon API Gateway for some purposes not implemented inside the Java back end.
• Ext JS front end.

Solution: A simple and clean solution on SQL Servers without the need to install items that you don't trust. It's perfectly valid for the development or integration of SQL Servers or even, on some occasions, for the control of production servers that are not totally isolated from the developers.

Automatic Git logging of SQL Server T-SQL source code and schema changes happen at the server-side without any action from developers. Al schema changes and all T-SQL source code changes are registered into Git. It is inside the SQL Server where the change is detected and logged, not in the clients. You'll forget that it's installed until the moment you need it.

Key features:
• The changes are detected and recorded by the SQL Server itself.
• All changes are logged without the intervention of developers.
• It's easily adaptable so that the changes made by certain user accounts are not recorded, thus avoiding recording the changes made in the schemas by the BI processes, data warehouse, etc.

Background: The highest load of web stress in Spain, with several million sales per hour, is shortly before each football game. A multilayer infrastructure, front end, and 12 synchronized SQL Servers had been implemented with much of the business layer in hundreds of T-SQL procedures. I carried out the entire project.

Goals: Safe migration, consolidation, and performance improvements in a non-stop production environment. This involved upgrading from SQL Server 2000 to the last SQL Server version, ensuring complete empirical testing and documentation from an engineering perspective.

Requirements:
• 100% verification of the migrated T-SQL code with sufficient unit tests to verify code coverage.
• 100% code coverage, a record of tests performed, and verification of results.
• 100% verification of views and migrated data.
• Increased performance with the same stress and load in production.
• Hot migration performed in production systems.

Results:
• 100% compliance with the project requirements.
• Zero incidents in the hot migration of the systems in production.
• Reduced 12 servers to two servers.
• Completed the project within the budget and other terms with no incident.
• Received congratulatory feedback from the client.