Dmitry is available for hire

Dmitry Pechersky

Verified Expert in Engineering

Unix Shell Scripting Developer

Location

Rostov-on-Don, Rostov Oblast, Russia

Toptal Member Since

June 18, 2020

Dmitry is an OCM (Oracle Certified Master) database administrator with over eleven years of experience maintaining mission-critical, billing and payment processing systems. He specializes in enterprise-level databases, tuning performance, solving problems, and configuring databases.

Oracle RMAN Oracle Performance Tuning Oracle ASM Oracle Data Guard Oracle SQL Oracle RAC PL/SQL Python Linux Git Oracle Real Application Clusters (RAC)

Portfolio

MegaFon

Python, Shell Scripting, PL/SQL, SQL, Linux, Oracle

Kapital Bank

SQL, Oracle, Linux

Experience

SQL - 11 years PL/SQL - 11 years Oracle - 11 years Oracle Performance Tuning - 11 years Unix Shell Scripting - 11 years Oracle Data Guard - 6 years Oracle RAC - 5 years

Availability

Part-time

Preferred Environment

Oracle RDBMS, Git, Linux

The most amazing...

...thing I've implemented is the HA Oracle databases for the Unified Billing project with over 76 million subscribers.

Work Experience

Senior Database Administrator

2005 - PRESENT

MegaFon

Supported about 400 databases on HP-UX and Linux. The databases are up to 40 terabytes and handle 1500 transactions per second. They are mission-critical billing and payment processing systems with over 76 million subscribers.
Tuned SQL queries and database performance.
Implemented HA Oracle databases using RAC, DataGuard 11g, 12c; including a cross-regional disaster recovery infrastructure.
Developed an application for the deployment test Oracle environment from production; including Oracle software and databases.

Technologies: Python, Shell Scripting, PL/SQL, SQL, Linux, Oracle

Database Administrator

2012 - 2016

Kapital Bank

Set up and maintained SUSE Linux Enterprise servers and implemented HA Oracle databases.
Turned SQL queries and database performance.

Technologies: SQL, Oracle, Linux

Experience

Cloning Production Databases into Test Environments

The goal was to give the development and testing teams the ability to create test databases as fast as possible without a database administration team. I developed this application in response to that need (for creating test databases from production databases).

Project Details:
• Copy up to 50 terabyte databases from production to test environment with low usage of network and storage resources
• The application installs, updates, and configures Oracle Grid and RDBMS software on test servers.
• Used on more than 60 test databases.

Technologies: Oracle, Data Guard, Oracle ASM, Python, Storage Copy-on-write Snapshots

Migration Oracle Database from HP-UX to Linux

I migrated a 40-terabyte billing system database from HP-UX to Linux.

Switchover Multiple Databases Across Data Centers

I developed an application to switchover multiple databases between data centers.

Technologies: Oracle, Data Guard, Python

Education

1998 - 2003

Diploma Degree in Mathematics

Southern Federal University - Rostov-on-Don, Russia

Skills

Languages

SQL, Python

Platforms

Oracle, Linux

Other

Oracle RMAN, Oracle ASM, Oracle Data Guard, Oracle Performance Tuning, Shell Scripting, Unix Shell Scripting

Tools

Oracle RAC, Git

Storage

Oracle RDBMS, PL/SQL

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring