Database Administration Oracle
Resume:
Pavlo Bohush
Boca Raton, Florida, United States, 33433
*****.******@*****.***
linkedin.com/in/pavlo-bohush-ba797960/
Summary
More than 18 years of extensive experience in IT industry focusing on Oracle Database Management and Administration as Database Manager, DBA Lead, and Sr. DBA/DevOps
15+ years of experience in Oracle Database Administration.
6+ years of experience in PostgreSQL.
2+ years of experience as DevOps.
Hands-on managing database administration duties and tasks focusing on supporting large-scale Oracle and PostgreSQL database systems.
Highly experienced in supporting, upgradation, migration, system maintenance, patching, providing user support and database security, troubleshooting database design, documentation, backup, and recovery.
Motivated and detail-oriented with unsurpassed abilities in teamwork and crafting high-quality database solutions. Multi-tasking and prioritizing competing deadlines.
Skills
Oracle Cloud • Google Cloud Platform (GCP) • Amazon Relational Database Service (RDS) • Database Administration • Oracle • DevOps • Data Migration • Linux System Administration • Database Design
Red Hat Linux • Oracle Golden Gate
Experience
Oracle DBA Manager
Pragmatic Play LLC
US (remote)
Jan 2024 - Present (7 months)
Comprehensive experience in high-level strategic planning and advanced systems architecture, including project management life cycle, team leadership, and data center migration with a specific focus on high availability, performance, and security compliance
Creating, modifying, and maintaining Oracle PL/SQL Stored Procedures, Table Partitions, Triggers
Packages, Tablespaces, and Indexes, maintaining Data Files, Control Files, and Redo Log Files
migration DBs from Oracle to PostgreSQL shard and migration to Cloud (Private Cloud and AWS)
Monitor and tune performance of Oracle databases and applications
Installed and configuration Oracle Connection Manager and Oracle Gateways
Capacity planning
Database design and architect
Lead Oracle DBA/DBRE/DevOps Engineer
Pragmatic Play LLC
Europe/US (hybrid)
Oct 2017 - Dec 2023 (6 years 3 months)
Support and administration of Oracle databases (OS: Linux; DB: Oracle: 11g, 12c, 19c)
patches and updates Oracle databases (CPU/PSU)
backup and restore Oracle databases (RMAN, Data Pump)
monitoring and performance tuning, OS-specific troubleshooting (Oracle Enterprise Manager GC, AWR, ADDM)
Supporting and administrating PostgreSQL databases, production, and test environments
installing, configuring, and updating PostgreSQL databases.
backup and restore PostgreSQL databases
performed performance tuning, query optimization, capacity planning, database server system design, performance and utilization monitoring, and schema optimizations for environments running PostgreSQL
migration DBs from Oracle to PostgreSQL shard and migration to Cloud (Private Cloud and AWS)
Automated deployments of Oracle/PostgreSQL in Amazon AWS (using Ansible, Chef, Terraform)
Working with AWS Cloud (RDS, EC2)
Configuring of Logical replication using Golden Gate
Configuration management using CI/CD (Ansible, Chef, Terraform)
Senior Oracle DBA/Ops Engineer
Jet Infosystems
Ukraine (onsite)
Apr 2015 - Oct 2017 (2 years 7 months)
Support and administration of Oracle databases (OS: Linux, Solaris, Windows, DB: Oracle 10g, 11g, 12c), production and test environments:
installations, configurations Oracle software (ASM, OHAS)
patches and updates Oracle databases (CPU/PSU)
backup and restore Oracle databases (RMAN, Data Pump, imp\exp)
monitoring and performance tuning, OS specific troubleshooting (Oracle Enterprise Manager Grid Control, AWR, ADDM)
migration and cross-platform migration databases
creation Physical and Logical Standby (Data Guard)
Automating tasks using shell scripts (bash, powershell)
Writing and testing Oracle databases Disaster Recovery Plans.
Configuring of Logical replication using Golden Gate
Working with Oracle Support (MOS).
Lead Oracle Database Administrator
OTP Bank
Ukraine (onsite)
Jun 2013 - Apr 2015 (1 year 11 months)
Support and daily maintenance of production databases in RAC and DataGuard configurations (OS: Linux, Solaris, Windows, DB: Oracle 10g, 11g):
installing and configuring Oracle software (ASM, OHAS)
patching and updating Oracle databases (CPU/PSU)
backup and restore Oracle databases (RMAN, Data Pump, exp/imp)
database migration (cross-server, cross-platform), cloning production databases to test\dev environments
creating and troubleshooting Physical and Logical Standby database servers
diagnosed and troubleshot database problems such as errors and bugs, performance problems, etc
Automating tasks using shell scripts
Supported and administration application servers (Oracle application server, Jboss, WebLogic)
Administration, monitoring, patch installation of Oracle Exadata X2
Writing and testing Oracle databases Disaster Recovery Plans
Working with Oracle Support (MOS and other Oracle Customer Support Companies)
Senior DB engineer (DBA)
Raiffeisen Bank Ukraine
Ukraine (onsite)
Oct 2009 - Jun 2013 (3 years 9 months)
Maintenance and administration of databases Direction (Oracle 11g, Sybase SQL Anywhere 9/10, ASE 15):
Oracle, Sybase software installations
patches and updates Databases
backup and restore Databases
monitoring and customization Databases replication, create Standby DB
monitoring and performance tuning of Databases servers
writing reports and queries to business
Support and administration of Branches databases (PostgreSQL 8.3);
Support users (Service Desk, L3)
System Software Engineer (DBA)
Apr 2008 - Oct 2009 (1 year 7 months)
Ukraine (onsite)
Support and administration of the Bank business day (OS: Red Hat Enterprise Linux 5, DB: Oracle 9i/10g):
Oracle software installation
patches and updates Databases.
backup and restore Databases (RMAN, impdp/expdp, imp/exp)
monitoring and customization databases replication
monitoring and performance tuning of databases servers
Administration OS Novell Netware 6.5
Administration Proxy server and VirusWall (OS: Red Hat Enterprise Linux 5)
Support Client-Bank system
supported another banking software
Education
Chernihiv Polytechnic National University, Master, Computer Systems and Networks 2000 - 2005
Contact this candidate