Ilya Khomyakov Email & Phone Number

Atlanta, Georgia, Us

Responsibilities:Leading projects to Docker, Postgres and micro services technologies for the benefits of company’s revenues and reduces expenses. Databases updates automation with Ansible + Docker + Git. Bash and RMAN scripts writing: backup DBs, purge ADR, clear logs, clean archived redo logs, free disk space, monitor status and uptime of Standby DBs. Maintenance, monitoring and installation, of Oracle Database Server, OEM CC, OEM CC Agents software on Linux/ Windows OSs. 3rd line users’ support. Environments cloning, databases duplication, export and import.Projects:• Moving corporate Development and Testing teams to Docker+Oracle containers.• Moving expensive for business Oracle DBs to free PostgreSQL solutions to save up to 300k $ annually.• Changing “pet’s” huge and clumsy servers approach to more scalable and resilient “cattle” small and interchangeable services approach. Technologies:• Ansible playbooks, YAML, Docker, Git, Python, PyCharm IDE.• Linux RHEL6/7 and Oracle Linux 7 on x86_64 platforms. Windows Server 2012/2016.• Oracle Database 11gR2/ 12c /19c. Oracle DataGuard. RMAN, dgmgrl, asmcmd, adrci, asmca, dbca, netca. Oracle Enterprise Manager Cloud Control 12c.• SSH, SSH Keyparis, Cygwin daemon.

Antalya, Tr

Responsibilities: Mac OS X installation, performance tuning. Photography and system tools software installation. Work as a Beauty and Family photographer. Work as a sales manager with clients.Technologies:• Mac OS X Mavericks, El Captain, Sierra, High Sierra. • Photo: Lightroom, Photoshop, Capture One, Pixelmator, Photo Mechanic, Photolemur.• System tools: Tuxera Disk Manager, CleanMyMac, Disk Drill.• Photography studying from fundamentals to pro.

Limassol, Limassol, Cy

Responsibilities:PostgreSQL databases creation, maintenance, optimisation, clearing, shrinking. Development of databases cloning strategy. Work with development and support teams to improve reliability and performance of clients’ services. Databases incidents solving, performance tuning, SQL queries optimization. Incidents alerts about main DB, OS and RAID events configuration to inform responsible staff. Work in collaboration with development team to improve the quality of existing and future code to reduce the amount of incidents cased by bulky and inefficient code. Databases, storages and servers state monitoring and audit.Technologies:• PostgreSQL Database 9.3/9.4 for Solaris Sparc 64.• Solaris Sparc 10/11 64 OS.• Shell scripts, bash.• Slack, Jira, SVN.• Ubuntu 64 Desktop.

Responsibilities: Oracle databases creation, cloning, backup and restore. Production (primary+standby), report, test, development databases and ASM state monitoring and administration through Grid Control (about 30 production database up to 4TB, about 150 all). Incidents solving and performance tuning. Every day DBA tasks: monitoring backup/clone/maintenance scripts results. ASMs, tablespaces and users maintenance. Data export/ import via DataPump. Oracle Databases and Grid Control installation, maintenance and upgrade on Solaris and RHEL. Auto-backup/restore/ clone/dataguard shell scripts writing. Technologies:• Oracle Database 11gR2/10g, Oracle Grid Control 12c. • Solaris 11/10 and Linux RHEL 5.4-6.4 on Sun SPARC and Intel x86-64 platforms. • RAC, RMAN, ASM, OPatch, Data Guard, Physical Standby and Snapshot Standby. Linux shell scripts, SQL.• Spotlight, Toad, PL/SQL Developer, SQL*Plus, asmcmd, dgmgrl, lsnrctl, bash.

Moscow, Ru

Responsibilities:Linux OS RHEL installation and configuration on x86/x86_64 platforms and virtualization systems. Oracle Databases on OS Linux/Windows installation, configuration, upgrade and maintenance. Linux/Windows servers with ETL processes between many databases and plain-text files maintenance. Weblogic Servers maintenance and upgrade. Shell scripts development for instance availability check and customers sms-mailing. Linux RHEL ntp/samba/crontab services configuration.Technologies:• Oracle Database 11g/10g/9i, Oracle Enterprise Manger, Weblogic Server 10.3.5/10.3.6.• Linux OS RHEL (4.8/ 5.4,5.8,5.9 /6.3,6.4) and Windows 2008/2003 on x86/x86-64 platforms and VMWare/VirtualBox virtualization systems. • RMAN, OPatch. Linux shell scripts, SQL. PL/SQL Developer, SQL*Plus, lsnrctl, bash.

Kyiv, Ua

Projects:• Oracle Integration Project: Installed, configured and supported operation systems, databases and application systems for large migration project (Sep 2013). Developed ETL software (Apr 2012). For Mobile TeleSystems OJSC (MTS) company.• Support Projects: DB + BI. For MTS and Sitronics IT companies.• Support Project: DB + OTM + BI + ODI. For OJSC Mining and Metallurgical Company "Norilsk Nickel" (www.nornik.ru/en/). Responsibilities:Linux RHEL installation and configuration. Oracle Databases 11gR2 on Linux RHEL and on Windows Servers installation and upgrade. Oracle RUEI installation and upgrade. Weblogic Servers & SOA Suite on Linux RHEL, Windows Servers installation, configuration and maintenance. Creation, configuration and testing of Weblogic domains with server clusterization and migration (SOA and JMS servers). DB+OTM+BI+ODI Installation, configuration and maintenance. BI and OTM support projects (three different projects).Technologies:• Linux RHEL5 (5.4, 5.7, 5.8) on x86/x86_64 platforms. Windows Server 2008.• Oracle Database 11gR2 (12.2.0.1 - 12.2.0.3), OPatch. Oracle RUEI 12.1.0.1-12.1.0.3• Weblogic Server 10.3.5/10.3.6, SOA Suite 11.1.1.5/11.1.1.6• Oracle Transportation Management OTM 6.2 + Oracle Data Integrator 11 + Oracle Business Intelligence 11/10.

Kyiv, Ua

Projects:• Oracle Integration Project: Developed ETL software. For Mobile TeleSystems OJSC (MTS) company.• Siebel CRM Deployment Project: Developed useful reporting forms for Sberbank company (Dec 2011).Responsibilities:ETL development for migration from MS-SQL to Oracle RDBMS. Excel and .csv load into Oracle RDBMS packages development. Data load, data check, data update packages development. Development of the Reporting on Siebel CRM. Patterns creation (XML). Technologies:• ODI, PL/SQL, SQL, SQL*Loader, Linux shell scripts. • Siebel CRM, Oracle Answers, Oracle BI Administration Tool, Oracle BI, Oracle BI Publisher, Oracle BI Publisher Desktop, Siebel Tools, XML.

Responsibilities:Oracle Database 11g/10g on Windows/ Linux/ Virtualization systems installation, patching and support for client organisations. Documentation development. Make solutions presentations to staff and to clients. General database and IT consultancy. “Redmine” Project Management System installation and maintenance for the company.Technologies:• Linux RHEL4 x86/x86_64, Windows 2003/2008 x64 Server, Virtual Box, VMWare.• Oracle DB 11gR2/10g, Oracle 11g Client (11.2.0.1.2 ODT with ODAC).

Kyiv, Ua

Security and general network audit. Distributed WAN and LAN design, implementation and support on best practices for customers projects. Development of pre- and post-sales documentation. Work directly with customers in pre-sales situations. Work effectively across functions with other Sitronics employees in sales, marketing, proposals, project management and development areas. Customer consultancy and presentations. Main successful projects:• GAZPROM, http://www.gazprom.com/. Customer consultancy. Complex Information Security System solution development for one of the Branch Offices. Access Management and Data Integrity Provisioning Subsystems design (CSA+NAC+ACS) . Registration and Accounting Subsystems design (CSM+MARS+LMS). Pre-sales documentation development.• VTB, http://www.vtb.com/. Distributed Main Office & Branch Offices solution design (IPSec over GRE + OSPF/EIGRP). Pre-sales documentation development. Presentations for customer.• TS-Retail Company, Mobile TeleSystems OJSC ("MTS") Company’s branch (http://www.mtsgsm.com/). Security and general network audit. Customer consultancy. Corporate WAN, LAN solution design, implementation and support. Project documentation development. • Eurochem, http://www.eurochem.ru/. Network Data Center module modernisation. Solution design and documentation development.

Design and implement secure network infrastructure enhancements and solutions. Projects pre- and post-sales documentation development. Networks security audits and risk analysis. Consultations for clients. Solution presentations. Make presentations and consultations to our clients.Main successful projects for:• SOGAZ company, http://en.sogaz.ru/. Customer consultancy. Solution Design. Pre-sales documentation development.• INNOTERRA, http://www.infrus.ru/innoterra.html. Solution Design. Pre-sales documentation development.• STOLICHNYE APTEKI, http://www.citypharm.ru/. Security and general network audit, risk analysis. General network and security consultancy. Corporate LAN solution design, implementation and support. Documentation development.• Gadzhet-servis, http://www.spr.ru/. Pre-sales documentation development.

Москва, Ru

Secure Network (LAN, WAN) projects implementation for client organizations. Projects documentation development. Study, design, implementation and support new Cisco Network solutions. Provide interactive presentations to staff and customers. Provide configuration and support manuals to colleagues and customers. Successfully interact with customer management, providing presentations and client’s consultancy.Main successful projects:• EuroChem Company Main Office (http://www.eurochem.ru/). Corporate LAN and WAN installation. • EuroChem Company Branch-Office (Nevinnomyski Azoth) (http://www.eurochem.ru). Corporate LAN and WAN solution design and implementation.• OJSC VimpelCom Company (http://about.beeline.ru/en/). Secure Branch Office network implementation. • Moscow Financial Academy (http://en.fa.ru/). Corporate LAN design and implementation.

Oracle RDBMS design, development and administration. Software development. Problem solving and general database consultancy. In particular:• Client-Server Data Warehouse solution plan, design, implementation and maintenance on Oracle 9i Server, Oracle HTTP Server. • Oracle 8i,9i Server/clients (Windows) and Oracle HTTP Server installation, performance tuning and maintenance.• Linux Slackware Server administration. Apache Server and DNS tuning. Installation and tuning MySQL, PHP and SSL software modules.• External DB import. Reporting web-application software development for retrieving database information by multiple criterias (HTML, PL/SQL, PHP).• Providing regular iSQL*Plus HTML reports• Development PHP, MySQL, SSL based news portal for the web site • Windows LAN Administration (1 Win2kServer controller to 20 Win2kPro/Win98/WinMe clients).• Company’s web site maintenance based on HTML, Flash5, Photoshop, Corel.

LAN administration, software design, development and documentation.In particular:• Sub LAN Administration (10 Win2kPro/Win98/WinMe clients).• Detection devices software development on C++.• Conducting research into seismic processes. Design and development of the software to collect, analyze and interpret seismic signals on C++ and Fortran.

Oracle Database 10G: Backup And Recovery

Master'S Degree, Information Protection Technology

Courses Of Speaking English