Qpharma is a large company which does software and services support for life pharma sciences. Working directly with the customer.𝐐𝐩𝐡𝐚𝐫𝐦𝐚 - 𝐃𝐁𝐀 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐎𝐟𝐟𝐬𝐭𝐚𝐟𝐟 𝐟𝐮𝐥𝐥 𝐭𝐢𝐦𝐞 𝐃𝐁𝐀• Covering all Oracle support tasks for an IT company with 20+ developers. Code review, help developers with writing optimal SQL and PL/SQL code.• Oracle 12c-21c• High loaded OLTP and warehouse oracle database (4TB data size)• PL/SQL development, PL/SQL optimization to processing a large volume of data• SQL, PL/SQL performance optimization and tuning: manual execution plan optimization, AWR, OEL tools (tuning advisor, monitor), ASH for Oracle enterprise and standard edition• Large data load scripts (Powershell, SqlLoader, Talend, etc) - (700-1200 GB of data load every day into single Oracle database from different sources)• Data move (tables, schemas, databases), data backup and restore (datapump)• Automatic refresh database for developers, QA.• Partitioning, table compression optimization• Use of the oracle build-in UTL_HTTP to automatically push large data to foreign REST API. Work with JSON oracle object• Automatic historical data management - export from Oracle, zip and save to AWS S3 Athena CSV database (100Gb data per day)• Using UTL_SMTP for database alerts, database scheduler• Oracle internal Audit, Custom automatic audit for DML, DDL changes• Scripting: Powershell, Lambda scripts, Bash, sh.• MS Sql, Postgre, Athena, Glue, MySql, etc - basic DBA support tasks• Migration to AWS RDS cloud database for cost saving. 𝐌𝐢𝐠𝐫𝐚𝐭𝐢𝐨𝐧 𝐨𝐟 𝐎𝐫𝐚𝐜𝐥𝐞 𝐝𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐭𝐨 𝐀𝐦𝐚𝐳𝐨𝐧 𝐜𝐥𝐨𝐮𝐝.• Bi-directional data replication to allow migration without downtime.- Oracle data replication (streams), Oracle GoldenGate 𝐂𝐫𝐞𝐚𝐭𝐞 𝐡𝐢𝐠𝐡 𝐚𝐯𝐚𝐢𝐥𝐚𝐛𝐢𝐥𝐢𝐭𝐲 𝐬𝐲𝐬𝐭𝐞𝐦 𝐨𝐧 𝐀𝐖𝐒 𝐜𝐥𝐨𝐮𝐝• High Availability configuration with Oracle Data Guard, Separate servers in different AWS regions, automatic database failover

Team lead, database architecture and design, pl/sql developerDevelop a new large module for existing Oracle APEX application for external customers questionnaire.• Oracle APEX forms• Dynamic manual action in APEX• DML and DDL Audit using triggers (automatic triggers changes after each DDL)• JSON in database table optimization.• Coordination of three team members

Architecture and developing database structure for a large government project in Saudi Arabia.• Management of three people in data team, Support Java team with 30+ developers and Devops team• Data migration, huge data volume data transformation from MSSQL into Oracle using Talend.• Flyway, GitLab CI/D database integration for full automatic deployment process• SQL tuning and optimization

Database consolidation project for the cellular operator. Analyzing, moving, and consolidating production databases to reduce licensing cost for more than 250Oracle databases.• develop script to automatically collect information about databases using AWR historical data, historical v$ views, ets.• Move databases between RAC. Move schemas

𝐇𝐢𝐠𝐡 𝐥𝐨𝐚𝐝𝐞𝐝 𝐰𝐞𝐛 𝐩𝐨𝐫𝐭𝐚𝐥 𝐰𝐢𝐭𝐡 𝐛𝐚𝐜𝐤𝐞𝐧𝐝 𝐥𝐨𝐜𝐚𝐭𝐞𝐝 𝐨𝐧 𝐎𝐫𝐚𝐜𝐥𝐞 𝐏𝐋/𝐒𝐐𝐋Responsible for database architecture, backend development, Oracle setup and support.PL/SQL development, team management (5 team members).• Three distributed always-online, always in read-write mode data centers• WWW traffic load balancing. Project High availability (99.9% uptime), optimizing for OLTP usage.• Total web traffic on production was over 800 megabits/sec, near million unique web users per day. Eight Java servers in two Java clusters.• Progressive PL/SQL programming (Application layer located on PL/SQL), Oracle Object types, OOP in PL/SQL• Data size more than 2Tb in OLTP database• Storage systems with high availability configuration (FC), Oracle ASM• Two Oracle 11g RAC with five nodes each• Oracle stream replication for 99.9% DB uptime, between three oracle databases• Read-only database replica for reporting and Audit logs data• Oracle performance tuning, large data loading, , SQLPlus scripting• Partitioning, compression, working with BLOB data• Non-stop database changes deployment with Oracle edition-based redefinition• Data migration from Large MS Sql to Oracle• Data exchange with non-oracle databases.• Detailed performance tuning using bulk operations and PL/SQL memory arrays• Asynchronous DML audit to another database using oracle streams replication.Environment and Tools:• Oracle 11g, Oracle RAC, ASM, EM, SQL, PL/SQL, High availability, Streams replication, RMAN, Flashback, Partitioning, Edition-based redefinition, SQL Louder, expdp/impdp. OEL6, OEL7.

Help in preparing HA (high availability) database in different Ukrainian regions, DBA Support.Oracle 9.2, 10g, 11, Oracle Streams, Linux SLES, Bash scripting, RMAN backup system.

Mostly as team manager, sometime as developer.Various small and medium projects.𝐎𝐧𝐥𝐢𝐧𝐞 𝐝𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐟𝐨𝐫 𝐔𝐒𝐀 𝐋𝐢𝐜𝐞𝐧𝐬𝐞𝐬 𝐢𝐧𝐟𝐨𝐫𝐦𝐚𝐭𝐢𝐨𝐧.• Environment and Tools: COM/COM+/MTS/JavaScript/MS VisualBasic/ASP/XML/XSL.𝐎𝐧𝐥𝐢𝐧𝐞 𝐭𝐢𝐜𝐤𝐞𝐭𝐬 𝐚𝐠𝐞𝐧𝐜𝐲.• Environment and Tools: PHP, XML, HTML, JavaScript, Test Track, Vss.𝐒𝐲𝐬𝐭𝐞𝐦 𝐟𝐨𝐫 𝐭𝐫𝐚𝐜𝐤𝐢𝐧𝐠 𝐦𝐨𝐯𝐞𝐦𝐞𝐧𝐭𝐬 𝐚𝐧𝐝 𝐚𝐜𝐭𝐢𝐯𝐢𝐭𝐢𝐞𝐬 𝐨𝐟 𝐫𝐨𝐚𝐝 𝐬𝐰𝐞𝐞𝐩𝐞𝐫𝐬.• Data import from GPS hardware. Pre-processing of data, import into the database (MySQL). Data optimization and approximation. Advanced reports and statistics module. Visualization of city plan using Map Objects.𝐆𝐫𝐚𝐩𝐡𝐢𝐜𝐚𝐥 𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐫𝐚𝐜𝐤 𝐭𝐨𝐮𝐫𝐬, 𝐜𝐨𝐦𝐩𝐥𝐞𝐱 𝐬𝐞𝐚𝐫𝐜𝐡/𝐯𝐢𝐞𝐰 𝐦𝐨𝐝𝐮𝐥𝐞𝐬.• Environment and Tools: Borland Delphi, MySQL, Map Object LT, Rave Reports, Shape Lib, Virtual Tree, Zeos Database Objects, JEDI JCL/JVCL.𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐩𝐥𝐮𝐠-𝐢𝐧𝐬 𝐟𝐨𝐫 𝐝𝐢𝐠𝐢𝐭𝐚𝐥 𝐩𝐡𝐨𝐭𝐨 𝐬𝐨𝐟𝐭𝐰𝐚𝐫𝐞• Plugin to allow creating album layouts and uploading photos. Creation and management of albums, adding/managing photos and text notes. Editing photos with a built-in image editor. Albums publication.• Environment and Tools: Borland Delphi7, Virtual Shall, XML

𝐃𝐞𝐬𝐢𝐠𝐧 𝐚𝐧𝐝 𝐝𝐞𝐯𝐞𝐥𝐨𝐩 𝐈𝐒𝐏 𝐚𝐜𝐜𝐨𝐮𝐧𝐭𝐢𝐧𝐠 𝐚𝐧𝐝 𝐛𝐢𝐥𝐥𝐢𝐧𝐠 𝐬𝐲𝐬𝐭𝐞𝐦.Setup and support of Oracle database.● Billing system for the largest Internet Service Provider (ISP) Company in the West Ukraine. Activities included: clients tracking, traffic accounting, payment managements, billing, office support, user accounting, authentication, reports, web support etc.● Performance tuning● Three team membersSystem description:● Oracle 7.3-10 DB, Suse Linux Enterprise server (SLES)● Delphi (Pascal) as main development tool● Large database (370GB) with tables up to 13 billion rows. Partitioning.● Scripts to collect information about clients and traffic statistics from more than 40 independent UNIX and Cisco routers (netflow protocol)● High availability with hardware RAID, RMAN backup.● Unix and network administration (FreeBSD, Linux: mail, squid, Apache, Net Graph, Mrtg)● Users portal on Oracle mod_plsql web, JavaScript, CGI, PHP, Perl● Linux, FreeBSD scripting (sh scripts, C/C++, Perl, SSH secure-tunneling)