Dmitry Bykov

Dmitry Bykov Email and Phone Number

Senior Oracle Developer at Yandex @ Yandex
moscow, moscow, russia
Dmitry Bykov's Location
Russia, Russian Federation
About Dmitry Bykov

I am glad to share that I am starting my own journey. After 12+ years in software development I feel confident and experienced enough to found an own IT company Avior Dev. As a certified Oracle Database Developer I want to focus on 2 directions: modern cloud database solutions and on-prem database solutions. If you want to develop some database or migrate your legacy project and infrastructure to the cloud - feel free to contact us.Our company has in-depth knowledge:✔ Over 11+ years in Oracle database development (from 10g to 19c)✔ Experience in Banking, Fintech companies, Insurance, Telecom and Manufacturing✔ Hands on experience in design, development & implementation of OLTP and DWH systems, using normalization and methodologies (Data Vault, Inmon, Kimball)✔ In-depth knowledge of Oracle database Architecture, Partitioning, Parallel queries✔ Managing Oracle objects including Tables, Indexes, Views, Materialized views, Constraints, DB Links, Jobs etc✔ Strong PL/SQL coding skills, including Packages, Stored Procedures, Functions, Triggers✔ Excellent SQL coding skills using standard and advanced features (analytic functions, recursive and hierarchy query, XML and JSON, SQL modeling etc)✔ Hands on experience on coding, troubleshooting and performance tuning PL/SQL and SQL using AWR, ASH, Real-Time Report, Profiling and trace files✔ Hands on experience in implementation of workflow, using Oracle DataIntegrator, Oracle Workflow Builder, Informatica PowerCenter✔ Knowledgeable in software development lifecycle and software engineering processes - Kanban/Agile MethodologyBest regards,Dmitry

Dmitry Bykov's Current Company Details
Yandex

Yandex

View
Senior Oracle Developer at Yandex
moscow, moscow, russia
Website:
yandex.com
Employees:
5182
Dmitry Bykov Work Experience Details
  • Yandex
    Senior Oracle Developer
    Yandex Apr 2024 - Present
  • Avior Dev
    Co-Founder & Software Developer
    Avior Dev May 2022 - Present
    - AWS Cloud Solutions- Database tuning and developement- Enterprise software development
  • Ural Bank For Reconstruction And Development
    Lead Oracle Database Developer
    Ural Bank For Reconstruction And Development May 2022 - Mar 2024
    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
  • Dataart
    Senior Oracle Developer
    Dataart Aug 2021 - May 2022
    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;
  • Home Credit And Finance Bank
    Senior Oracle Developer
    Home Credit And Finance Bank Sep 2019 - Aug 2021
    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;
  • Bell Integrator
    Senior Oracle Developer
    Bell Integrator Oct 2018 - Aug 2019
    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.
  • Home Credit And Finance Bank
    Senior Oracle Developer
    Home Credit And Finance Bank Aug 2016 - Oct 2018
    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.
  • Voronezhstalmost
    Oracle Developer
    Voronezhstalmost Mar 2012 - Aug 2016
    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.
  • At Consulting
    Etl Qa Engineer
    At Consulting Jul 2011 - Mar 2012
    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.
  • Ivelum
    Web Qa Engineer
    Ivelum Apr 2010 - Jun 2010
    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.

Dmitry Bykov Education Details

Frequently Asked Questions about Dmitry Bykov

What company does Dmitry Bykov work for?

Dmitry Bykov works for Yandex

What is Dmitry Bykov's role at the current company?

Dmitry Bykov's current role is Senior Oracle Developer at Yandex.

What schools did Dmitry Bykov attend?

Dmitry Bykov attended Voronezh State Technical University.

Who are Dmitry Bykov's colleagues?

Dmitry Bykov's colleagues are Nikita Zubkov, Olga Parfionova, Kirill Lagunkov, Elena Tishchenko, Robert Berry, Vladislav Vaganov, Lev Prokin.

Not the Dmitry Bykov you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.