Jakub Szepietowski
Oracle Consultant
Experience
Dec 2017 - Apr 2024
6 years 5 monthsFrankfurt, Germany
Oracle Consultant
Airline Sector
- Environment: Oracle 11g/12c/19c (over 1TB; over 100 databases), Linux, RAC, Data Guard
- Microsoft Azure: design, sizing and capacity analysis including PoC
- Microsoft Azure: final implementation for migration from on-prem RAC to single instance Data Guard environment
- Performance tuning and troubleshooting for crew management systems (pilots/briefings)
- Design and implementation of a DR-aware system using RAC Extended Cluster and Data Guard
- OEM: Oracle Cloud Control maintenance – installation and upgrades from 12.1.0.5 to 13.3 and 13.5
- OEM: creating agent golden images with new RUs and security fixes for full-scale environments
- OEM agent upgrades
- OEM: developing custom metric extensions and reports
- OEM: full monitoring setup with template collections and monitoring templates plus incident rule configuration based on target lifecycle
- Upgrades of Grid Infrastructure from 11.2.0.4 to 12.1.0.2, then to 18.4 and 19.6+
- Upgrades of databases from 11.2.0.2 to 12.1.0.2 and then to 19.18+
- Redesign and license optimization using Oracle SE on ODA and DBVisit
- Designing a virtualized platform with OLVM (Oracle Linux Virtualization Manager – KVM) and license optimization via hard partitioning
- Migration of databases from Bare Metal to OLVM
Jan 2016 - Jun 2025
9 years 6 monthsFrankfurt, Germany
DBA, Oracle Consultant, Exadata SME for EMEA, Primary DBA for SEPA (Single Euro Payment Area Database)
Banking Sector
- Environment: Oracle 11g/12c/18c/19c (over 100TB; over 10,000 databases), Linux/Solaris, RAC, Data Guard, X5–X9 Exadata Multi-Rack
- Exadata full-stack patching: compute nodes, storage cells, InfiniBand switches
- Exadata maintenance and storage reorganization at cell/grid/ASM levels for production/UAT/dev clusters
- OCI Cloud: architecture planning for migration to ExaCC (Exadata@Customer), one of the largest private clouds globally
- OCI Cloud: onboarding new virtualized Exadata (with and without node subsetting)
- Consulting on engineered systems, RAC, backup and restore, tuning, capacity planning
- Migrations: using Data Pump and Data Guard standby switchover with minimal downtime, TTS with endian conversion and image copies on external storage
- Upgrades: Oracle database from 11+ to 19c, Grid Infrastructure to 18c and 19c
- Onboarding four Exadata X7–8 and one X7–8 full rack plus ZFS backup infrastructure for two DCs for SEPA
- Deep-dive performance tuning and troubleshooting for critical OLTP/DWH databases (Exadata, RAC, Data Guard, ASM, ZFS) using AWR/ASH/Snapper/OEM, 10046/10053 traces, oradebug, and fixes via SQL profiles, baselines, hints, etc.
- Consolidation on full rack X6–2: initial storage reconfiguration, patching to Exadata image 18.1.4, GI upgrade to 18c, IORM implementation based on app team requirements
- Endurance testing with SLOB (Project Treasury)
- Project technical lead and outage escalation
- Third-level support (Global Oracle)
- Technical lead for bank-wide 19c certification project and onboarding new Exadata
Aug 2015 - Dec 2015
5 monthsBraunschweig, Germany
DBA, Oracle CloudControl Consultant
Volkswagen Financial Services AG
- Environment: Oracle 10g/11g/12c (over 5TB; over 2000 databases), Linux, RAC, failover DB, Cloud Control, IBM TEC (Tivoli Enterprise Console)
- Migrating monitoring from IBM TEC to Oracle Cloud Control 12c
- Building monitoring templates for databases, clusters, hosts, WebLogic and OIM targets
- Developing custom metric extensions (agent-side and repository-side) to extend Oracle monitoring
- Creating reports from ME data and Cloud Control target metadata
- Setting up incidents and notification rules
- Tracking performance degradation with AWR Warehouse and repository metrics (buffer gets)
- Auto-detecting DB config issues like high redolog switches, log file sizing, undo problems in clusters, failover DB monitored by wrong agent
- Converting shell scripts to OEM format
- Writing documentation in Confluence
- Troubleshooting and performance tuning (SQL, instance, storage) for test/QS/production DBs
- Integrating HP BSM with OEM via connector
Jun 2013 - Jul 2015
2 years 2 monthsNuremberg, Germany
DBA, Oracle Consultant
Datev eG
- Environment: Oracle 11g/12c (over 2TB), Linux/AIX/Windows, RAC, Data Guard, Grid/Cloud Control, Oracle VM
- Validating enterprise backup and restore strategies
- Building and installing a highly available setup for mission-critical OLTP DBs (RAC + Data Guard with client failover)
- Consulting on Real Application Testing, engineered systems (Exadata, ODA/OVCA), and automatic parallelism
- Writing company-wide procedures for Oracle installs and admin per best practices (orachk tool)
- Collecting prerequisites, coordinating and running PoCs: OVM as HA and consolidated platform (IaaS, DaaS) with chargeback reporting and Cloud Control integration for role-based separation
- Troubleshooting and performance tuning (SQL, instance, storage) in test/QS/production DBs
- Data modeling with Rational Rose Model Integrator, MID Innovator, Embarcadero DB Change Manager and ER Studio Data Architect
- Third-level support for local Oracle DBA team
- Technical project management
Jun 2011 - May 2013
2 yearsKraków, Poland
DBA, Oracle Consultant for ProActive System Management
Opitz Consulting
- Environment: large corporate systems on Oracle 9i/10g/11g (over 10TB), ASM, Linux/HP-UX/AIX/Windows, RAC, Data Guard, Grid Control, E-Business Suite, WebLogic, Oracle VM
- Daily Oracle DBA tasks via ticket system
- Backup, restore and DR procedures
- Regular production clones for dev and testing
- Designing, installing, configuring, administering and troubleshooting Oracle systems for production and dev
- Designing and implementing HA and replication for Oracle systems (RAC, Data Guard/standby, GoldenGate)
- Troubleshooting and performance tuning in multi-tier environments (RDBMS to storage) using STATSPACK, AWR, Snapper, supporting Oracle developers
- Engineering and documenting new solutions with latest Oracle tech (Exadata, Flash Cache/Cards)
- DB patch regression tests and installs
- Technical project management
- Third-level support and DBA coaching
Jun 2010 - Jun 2011
1 year 1 monthKraków, Poland
Junior DBA, Junior Consultant in Service Engineering Department
Opitz Consulting
- Environment: Oracle 10g/11g, ASM, Linux, RAC, Data Guard, Unix systems
- Daily Oracle DBA tasks
- Backup and recovery with RMAN
- Maintenance and documentation
- Installing, configuring, administering and troubleshooting Oracle DBs and Grid Control in production and dev
- Setting up small prod/test RAC/Data Guard environments
- LAN/WAN administration
- Translating German docs
Jan 2007 - Mar 2008
1 year 3 monthsKraków, Poland
RemoteHelp Desk Consultant
Telekomunikacja Polska SA
- Customer service
- Remote supervision and administration of client PCs and servers
- Creating electronic documentation
- LAN/WAN administration
- Remote maintenance
Summary
- Supported Oracle Versions: 9i/10g/11g/12c/19c Oracle 23c Beta Tester
- Supported Operating Systems: Linux (OEL, RedHat, SuSE), Unix (Solaris, HP-UX, IBM AIX), Windows
- Supported Engineered Systems: Exadata from X4 up to the latest X9, ZFS Storage
- Supported Middleware: GoldenGate 10/11
- Administration: daily database administration (Single Instance, Real Application Clusters RAC, Data Guard DG), creating backup strategies with RMAN, installing and configuring databases according to best practices, patching and upgrades, troubleshooting, Linux OS and network administration, implementing monitoring solutions (GridControl, Nagios, custom scripts)
- Cloud Environment: Oracle Cloud Infrastructure (OCI), Microsoft Azure – design, capacity planning, implementation, licensing
- Migration/Upgrade/Replication: planning migrations, using Data Guard, Data Pump Transportable Tablespaces or GoldenGate
- Integration and Testing: network layer, databases (back end), operating systems, volume managers, storage layer, implementation and testing with Oracle Real Application Testing or tools like Quest Benchmark Factory, Swingbench, etc.
- Performance Tuning: solving performance issues across database and storage layers, tuning Oracle instances and SQL, Oracle optimizer (CBO) considerations
- Architecture: designing, testing and implementing high availability solutions based on RAC, Data Guard and Oracle Virtual Machine OVM/OLVM (KVM-based)
Languages
Polish
NativeGerman
AdvancedEnglish
Advanced Education
Oct 2007 - Jun 2010
Jagiellonian University
Master’s, Performance Tuning of Oracle 9i RDBMS · Faculty of Physics, Astronomy and Applied Computer Science · Kraków, Poland
Oct 2003 - Jun 2007
The State School of Higher Professional Education in Elblag
Computer Science Engineer · Institute of Applied Informatics · Elbląg, Poland
Certifications & licenses
Oracle AI Vector Search Certified Professional
Oracle
Oracle Cloud Infrastructure 2023 Architect Professional
Oracle
Oracle Autonomous Database Cloud 2019 Specialist
Oracle
Oracle Cloud Infrastructure Foundations 2020 Associate
Oracle
Oracle Certified Master 11g
Oracle
Oracle GoldenGate 10 Certified Implementation Specialist
Oracle
Oracle Exadata 11g Certified Implementation Specialist
Oracle
Oracle Certified Professional, Oracle 11g
Oracle
Red Hat Certified Technician Red Hat 5
Red Hat
Red Hat Certified System Administrator
Red Hat
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.