New Media Tech — Marketing Backend

01 Problem

A German outsource office in St. Petersburg needed backend developers for their digital advertising platform — managing ad monitoring, payment processing, and analytics for clients running online advertising campaigns. The system handled high-volume data from distributed ad endpoints and required efficient MySQL queries for analytics reporting.

02 Approach

PHP was the company's technology choice — this was a hired role, not a freelance decision. The real learning was in SQL optimization: working with large advertising datasets taught me to write efficient queries and understand indexing, joins, and query execution plans. On the infrastructure side, I volunteered to help with the local Linux development server because I was already exploring different distributions personally and saw an opportunity to apply that knowledge in a professional setting.

03 Solution

Designed the backend architecture and API independently for the advertising analytics platform. Built and optimized MySQL queries for large-scale campaign data, providing the API layer consumed by frontend developers and a UI designer building reporting dashboards. Also set up and configured the local Linux Gentoo development server (Apache, PHP, MySQL, Postgres, Samba, NFS, FTP), applying Linux administration skills gained from personal exploration of Gentoo, RedHat, and Ubuntu distributions.

04 Outcomes

05 Trade-offs

As a first official job while still at university, the main trade-off was depth vs breadth — I was learning backend patterns, SQL optimization, Linux administration, and international team collaboration all at once. The outsource model meant limited direct contact with the German headquarters, but the cross-cultural collaboration experience proved valuable for every international role that followed.

06 Constraints

• High-volume data collection from distributed endpoints
• Linux server reliability and performance
• TCP/IP optimization for data throughput

08 Reflection

This project was the bridge from academic programming to professional development. The SQL optimization skills became foundational for every database-backed project since. Working on Mac for the first time here was a pivotal moment — as a web developer and Linux enthusiast, macOS felt like Linux with a polished interface. When the outsource office closed and moved to Germany, I followed the director to his next venture in macOS development, which launched my transition from web backend to Objective-C and eventually to iOS. Without this project, the entire mobile career arc might never have happened.