Location
UkraineRate
$12
/ per hour
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
Senior Oracle DBA Team Lead, PAF
May 2018 – Present
- 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.
Senior Oracle DBA, Powel Poland
March 2016 – April 2018
- 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.
Senior Oracle DWH Engineer, Infopulse
February 2015 – February 2016
- 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.
Senior Oracle Developer/Architect, Luxoft UA
February 2014 – August 2014
- 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.
Product Coordinator, IBM GSDC Polska
April 2012 – October 2013
- 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.
Oracle DBA Team Leader, Infopulse
February 2008 – March 2012
- 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.
Oracle DBA, Luxoft UA
June 2006 – January 2008
- 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.
Oracle DBA Team Leader, SoftServe
October 2004 – June 2006
- 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.
System Administrator and Developer, Unitech
June 2004 – September 2004
- Web-based software development for the US market – Oracle, Java, JSP, PL/SQL.
- Application development. Deploying to test environments. Oracle Database Server administration.
System Administrator and Developer, Program-Ace
June 2003 – June 2004
- E-commerce web-based software development for the US market – PHP, Perl, JSP, MySQL, PostgreSQL, Firebird and Oracle.
- Application development. Testing. Deployment. Database administration.
System Administrator and Developer, Freelance for a US customer
April 2002 – May 2003
- Web-based software development for a US customer – PHP, Perl and PostgreSQL server.
- Application development. Testing. Deployment. PostgreSQL server administration.
System Administrator and Developer, City Information Center
March 2001 – March 2002
- 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.
System Administrator and Developer, Regional Business Assistance Center
August 2000 – March 2001
- 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.
System Administrator and Developer, UkrPromSnab
September 1996 – July 1999
- 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
Kharkiv State Technical University of Radioelectronics
1991 - 1996
Master in Computer Science
Borlas Ukraine
2006
Data Warehouse Administration (course)
Alcatel Network System - Ukraine
2000 - 2001
Introduction to GSM (course)
Kharkiv Polytechnic University
2000
UNIX Administration (course)
We've delighted 83 clients with our IT recruitment and software development services.
Read about a few of them below...