Developing and administering high-load cloud solutions for fintech database applications based on the PostgreSQL, Oracle and SQL Server: - High-availability PostgreSQL database clusters (Patroni, etcd), Oracle (DataGuard), MS SQL (Always On Availability Groups), MariaDB (binlog data replication) - Load balancing and database connection pooling (HAProxy, pgbouncer, keepalived) - Database backup, restore, and disaster and point-in-time recovery - Database cloning for test environments (pg_probackup, RMAN,..) - Database access management - PostgreSQL table partition management and automation (pg_partman) - Database monitoring, logging and audit (Prometheus, Grafana, Loki, native db tools) - Database performance tuning - Iac db server management (Ansible, Terraform), multi-environment database support (dev/test/stage/prod...) - Secret management (Hashicorp Vault) - Integrations between OLTP and DWH databases - Full range of other DBA tasks including related Linux and Windows OS management - OS administration (Centos Steam, Oracle Linux, Windows Server) as part of DBA tasks - Consulting support for application developers

Enterprise databases migration to Amazon Cloud: - migration of production databases of a terabyte level from on-premises to the AWS cloud - data replication in homogeneous and heterogeneous environments - database re-platforming and code refactoring between Oracle, PostgreSQL, MS SQL, DB2, MySQL, Amazon RDS/Aurora - SQL and PL/SQL development and performance tuning - code versioning and delivery of database code in DEV/QA/STAGE/PROD environments (including using Liquibase - deploying, tuning, and monitoring AWS RDS infrastructure - database backup and disaster recovery configurations - DBA technical leadership / supervision / code review

MySQL to PostgreSQL database migration of the federal network of medical centers mrtexpert.ru: - Migration planning - Database structure refactoring - Establishing crossplatform data replication - Disaster recovery configuration - Zero-downtime migration of DEV and PROD environments - Consulting support

Developing Oracle to Postgres database replication system for the Federal Employment Service of Russia in St. Petersburg. Duties: - system architecture and data structure design (PostgreSQL), - development of data replication system between Oracle and Postgres databases (pgPL/SQL) - implementing PostgreSQL data replication node in production environment with zero downtime

Projects: - Unified information system of the Housing Inspectorate of Moscow Goverment - Information Systems of Moscow Department of Natural Resources and Environmental Protection - Information System of Contact Center "COVID-19"Duties: - database architecture and data structure design (Oracle, PostgreSQL), - server-side application software development (SQL, PL/SQL, pgPL/SQL ) to automate business processes and document flow (inspection activities and administrative proceeding, housing control, ecology, safety of nature, waste utilization control) - Integration with Federal Services and State Web Portal - Executing typical DBA tasks (Oracle, Postgres), administering Oracle DataGuard, Oracle Fusion Middleware - Development and supporting service subsystems: Continuous integration, Excel reporting by Oracle PL/SQL, job scheduling, logging of changes and autocalculating of business data - Batch data processing, data migration from previous generation system - REST API development (ORDS) for integration with mobile applications and third party systems - Cloning and supporting databases for DEV and QA environments - Third line of customer support, DB department management

Project: Bank Data WarehouseDuties:- Data Warehouse support and software development- ETL process management, data processing (Oracle SQL, PL/SQL)- Bank balance reconciliation, incident analysis- Preparing data for Central Bank reporting

Projects: - St. Petersburg Civil Registration system for Housing Committee (housing records, civil registration, social rent) - Web Portal of St. Petersburg Housing CommitteeDuties:- system architecture and data structures design (Oracle)- server-side application software development (Oracle SQL, PL/SQL) that implements business logic- development of object-oriented framework (Oracle PL/SQL, PHP, HTML, JS, JQuery, Bootsrap) - front-end web interface implementation- development of internal administrative portal (Oracle PL/SQL, HTML, PHP, JS, JQuery, Bootsrap)- reporting, analytics, printed documents (Oracle SQL, PL/SQL, HTML,PDF)- data migration from the legacy systems (Oracle, MSSQL, DBF, etc.)- loading/unloading data and interaction with third party systems- web services development (PHP+Oracle PL/SQL)- loading and unloading data, interaction with third party systems (SOAP,XML,HTTP,DBF,CSV...)- automation of routine production operations- Oracle DBA tasks (installation, disk storage configuration, performance tuning, backup and recovery, standby database, managing security, monitoring- administration of Linux OS as part of DBA tasks

1. Senior Oracle DBA in St. Petersburg State Public Computing Center- DBA group management- performing all of Oracle 9/10/11 DBA tasks on HP-UX, Linux, Windows: installing, patching, version upgrade, performance tuning, interaction with Oracle Support, disk resource management, ASM, accsess control and user management, 24x7 monitoring using OEM- backup and recovery, Oracle Standby database, tape drive backups RMAN, HP DataProtector, switchover etc.- development and control of data replication system between analytic and OLTP nodes - data structure and PL/SQL code optimization, statistical analysis, index management, developer consulting- database cloning and creating testing environments for software development lifecycle- development of billing applications (SQL, PL/SQL)- batch data processing, creating reports, data loadind/unloadind2. Information system for the calculation of cash benefits for citizens of St. Petersburg (monthly housing and communal services payment compensation for over of one million citizens)- system architecture and data structures (Oracle EE 11.2)- development team management- design data flow processes and interaction with third-party systems (management companies, utility suppliers, government agencies)- application system software development (Oracle PL/SQL): collection and treatment of the initial data, loading and unloading data in the third-party systems, process control, delivery and reception of data with web portals, analytics, reports.- system implementation and production support (24x7)- Oracle DBA tasks (installing, configuration, performnance tuning, upgrade, backup and recovery, standby database, cloning

Projects: Online Document Archive of Sberbank of RussiaDuties:- development of Oracle SQL and PL/SQL report engine- creating fixed reports based on legacy data structures- reporting tool development for arbitrary reports with HTML interface- web-interface integrated into existing bank software (HTML,JS)

Projects: - Unified Information System of the Federal Employment Service in St. Petersburg.Duties:- architecture design and database structures- development server-side software (PL/SQL) implementing application functions- development of asynchronous data replication system for a distributed Oracle database- Oracle database administration, backup and recovery, performance tuning of the production system- development of client-side software (Delphi)- HP-UX, Linux, Windows administration under the DBA tasks- data migration, database cloning- development of propietary report system (Delphi, Oracle, MS Word,Excel)- expanding a distributed database by adding new nodes with zero downtime- training of the customer database administrators- production system support