cv_template.tex (6733B)
\documentclass[10pt,letterpaper]{article}
\usepackage[T1]{fontenc}
\usepackage{lmodern}
\usepackage[letterpaper,left=0.60in,right=0.60in,top=0.55in,bottom=0.55in]{geometry}
\usepackage{tabularx}
\usepackage{array}
\usepackage{enumitem}
\usepackage[hidelinks]{hyperref}
\usepackage{titlesec}
\usepackage{microtype}
\pagestyle{empty}
\setlength{\parindent}{0pt}
\setlength{\parskip}{0pt}
\setlength{\emergencystretch}{2em}
\urlstyle{same}
\titleformat{\section}{\bfseries\fontsize{12.5}{14}\selectfont}{}{0pt}{}[\vspace{-1pt}\titlerule]
\titlespacing*{\section}{0pt}{7pt}{4pt}
\newcommand{\job}[3]{%
\vspace{4pt}\noindent\begin{tabularx}{\textwidth}{@{}>{\bfseries}p{1.62in}>{\bfseries}lX@{}}
#1 & #2 & \normalfont{}- #3
\end{tabularx}\vspace{2pt}%
}
\newenvironment{cvitems}{%
\begin{itemize}[label=-,leftmargin=0.28in,labelsep=0.08in,itemsep=0pt,parsep=0pt,topsep=1pt,partopsep=0pt]
\setlength{\itemindent}{0pt}
}{\end{itemize}\vspace{1pt}}
\begin{document}
\fontsize{10.5}{12.3}\selectfont
\begin{center}
{\fontsize{17}{19}\selectfont Imre Viktor Ranga}\par
\vspace{1pt}
{Linux System Engineer}\par
\vspace{1pt}
Mobile: +35699781271 \quad|\quad E-Mail: \href{mailto:contact@viktor1993.net}{contact@viktor1993.net} \quad|\quad Website: \url{https://www.viktor1993.net}\par
EU Citizen \quad|\quad Location: EU (Immediate relocation within EU possible)
\end{center}
\vspace{4pt}
\section*{Summary}
\vspace{2pt}
Linux System Engineer with several years of experience deploying and operating production infrastructure in high-availability
financial environments. Strong background in automation and scripting, system monitoring, and incident response,
with additional depth in database systems and performance troubleshooting. Proven track record of delivering
measurable operational improvements, in many cases, accelerating critical production query speeds by 5x-20x.
\section*{Experience}
\job{Jun 2024 - Present}{Database Administrator (DBA)}{flatexDEGIRO AG}
\begin{cvitems}
\item Performed database version upgrades, automated server deployments (ansible), routinely analysed and rewrote slow queries, and performed schema improvements for unoptimizable queries with heavy aggregation workloads, supported zero-downtime database upgrades and disaster recovery testing
\item Developed ansible playbook for automated MariaDB and PostgreSQL microdb provisioning, reducing deployment time to $<$5 minutes
\item Created summary tables to speed up client-facing queries needed to fetch portfolio data, cutting latency by 20x, improving API response times for the frontend
\item Rebuilt foreign currency exposure calculation on billions of rows using pre-aggregated summary tables, reducing runtime from 6 hours to 15 seconds, enabling timely monitoring for risk management
\item Designed and implemented a git driven pipeline that builds database docker containers from configuration changes for ephemeral test instances, isolating test data per instance to eliminate cross team data overwrites
\item Built monitoring infrastructure using Prometheus/Grafana for (MariaDB and PostgreSQL) database metrics, integrated alert delivery to other platforms (E-mail, JIRA, MS Teams) for faster incident response
\end{cvitems}
\job{Nov 2020 - May 2024}{Site Reliability Engineer (SRE)}{flatexDEGIRO AG}
\begin{cvitems}
\item Acted as a general problem-solver across teams, investigated root causes of production outages and implemented fixes to prevent recurrence
\item Led SRE role in a MySQL 5.7 to MariaDB 10.4.29 migration, overseeing test environment setup and executing the switchover. Identified and resolved query incompatibilities, including an issue that caused MariaDB crashes
\item Reduced critical ETL pipeline execution time by 67\%, improving reliability of client-facing data
\item Set-up new git based deployment automation for team, allowing for easy rollback of scripts via a single trigger from the ticketing system, improving deployment safety and incident recovery
\end{cvitems}
\job{Mar 2019 - Oct 2020}{PHP Developer}{DEGIRO BV}
\begin{cvitems}
\item Owned maintenance and feature development for a production PHP application, ensuring stability and performance as sole team member
\item Implemented new test environment deployment using ansible for a multi-service system (application, database, cache, search), reducing the time to deploy from hours to seconds by eliminating manual steps
\item Planned and executed an upgrade of SugarCRM from version 8 to 9 (and MySQL 5.6 to 5.7) on a heavily customized system, achieving minimal business impact with all post-upgrade issues stabilized within 24 hours
\item Transitioned to SRE team after onboarding a new 3-person dev team to take over CRM responsibilities
\end{cvitems}
\job{Apr 2018 - Feb 2019}{jr PHP Tester}{DEGIRO BV}
\begin{cvitems}
\item Resolved email save failures caused by database specific UTF-8 encoding limitations (e.g. emoji characters), restoring reliable message storage
\item Rewrote case handling logic in the CRM to fix a bug that blocked the ability to reply to unrecognized prospects, unblocking normal communication workflows
\end{cvitems}
\job{Feb 2017 - Mar 2018}{jr Business Developer}{DEGIRO BV}
\begin{cvitems}
\item Translated the website/documents, localized PR/marketing content, conducted market research, wrote scripts to automate various front-office tasks
\end{cvitems}
\newpage
\section*{Education}
\textbf{2016 - 2017}
\begin{cvitems}
\item Russian Language, Novosibirsk State University of Architecture and Construction, Novosibirsk, Russian Federation
\end{cvitems}
\textbf{2011 - 2015}
\begin{cvitems}
\item Bachelor of Science (Hons) Physics - Second Class Upper Division (2:1), University of the West of Scotland, Paisley, United Kingdom\\
\textit{Bachelor's Thesis:} Floquet-Bloch Theory of an Electron in an Array of Square Barriers [Grade A, 78.5\%]
\end{cvitems}
\textbf{2005 - 2011}
\begin{cvitems}
\item Secondary Education, Inverness High School, Inverness, United Kingdom
\end{cvitems}
\section*{Skills}
\renewcommand{\arraystretch}{1.12}
\begin{tabularx}{\textwidth}{@{}>{\bfseries}p{1.62in}X@{}}
Databases & MariaDB, MaxScale, MySQL, PMM, PostgreSQL; query optimization, performance tuning, replication and failover, backups/restore\\
Infra and Tooling & Git, ZFS + sanoid, Apache, Ansible, Docker, Prometheus, Terraform, Elasticsearch, Node.js + pm2, Redis, Zabbix\\
Languages/Scripting & PHP, JavaScript, Bash (sed, awk), Perl, Python\\
Editors/Environments & GNU/Linux (Debian and Red Hat derivatives), kvm/qemu, vim/vimscript, systemd, LaTeX\\
Miscellaneous & Incident Analysis, Monitoring and Logging, Automation, Disaster Recovery, Operational Mentoring
\end{tabularx}
\end{document}