Oracle DB 11g-19c, Postgres DB 10 maintenance on RedHat, CentOS platform, installation, database creation, patching. Oracle database upgrading with auto upgrade tool, expdp/impdp technology, Golden Gate software. Commvault (Simpana) backup and recovery of database, DB duplicating. Bash scripting. Experience in project management system JIRA.

Technical support of Russian federal estate system: Oracle 10g-11g, PostgreSQL, MongoDB, ОС CentOS 7.3, Debian 9, Camunda 7.5, Python3.6, bash.

Project “Intellectual Railway Transport Management System” 24x7: - Project implementation (49 servers): installation and configuration of operation systems: Windows Server 2008R2, Windows Server 2012, RedHat 6.5, CentOS 7.3; database installation and configuration: Oracle 11g Standard Edition, PostgreSQL 9.4; installation and configuration of additional program tools: Oracle Web Tier 11g, ZooKeeper, Microsoft Cluster (on WinServer2008R2, Vector-M Cluster ), Specific Software (on Virtual Server: VMware vSphere 6.0) - Entire system administration and support, development of additional support bash scripts Project “Station Control System” of a Railway system 24x7: - Administration of SUN Solaris 9-10 platform (SUN Fire V890, SUN Fire V480R, SUN SS D2, SUN StorEdge 3310, EMC CLARiiON CX3-20, EMC Brocade DS-4100) - Administration of Oracle9i-10g - Administration Veritas(Software Foundation) Software (Cluster Server, Volume Manager, File System). - Designed and implemented backup and recovery scenarios: logical (export utility), physical (rman utility), standby (data guard manager). - Upgraded Oracle 9i to Oracle10g on Solaris 10 SUN Fire V890 platform - Installed Oracle 9i on Solaris9, Solaris10 on SUN Fire 480R, SUN Fire V890 paltform - Installed VERITAS 3.5-5.0 (Software Foundation) on SUN Fire 480R, SUN Fire V890 - Installed Solaris 9 on SUN Fire V480R WEB-based project “Financial Information system” for Krasnoyarsk Railway: as Oracle DBA and Unix Administrator (Solaris 2.6) and developer leader of 10 people - Designed and implemented backup and recovery scenarios: logical (export utility), physical (rman utility), standby (data guard manager). - Migrated Oracle Database 8.04 from AIX 4.3.2 to Oracle 8.0.4 on Solaris 2.6 platform - Installed, configured and administered Oracle 8.0.4, 8.1.5, 8.1.7, 9.0.2 on Solaris 2.6, 8 on SUN Enterprise 450 and SUN Ultra 10 platform - Installed, configured and administered Solaris 8 on Sun SPARC 450 Enterprise and Sun SPARC Ultra 10. - Migrated Oracle Database 7.3.2 from Digital Unix 4.0 to Oracle Database 8.0.4 on AIX 4.3.2 - Installed, configured and administered Oracle 8.0.4 on AIX 4.3.2 - Installed, configured and administered AIX 4.3.2 on RS6000. - Installed, configured and administered Oracle 7.3.2 on Digital Unix 4.0. - Installed, configured and administered Digital Unix 4.0 on DEC Alpha 1000. - - Compiled and activated php_module for Apache 1.3.9 (SUN SPARC Solaris 2.6) for using PHP interface to Oracle Database as one more alternative for Oracle Web Server. - Compiled, installed, configured and maintenanced Apache 1.3.9 (SUN SPARC Solaris 2.6) in non-standard configuration. - Installed, configured and administered Oracle 7.x-8i, Oracle Web Application Server 1.0-3.0 under different platforms (Digital Unix 4.0, Solaris 2.6, AIX 4.3.2, Linux, Windows NT). - Designed different recovery scenarios. Recovered database 8.0.4 under SUN Solaris platform (One of control files was lost). - Performance tuning: gathered and analyzed statistic reports (Oracle admin. scripts utlbstat/utlestat), tuned of database parameters, tested and optimized stored procedures. - Created users, installed developers toolkits (gnu-compiler, gnu-debugger, perl, gnu make), additional security tuning for different services (ftp, telnet - installed tcpwrapper, wu-ftpd, print-service). - created main building principles, designed database model, created ( database structures, developed scripts for table, indexes, triggers, sequences, views, procedures and functions creation. - Developed server-side applications: scripts to get data from different data source (shell, perl, ftp), set of functions for different data parsers (C, OCI). - Compiled our server-side applications. Create PL/SQL procedures and functions with HTML-output (Oracle htp-package, HTML). Project "Report Generation System" under FreeBSD: - designed database structure for miniSQL and create SQL scripts to create database structure(tables,indexes and so on) - developed data parsers (Lex/Yacc, C) - created scripts to get data files from different sources (shell, ftp,e-mail).

- Technical Support for all school computers - Installed Windows 3.11, Windows 95 on computers, Office software on Windows platform.

Computer Software, Computer Software

RDTEH Education Center, Moscow, Oracle Database 12c R2: Clusterware & RAC Admin Accelerated

Moonlight Language School, Key Note Pre-Intermediate B1

REDCENTER, Moscow, New features in administration Oracle10g

REDCENTER, Moscow, VERITAS Volume Manager

REDCENTER, Moscow, Oracle 9i Server Database Administration

IT Academy, Krasnoyarsk, SA-238 Solaris 8 Operating Environment System Administration I, SA-288 Solaris 8 Operating Environment System Administration II

MicroTest Education Center, Ekaterinburg, Oracle8 Server Database Administration, Oracle8 Backup and Recovery, Oracle8 Performance Tunning

IT Academy, Krasnoyarsk, Oracle7 Server Database Administration