Location
UkraineRate
Years of experience
20+About
With over 20 years of experience in managing large OLTP and DWH systems across various operating systems, including high availability configurations like DG and RAC, I have developed a strong foundation in both team and project management. My work involves coordinating multi-national teams and collaborating with different groups both on customer sites and within the company. I have successfully participated in large distributed projects focused on building DWH or OLTP systems and integrating solutions with stringent requirements for response time and throughput. One of my notable achievements includes creating a new paradigm for time series data, significantly saving space and solving performance issues related to high data volumes during recalculations. I have also architected and developed a data mart for audit data aggregation and designed an ETL framework for web-server data transformation. My technical skills encompass working with various RDBMS, DBA operations, and development using PL/SQL, SQL, shell, Python, and Ruby. Additionally, I have led the development and management of a two-shift DBA team and implemented a managed framework for loading feeds from external systems and their subsequent processing.Tech Stack
Oracle, Bash, C++, Linux, MySQL, PHP, PL/SQL, PostgreSQL, Python, Ruby on Rails, SQL Server, WebLogicExperience
- Overseeing the operation of large online transaction processing (OLTP) and data warehouse (DWH) systems across multiple operating systems, ensuring high availability and performance.
- Leading and coordinating multi-national teams, ensuring effective collaboration between different groups on customer sites and within the company.
- Implementing high availability configurations such as Oracle Data Guard (DG) and Real Application Clusters (RAC) to ensure continuous operation and disaster recovery.
- Creating a new paradigm for time series data that significantly saves space and resolves performance issues related to high data volumes.
- Designing and developing infrastructure and architecture for data integration projects, consolidating data from various applications for reporting and regulatory compliance.
- Building and managing teams of highly skilled Database Administrators, organizing their workflow, and managing small to medium-sized data warehouse-related projects.
- Creating ETL frameworks for loading and transforming data from web servers, ensuring efficient data processing and integration.
Employment history
- Managing the administration of Oracle and PostgreSQL databases, ensuring high availability, performance, and security.
- Leading projects for migrating company databases and applications to AWS, ensuring seamless transitions and optimization of cloud infrastructure.
- Managing company projects, coordinating between teams, and ensuring successful project delivery and collaboration across the organization.
- Designing and developing DeltaXE application, working with performance issues and supporting specific customer installations. Consulting customers with regards to system architecture and setup.
- Performing new DeltaXE installations including installation of Oracle Database, Oracle WebLogic Server, Oracle BPM and Oracle Service Bus for Middleware stack of DeltaXE application, Oracle Cloud Control 12c. Setting up HA configurations for DeltaXE including Data Guard setup for databases, clustered setup for middleware and RAC installations for specific cases.
- Designing and creating integration solution for banking sector using Oracle databases, IBM WTX, IBM Integration Bus, IBM WebSphere MQ, Informatica Power Center, Oracle R Distribution, ORE, and Oracle Advanced Analytics.
- PL/SQL development and creation of small workflow transformation engine within the scope of project.
- Managing the installation, configuration, and administration of Oracle databases for OLTP and DSS systems, ensuring high performance and availability.
- Conducting performance tuning, analysis, and reporting to optimize database performance and support business applications.
- Leading and coordinating a team of Oracle DBAs, prioritizing tasks, providing technical leadership, and ensuring effective team operations.
- Coordinating and managing application support teams across multiple areas, including Business Objects, Power Center, and Hyperion, ensuring smooth project execution.
- Working directly with architecture and engineering teams to design and implement solutions, ensuring alignment with business objectives.
- Leading offshore support teams, coordinating activities, and ensuring effective communication and collaboration to achieve project goals.
- Senior Oracle 8i-11gR2 DBA: installation, configuration, system and database administration for OLTP and DSS database systems. Backup and recovery strategy and implementation. Shell scripting.
- Performance tuning analysis, and reporting.
- Oracle Data Guard and Oracle RAC implementation and configuration: high availability, performance and disaster recovery strategy and operation for Oracle databases.
- Offshore Oracle Team leader: tasks prioritization, dispatching and following up, coordination, technical leadership, process awareness and monitoring, team support and management.
- Installation, configuration, system and database administration for OLTP and DSS database systems. Backup and recovery. Shell scripting. Performance tuning analysis and monitoring.
- Oracle database system support, release deployment, project participation.
- Installation, configuration, system and database administration for OLTP and DSS database systems. Backup and recovery. Shell scripting. Performance tuning analysis.
- Team management, Oracle database system support.
- Oracle DBA support tasks including on-call service.
- Web-based software development for the US market – Oracle, Java, JSP, PL/SQL.
- Application development. Deploying to test environments. Oracle Database Server administration.
- E-commerce web-based software development for the US market – PHP, Perl, JSP, MySQL, PostgreSQL, Firebird and Oracle.
- Application development. Testing. Deployment. Database administration.
- Web-based software development for a US customer – PHP, Perl and PostgreSQL server.
- Application development. Testing. Deployment. PostgreSQL server administration.
- Administering Oracle 7-8 databases, including system design, architecture, and management, to support city information systems.
- Developing web-based software applications using PHP, Perl, and PostgreSQL, ensuring efficient and reliable information dissemination.
- Testing, deploying, and providing ongoing support for software applications, ensuring they meet user requirements and operate efficiently.
- Designing and developing information systems using Oracle 7-8 and Visual Basic, ensuring robust and efficient data management solutions.
- Administering Oracle databases, including installation, configuration, and maintenance, to support business operations and data integrity.
- Managing the migration of information systems, deploying solutions, and providing support for seamless transitions and ongoing operations.
- Designing, developing, and implementing software applications using Interbase server, Delphi, and Oracle 7 to meet business needs.
- Managing the migration of databases from Interbase to Oracle, ensuring smooth transitions and maintaining database integrity and performance.
- Testing, deploying, and providing ongoing production support for applications, ensuring they operate efficiently and meet user requirements.
Education history