Dmitry Bykov Email & Phone Number

- AWS Cloud Solutions- Database tuning and developement- Enterprise software development

Key responsibilities:- Design and implement new database functionality for in-house processing based on Oracle 19c (Packages, Triggers, Indexes etc.);- Optimization of query performance;- Participate in architecture and desing sessions with team members;- Support, debugging, refactoring legacy code;- Conducting Code Review;- Conducting Interview, Performance Review;- Training of colleagues;- Writing backlog, task evaluation, decomposition.Main achivements:- Created a corporate course on advanced study of Oracle DBMS consisting of 10 lectures, including optimizer operation, database object statistics, optimization basics, tracing and profiling, troubleshooting with AWR, ASH, ADDM and others;- Developed a mechanism for proactive optimization;- Optimized a number of business processes, reducing the overall DBMS load by 15% (IO, CPU Usage).- Successfully worked with a highly loaded OLTP database of 60TB in size and 50k objects

Key responsibilities:- Design and implement new database functionality including server-side PL/SQL (Packages, Triggers etc.) and SQL scripts;- Tuning existsing PL/SQL code to improve performance;- Participate in architecture and desing sessions with team members- Automating the script installation process using Jenkins and PowerShell scripts;- Maintaining and developing new web application features using Java 8, JSP;- L3 support of existing features;- Migration of on-prem database to Amazon RDS Oracle;- Deploying new database features using GIT, Liquibase, Jenkins;- Code Review;Main achivements:- I was part of a team of experts who were building a new web application based on Oracle RDS and other AWS services;

Key responsibilities:- Developing and handling the PL/SQL Packages, Procedures, Tables, Views, Indexes, Synonyms, Triggers, Functions, Materialized Views and Sequences, etc.- Developing new features for in-house processing based on Oracle 19c;- Developing a lot of reports using JasperReports- Performance Tuning/Analyzing/troubleshooting and providing technical support;- Refactoring legacy-code;- Code Review;Main achievements:- I have developed and implemented the a printing mechanism based on the integration of several systems;- I have developed the cascading table archiving mechanism;

Key responsibilities:- Development and maintenance corporate system for insurance company;- Development of server functionality based on Oracle 12c;- Development of new forms of client application using Delphi 7;- Support and debugging of legacy-code + refactoring;- Creation of PL/SQL scripts for load testing;Main achievements:- I have developed and implemented the algorithm for controlling the limits of the participants of an agreement;- I have developed the mechanism of async start of WF processes.

Key responsibilities:- Participation in development and support of high-loaded Data Warehouse on Oracle 11g, 12c;- Development of ETL and ELT processes using Oracle Data Integrator 12c;- Design of data schemes using PowerDesigner 16.5;- Writing VBScipt model enrichment scripts;- Use Oracle SQL Developer, Oracle Workflow Builder as development tools;- Code Review;- SQL Tuning.Main achievements:- Learned the basic methodologies for designing data warehouses: Kimball, Inmon, Linstedt (Data Vault);- Working as a DWH developer I built a new data warehouse based on Oracle 12c using Oracle Data Integrator 12c and Data Lake as a source.

Key responsibilities:- Support of existing and development of new server functionality of OTLP system;- Design of data schemes. Writing business logic in PL/SQL procedural language. Oracle 10g;- Writing of stored procedures, functions, triggers;- Code refactoring and code review;- Creating reports in MS Word, Excel, Crystal Reports using SQL and VBA macros;- Corporate software development based on ASP.NET MVC;- Implementation of accounting entries algorithms.Main achievements:- I have developed a heat metering system and a flaw detection system based on Oracle 10g;- Based on Active Directory information I have developed corporate phone book and corporate pass control system. In this two projects I used C#, ASP.NET MVC5, LDAP queries, DI, Entity Framework 6 Code First Migration, Angular, HTML, CSS;- I optimized about 20% of the code running, which reduced the load on the database several times.

Key responsibilities:- Conduct regression/functional/load testing using Informatica PowerCenter 8;- Creation of test scenarios, writing test cases;- Reporting on the testing process;- Writing complex SQL queries, PL/SQL procedures and functions based on Oracle 11g;- Optimization of queries.Main achievements:- Learned the basics of Cost Based Optimization;- Learned how to write complex queries with a dozen tables with different types of joins.

Key responsibilities:- Extensive testing of public and private web based applications;- Logging of application bugs to analyze and resolve;- Functional testing using HTML, CSS and Javascript;- Writing simple SQL queries.Main achievements:- Learned the basics of of creating web sites, the basics of html, css, javascript;- Got to know with the query language, studied its basics.