Senior Database Engineer and ETL Architect

STAN IORDANOV

******@*****.*** 949-***-**** https://www.linkedin.com/in/staniordanov/

Languages: English, Bulgarian, Russian, basic French TECHNICAL SKILLS

SQL, MySQL, T-SQL, PL/SQL, SQLite, Python, Java, Perl, bash, C++, C#, C, CLIPS, MASM, QBasic Windows 95/98/2K/NT/XP/7, LINUX, UNIX (SunOS),

MySQL 4.1/5.0/5.1/5.6/5.7/8, MSSQL Server 7/2K/2K5/2K8, PostgreSQL, ORACLE 7i/8i/9i/10g Snowflake, Jenkins, Flyway, Tungsten, Terraform, Ansible, Puppet, check_mk, Git, DbVisualizer, SqlYog, Eclipse, TOAD, SQL*Plus, SQL Compare, Oracle E-Business Suite 11i, Crystal Reports 9/10, MS Visual Studio 6.0, vss, trac, svn, cvs, emacs, vi, Citrix, Jira MAJOR PROJECTS

Snowflake Loader

Developed an ETL pipeline tool moving prod data to Snowflake via S3 and AWS. The tool extracts incremental data as well as full database migration loads. Written in Python and MySQL. Automated Software Deployment

The code is able to detect the version of the database it is running on, and is able to either upgrade the version or roll it back to a previous version depending on what version of the code is currently running. The biggest advantage of this system is that deployments can be fully automatic. Db hard links within procs are updated as per the db the Deploy happens. Written in Python/ T-SQL/ MySQL. DbMonitor

Monitors the database and all connections to it. Detects if scripts have been run directly on the database that change the schema in any way between versions. Identifies bottlenecks. Alerts when any of the scheduled processes are late. Implemented in Python/ T-SQL/ MySQL. DbScripter

Script the complete database schema (tables, procs, triggers, views, indexes, etc) with minimal base data needed by a developer to test newly developed features. Written in Python/ T-SQL. MySQL DBA Tool

Implemented to move and extract data between different Linux/Win Database servers. Refresh the development server’s testing and staging databases. Change db storage engine depending on destination. Flush old data from production databases and keep the last a couple of months. Written in Perl. Oracle DBA Tool

Developed features such as Import/Export, Database creation, Table spaces administration, SQL query window with command history, and Data Population. Implemented in Java with a graphical interface. Oracle to SQL server Data Migration Tool

Implemented in PL/SQL and T-SQL. Kept all primary keys, indexes, constraints, and triggers. Packaged using Python.

DTS Tool for SQL server 2005 Express

Import/Export and data migration done in pure SQL avoiding all version incompatibilities. Kept all primary keys, indexes, constraints, and triggers. Packaged using Python. Database Monitoring

Implemented a monitoring tool to identify potential issues with the database servers such as replication, server mismatches, system variables, database changes, automating profiling, version control, etc. Developed in python.

BI server and Financial Reports

An ETL was developed to fill the data onto the BI server on a daily basis. Built a framework in python for financial and other reports in fully automated fashion. Implemented in python and MySQL. WORK EXPERIENCE

Lead/Staff Database Engineer July 2015 – present

Rubicon Project /MAGNITE, Los Angeles

- Lead database engineering team of 3 DBAs and 2 SREs, coordinated daily operations and long-term projects across over 500+ database nodes on-prem and in AWS

- Mentor junior DBAs through individual training sessions on performance tuning, replication, best practices, and regular KT sessions

- Managed database using Flyway, Git, Terraform, check_mk, Jira, Jenkins, and Ansible - upgrades, backups, releases, rollbacks, database monitoring, and SOX compliance

- Performance tuning and optimization reducing query response by 80%

- Automation and programming using Python, bash, AWS, Snowflake

- Managing MySQL 5.1-8.0, PostgreSQL, AWS RDS/EC2, ensured High Availability MySQL and Scalability

- MySQL replication, Tungsten replication, ETL, Terraform, Ansible

- Build many pipelines in Python loading from MySQL to S3 and Snowflake, from Greenplum to Snowflake

Technical Operations Database Engineer July 2012 – July 2015 RED 5 STUDIOS, Laguna Hills, California

- Managed all databases supporting Firefall the game (MMO)

- Performance tuning and optimization, Database monitoring

- High Availability MySQL, Scalability, MySQL GTID replication (5.6.5 - 5.6.19)

- Managed and supported over 500 database servers, 400K+ queries/sec, and 50K+ concurrent players

- fully in AWS/EC2 on 5 geographical locations

- Implemented custom Python tools for numerous database operations Senior Database Consultant October 2011 – June 2012 Transcontinental (via Progression3), Montreal, Quebec

- Setup High Availability MySQL using mmm, MySQL Cluster 7.2 proof of concept

- Performance tuning and optimization, Load balancing

- Database monitoring, Troubleshooting and bug fixing Senior DBA March 2011 – September 2011

iCongo, Montreal, Quebec

- Full Database support on SQL Server (2000, 2005, 2008) and Oracle (10g) production databases

- Performance tuning and optimization, Database monitoring, Automated deployments and db versioning Senior Principal Production DBA October 2009 – March 2011 PSL Consulting Group, Montreal, Quebec

- Full Database support on SQL Server (2000, 2005, 2008) and MySQL (5.14) production databases

- Performance tuning and optimization, Database monitoring

- Master-master replication, Automated deployments and db versioning - Data migration from SQL Server to MySQL

Python Software Developer February 2007 – October 2009 Pivotal Payments, Montreal, Quebec

- Full db migration (data, procedures, functions, views, triggers) from MS SQL production database to MySQL including all application code change, calls and queries.

- Unit-test driven software development in Linux and Windows. Developed tools that became the core of the software auto-deployment. Implemented database versioning.

- Data migration from MySQL, SQL Server, PostgreSQL, SQLite as well as migrating data from foreign systems into our object and database model.

- Performance Tuning, Optimization, and Automation using software profiling and Database level optimization and monitoring.

Senior DBA March 2006 – February 2007

Simpler Networks, Dorval, Quebec

- Database Development and support three major applications for MEMS chips testing using MySQL on LINUX Red Hat and Windows Server.

- Performance Tuning (SQL optimization, Indexes, Storage Engines etc.), Replication, Database Servers monitoring, Data Migration, troubleshooting, Script writing, Import/Export, reporting DBA/ System Developer September 2003 – January 2006 IC.Axon / Medcases, Montreal, Quebec

- Database Development and support four major online applications using Oracle 8i/9i and SQL server 7.0/2000/2005

- Data Warehouse database administration, data load tuning, data tracking, and recovery.

- Developed and supported Crystal Reports for a very large CME production database.

- Import/Export, troubleshooting, Script writing, Data Migration, ETL, performance tuning, reporting - Worked in Oracle and SQL Server environments.

ACADEMIC BACKGROUND

Bachelor of Computer Science (Information Systems) 2002 Concordia University, Montreal, Quebec

DATABASE COURSES

MySQL Server 5.0 Performance Tuning and Optimization – 2006 Advanced MySQL DBA/Developer Training – March 8th- 9th 2010 Hobbies and Interests: adventure motorcycles, taekwondo, martial arts, history. References available upon request.

Contact this candidate