CV2

Denis Savenko

Vienna, Austria

blog: http://dsavenko.me

linkedin: https://www.linkedin.com/in/denissavenko

PERSONAL STATEMENT

I am a Data Architect and Database Engineer coming from telecommunications, logistics, and software engineering industries. Have more than 12 years of experience in software development for various data sources with an attitude of a Product Owner. Technically, specialize on data in general and on SQL, PL/SQL, PL/pgSQL, SmartDB, Oracle, PostgreSQL and Kafka in particular.

Have a mindset of approaching complex problems in an analytical and systematic way. Always try to find as elegant and as simple solutions as possible. Keen on discovering possible risks and pitfalls, and prefer to resolve them sooner than later. Build not only software solutions, but also processes around them and establish communication between people involved. Love sharing my experience with workmates and am always excited to continuously learn from them.

EMPLOYMENT
Senior Database Developer

"J-IT" IT-Dienstleistungs GesmbH – https://jit.at

Vienna, Austria

September 2019 – present time

Responsibilities:

  • Data integration, data pipelines architecture and implementation using built-in RDBMS capabilities and special instruments such as Kafka and Kafka Connect.
  • Data migrations and facilitation the shift from the monolithic architecture to the microservice, data mesh and event-driven approaches.
  • Technical analysis, databases development and support. Working in close collaboration with customer’s Solution and Enterprise Architects, representing the key role of a Database Developer and Architect.
  • Refactoring of the data architecture (making changes to the database schema in order to satisfy changed requirements).
  • Development and optimization of stored procedures and packages using PL/SQL and PL/pSQL languages.
  • Optimization of SQL queries, profiling work of procedures, searching for weaknesses in source code, solving other database performance issues.
  • Taking part in other various projects for Magenta Austria (formerly T-Mobile Austria and UPC Austria) as external Database Expert and Consultant.

Key Achievements:

  • Introduced a reliable way to replicate data from different sorts of data sources to a special database over Kafka to facilitate data consistency checks between datastores owned by different microservices. Then organized transparent monitoring and alerting functionality on top of this database and introduced an incident management process. This increased the level of data coherence in the company ecosystem dramatically, and enabled development teams to repair applications logic much sooner than data discrepancies affected the company business.
  • Completed a big integration project with the mother company (Deutsche Telekom), where a consistent data pipeline was needed in the heavily distributed environment between different Kafka clusters. Introduced changes management processes for the pipeline, and made the applied pattern reusable for future integrations. This complemented the client in the data availability, and made it possible to execute important reporting against heterogeneous data, which, in its turn, improved the quality of business decisions.
  • Successfully migrated the corporate customers database of the client’s child company into the main customers datastore, then established a consistent data synchronization pipeline between the data sources. This allowed the client to use their complex sales, service and marketing systems on the whole set of the company’s customers much more efficiently.
  • Integrated HEROLD companies catalog to the client's database and organized a periodic synchronization with it. This enabled the company to include those companies to their leads list, and work with them as with their prospective customers, which led to the sales increase.

Database Team Lead/Engineering Manager

EST Technologies – www.estaxi.ru

Russian Federation

January 2014 – May 2019

Responsibilities:

  • Supervising the current development process in the department, conducting integration testing and deployment processes of completed releases.
  • Facilitating necessary communication between people, also between different departments (e.g. a database department and back-end java developers).
  • Organizing and facilitating different types of meetings in order to synchronize current knowledge and correct the requirements.
  • Designing some essential parts of the system, especially the database level of it, developing the database schema and relation model according to business needs.
  • Providing in-depth analysis of several solution options for some business problems, presenting the elaborated solutions to stakeholders, choosing the best ones by matching the benefits and downsides of each of them.
  • Working out short and long-term development plans together with product managers and stakeholders. Conducting further research for better understanding of the plans details, integrating the elaborated plans into the current development process.
  • Transforming the functional and nonfunctional requirements into general issues (epics) with the description of business needs and then decomposing them into small ones for each involved responsibility area (user stories and subtasks), devising acceptance criteria.
  • Conducting regular one-on-one meetings with the team members in order to be up to date about their ideas and concerns, setting personal goals with them, elaborating mid and long-term promotion plans.
  • Taking part in the interviewing and recruiting processes, collaborating in better integration and adaptation of new team members.
  • Administering company's Jira and Confluence systems.

Key Achievements:

  • Devised the conception of a brand-new affiliate system project, which intended to attract a large number of new clients and drivers, and pushed it to the development. Then successfully completed the development process and integrated the new system module into the actual business processes step by step, portion by portion.
  • Implemented a new flexible schema for clients’ fees (tariffication schema), where it’s possible for clients themselves to choose how much they want to pay for processing the users’ actions.
  • Successfully reformed the database and the desktop applications development departments of the company, hired new talented people into them. This allowed the company to focus on important stuff and continue with the product development process.
  • Restarted two essential company projects of desktop applications, which were frozen due to some company reorganizations and achieved the up-to-date status for them, then being in charge for the applications meeting the present business needs.

Lead Database Developer

EST Technologies – www.estaxi.ru

Russian Federation

October 2010 – January 2014
Responsibilities:

  • Database architecture and refactoring (making changes in the database schema in order to satisfy changed requirements).
  • Development and optimization of Oracle RDBMS stored procedures and packages using PL/SQL language.
  • Optimization of SQL queries, profiling work of procedures, searching for weaknesses in source code, coping with other database performance issues.
  • Development of administrative Oracle APEX application for internal users.
  • Providing administration help if needed, such as recovering databases from inconsistent state, eliminating resource locks, balancing available resources.
  • Business processes modeling and implementation of the model.
  • Tasks analyzing, estimating and planning (according to Agile Scrum methodologies).
  • Devising specifications (for other responsibility areas such as server-side application developers and UI engineers), describing them in Confluence Documentation Space.
  • Representation of reports of different types.
  • Work coordination of the database department.

Key Achievements:

  • Introduced a fully functional multi-master logical replication model without the enterprise option of RDBMS which allowed the company to transfer needed data between one central database server and several hundred others.
  • Developed a method of pseudo-partitioning, which improved performance of many queries dramatically, they complete from 10 to 1000 times faster than previously, depending on the case.
  • Devised working schema for internationalization of the system, where it wasn’t included in the architecture at first. It allowed the company to spread their business, and now the company is operating in more than 10 countries.
  • Introduced an effective model of preparing and deploying patches for the database layer using advanced merging functionality of version control systems by gathering (cherry-picking) needed changes which were made in a variety of revisions into a single DML/DDL script and then applying it.

INDEPENDENT PROJECTS

Full Stack Oracle Developer (Oracle Database + Oracle APEX)

Market Monitor

Ptrading Handels GmbH

Vienna

Austria

May 2017 - January 2020

Description:

An Oil Market Monitor application, showing current oil prices from SPIMEX exchange in real time. The app enables users to see current prices of the desired products on the desired railway station, applying delivery cost and other calculations 'on-the-fly'. Application is mainly developed using Oracle Database (XE) and Oracle APEX (Application Express) with some custom JavaScript magic.

Responsibilities:

  • Gathering requirements from the customer.
  • Requirements formalization as project tasks (using Atlassian Jira).
  • Database architecture and refactoring.
  • Backend PL/SQL development.
  • Frontend APEX development.
  • Testing and quality assurance.
  • Deployment and integration.
  • Receiving feedback and providing support.

Key Achievements:

  • Developed application enabled the customer to simplify their process of negotiations with their clients dramatically.
  • Usage of Market Monitor allowed the customer to increase the number of their sales due to the ability to attract less skillful employees to the sales process.


KEY SKILLS

Soft Skills

  • Product Owner approach to everything I do
  • Open-minded, constantly eager to learn new things around my area
  • Passionate about sharing my knowledge with others, so people grow around and with me
  • Always try to find as fresh and as simple solutions as possible
  • Think deep and critically, expect the same from people around me
  • Always attempt to look wider and out of the box, to find better and easier solutions
  • A picture is worth a thousand words - prefer trying and making my hands dirty, rather than be stuck in eternal discussions
  • Attentive to small things and glad to detect discrepancies sooner than later
  • Able to listen to and hear people around me, and to be heard by them
  • Ready to challenge and disagree when have strong reasons for that
  • Ability to make decisions myself and take full responsibility for them
  • Have strong beliefs in what I do and how I do things

Technical Skills

  • RDBMS principles
  • SQL
  • Oracle Database 11g, 12c, 18c, 19c
  • PL/SQL
  • PostgreSQL 12, 13, 14
  • PL/pgSQL
  • Apache Kafka (including Confluent Platform components)
  • Kafka Connect
  • Change Data Capture (CDC)
  • Data Pipelines and Migrations
  • Oracle Application Express (APEX)
  • Oracle Rest Data Services (ORDS)
  • SQL tuning and performance
  • Stored Procedures
  • Data Modeling and Architecture (UML, ER diagrams, Toad Data Modeler)
  • Containers (Docker, Podman)
  • UML (PlantUML)
  • Data Serialization Languages (XML, JSON, YAML, Avro)
  • Software Development Life Cycle (SDLC)
  • Software Project Management
  • Agile Methodologies
  • Version Control Systems (Subversion, Mercurial, Git)
  • Monitoring Instruments (Grafana, Prometheus, PromQL)
  • Project Management and Task Tracking Systems (Atlassian stack, Redmine)
  • System administration and scripting skills (Linux, FreeBSD, Windows)
  • Network administration skills (TCP/IP protocol stack, OSI model)

LANGUAGES

  • Russian (native)
  • English (C1, fluent)
  • German (B1, intermediate)

CERTIFICATIONS

EDUCATION

Omsk State University (OmSU)

http://omsu.ru/

Omsk

Specialist's degree, Analysis of Computer Systems Security, 2004 – 2010

Österreichische Integrationsfonds

https://www.integrationsfonds.at/

Vienna

ÖIF B1 Prüfung, 2022

WORK PERMIT

Austria