Optimization and Automation of a Stateless API for Aviation Data
Role: Backend Engineer / DevOps.
Client's Problem (Task): The existing server was unstable due to an overloaded database; scripts parsing government data (FAA) were crashing on “dirty” CSV files, and the client's mobile app was receiving outdated information. The goal was to stabilize operations, rewrite the storage logic, and fully automate the update process.
My Solution:
Architecture Change: Completely abandoned the heavy database in favor of a stateless architecture (generating and distributing .csv.gz files on the fly). This reduced the load on the server by several times.
Fault tolerance: I wrote fault-tolerant parsers for complex government data formats (ArcGIS, FAA 28-Day Cycle) that automatically skip corrupted lines and complete the process 100%.
Infrastructure and Security: Packaged the application into an isolated Docker container. Configured an Nginx reverse proxy with Bearer Token authentication to secure the API.
Smart automation: Set up Cron jobs with “Early Exit” logic (the script checks for updates on the source site and conserves server resources if the data hasn’t changed).
Technology stack: Python, FastAPI, Docker, Nginx, Bash, Linux (Ubuntu).
Translated with DeepL.com (free version)
Client's Problem (Task): The existing server was unstable due to an overloaded database; scripts parsing government data (FAA) were crashing on “dirty” CSV files, and the client's mobile app was receiving outdated information. The goal was to stabilize operations, rewrite the storage logic, and fully automate the update process.
My Solution:
Architecture Change: Completely abandoned the heavy database in favor of a stateless architecture (generating and distributing .csv.gz files on the fly). This reduced the load on the server by several times.
Fault tolerance: I wrote fault-tolerant parsers for complex government data formats (ArcGIS, FAA 28-Day Cycle) that automatically skip corrupted lines and complete the process 100%.
Infrastructure and Security: Packaged the application into an isolated Docker container. Configured an Nginx reverse proxy with Bearer Token authentication to secure the API.
Smart automation: Set up Cron jobs with “Early Exit” logic (the script checks for updates on the source site and conserves server resources if the data hasn’t changed).
Technology stack: Python, FastAPI, Docker, Nginx, Bash, Linux (Ubuntu).
Translated with DeepL.com (free version)
Vinnytsia 
Available for hire