Jakub Szepietowski

Oracle Consultant

Avatar placeholder
Kronberg im Taunus, Germany

Experience

Dec 2017 - Apr 2024
6 years 5 months

Oracle Consultant

Airline Sector

  • Microsoft Azure: design, shape, and capacity analysis including PoC
  • Microsoft Azure: final implementation for migration from on-prem RAC to single instance Data Guard
  • Performance tuning and troubleshooting for crew management systems (pilots and briefings)
  • Design and implementation of disaster recovery aware system based on RAC Extended Cluster and Data Guard
  • OEM: Oracle Cloud Control maintenance, installation and upgrades (12.1.0.5 > 13.3 > 13.5)
  • OEM: creating agent golden image with new RU and security fixes for full-scale environment
  • OEM agent upgrade
  • OEM: developing custom metric extensions and reports
  • OEM: full monitoring setup with template collection and monitoring templates and incident rule configuration
  • Upgrades: GI from 11.2.0.4 to 12.1.0.2, to 18.4, to 19.6+
  • Upgrades: databases from 11.2.0.2 to 12.1.0.2, to 19.18+
  • Redesign and license optimization based on Oracle SE on ODA and DBVisit
  • Design of virtualized platform based on OLVM and license optimization using hard partitioning
  • Migration of databases from bare metal to OLVM
Jan 2016 - Jun 2025
9 years 6 months

DBA, Oracle Consultant, Exadata SME for EMEA, Primary DBA for SEPA

Banking Sector

  • Exadata full stack patching including compute nodes, storage cells, and Infiniband switches to recent versions
  • Exadata maintenance and storage reorganization on cell, grid, and ASM levels for production, UAT, and dev clusters
  • OCI cloud: architecture planning for migration to ExaCC (Exadata@Customer), the biggest private cloud in Europe/world
  • OCI cloud: onboarding new virtualized Exadata (with and without node subsetting)
  • Consulting on engineered systems, RAC, backup and restore, tuning, and capacity planning
  • Migrations using Data Pump and Data Guard, standby switchover with minimal downtime, TTS with endianness conversion, and image copies on external storage
  • Upgrades: Oracle Database from 11+ to 19c; GI upgrades to 18 and 19c
  • Onboarding four Exadata X7-8 and one X7-8 full rack+ setup
  • ZFS backup infrastructure for both data centres for SEPA
  • Deep dive performance tuning and troubleshooting for mission-critical OLTP and DWH databases (Exadata, RAC, Data Guard, ASM, ZFS) using AWR/ASH/Snapper/OEM, traces, oradebug, and fixes via SQL Profiles, baselines, and hints
  • Consolidation of two projects on full rack X6-2, including storage reconfiguration, patching to newest Exadata image (18.1.4), GI upgrade to 18c, and IORM implementation based on requirements
  • Endurance testing with SLOB (Project Treasury)
  • Project technical lead and outage escalation
  • Third-level global Oracle support
  • Technical lead for bank-wide 19c certification project and onboarding new Exadata systems
Aug 2015 - Dec 2015
5 months

DBA, Oracle CloudControl Consultant

Volkswagen Financial Services AG

  • Monitoring migration from IBM TEC to Oracle Cloud Control 12c
  • Building monitoring templates for databases, clusters, hosts, WebLogic, and OIM targets
  • Building custom metric extensions (agent-site and repository-site) to extend Oracle monitoring capabilities
  • Creating reports based on ME data and Cloud Control target metadata
  • Creating incident and notification rules
  • Monitoring performance degradation over time with AWR Warehouse and repository metrics
  • Automatic identification of database configuration issues
  • Rewriting shell scripts to OEM format
  • Creating documentation in Confluence
  • Troubleshooting and performance tuning at SQL, instance, and storage levels for test, QS, and production databases
  • Integration of HP BSM with OEM through connector
Jun 2013 - Jul 2015
2 years 2 months

DBA, Oracle Consultant

Datev eG

  • Validation of enterprise backup and restore strategy
  • Creating and installing high availability environment for mission-critical OLTP databases (RAC and Data Guard, including client failover)
  • Consulting and support in real application testing, engineered systems like Exadata, ODA/OVCA, and automatic degree of parallelism
  • Creating company-wide procedure for installing and administering Oracle products according to best practices (orachk tool)
  • Coordinating and realizing PoC for OVM as high availability and consolidated platform with chargeback model and integration with Cloud Control
  • Troubleshooting and performance tuning at SQL, instance, and storage levels for test, QS, and production databases
  • 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 years

DBA, Oracle Consultant of ProActive System Management

OPITZ CONSULTING

  • Day-to-day Oracle DBA tasks (ticket system)
  • Backup, restore, and disaster recovery procedures
  • Regular clones of production systems for development and testing
  • Designing, installing, configuring, administering, and troubleshooting production and development Oracle-based systems
  • Designing and implementing high availability and replication concepts (RAC, Data Guard, standby systems, GoldenGate)
  • Troubleshooting and performance tuning in enterprise multi-tier environment using STATSPACK, AWR, and Snapper; supporting developers
  • Engineering and documenting new solutions based on newest Oracle technologies (Exadata, Flash Cache, cards)
  • DB patch regression tests and installations
  • Technical project management
  • Third-level support and coaching new DBAs
Jun 2010 - Jun 2011
1 year 1 month

Junior DBA, Junior Consultant of Service Engineering Department

OPITZ CONSULTING

  • Day-to-day Oracle DBA tasks
  • Backup and recovery with RMAN
  • Maintenance and documentation tasks
  • Installation, configuration, administration, and troubleshooting of production and development Oracle databases and Grid Control environments
  • Installation and configuration of small production and test RAC and Data Guard environments
  • Administering LAN and WAN environments
  • Translating German documentation
Jan 2007 - Mar 2008
1 year 3 months
Remote

Help Desk Consultant

Telekomunikacja Polska SA

  • Customer service
  • Supervising and remotely administering client computers and servers
  • Creating electronic documentation
  • Administering LAN and WAN environments
  • Remote maintenance

Skills

  • Supported Oracle Versions: 9i/10g/11g/12c/19c (Oracle Certified Master), Oracle 23c Beta Tester

  • Supported Operating Systems: Linux (Oel, Redhat, Suse) (Redhat Certified System Administrator), Unix (Solaris, Hp-ux, Ibm Aix), Windows

  • Supported Engineered Systems: Exadata From X4 Till The Latest X9 (Oracle Exadata Certified Implementation Specialists), Zfs Storage

  • Supported Middleware: Goldengate 10/11 (Oracle Goldengate 10 Certified Implementations Specialists)

  • Administration: Day-to-day Database Administration (Single Instance, Real Application Cluster Rac, Dataguard Dg), Creating A Backup Strategy Based On Rman, Installation And Configuration Of Databases According To Best Practices, Patching And Upgrades, Troubleshooting, Administration Of Linux Based Os And Networks, Implementation Of Monitoring Solutions (Gridcontrol, Nagios, Self-developed Scripts)

  • Cloud Environment: Oracle Cloud Infrastructure (Oci), Microsoft Azure, Design, Capacity Planning And Implementation, Licensing

  • Migration/upgrade/replication: Planning Of Migration Processes, Migrations With Dataguard, Datapump, Transportable Tablespaces Or Goldengate

  • Integration And Testing: Network Layer, (Back End) Databases, Operating Systems, Volume Managers, Storage Layer, Implementation And Testing Using Oracle Real Application Testing (Or Other Tools Like Quest Benchmark Factory, Swingbench Etc.)

  • Performance Tuning: Performance Problems Solving Spanning Database And Storage Layer, Oracle Instance And Sql Tuning, Oracle Optimizer Considerations (Cbo)

  • Architecture: Design, Testing And Implementation Of High Availability (Ha) Solutions Based On Rac, Data Guard And Oracle Virtual Machine Ovm/olvm (Kvm Based)

  • Ability Of Team Working Acquired In Different Conditions Of Education And Working

  • Ability Of Integration With Different Cultures Acquired During Working In The Usa, Canada And Germany

  • Practical Problem-solving Skills

  • Ability To Learn Fast

  • Self-disciplined

Languages

Polish
Native
German
Advanced
English
Advanced

Education

Oct 2007 - Jun 2010

Jagiellonian University (pol. Uniwersystet Jagielloński), Faculty of Physics, Astronomy and Applied Computer Science

Master, Performance Tuning of Oracle 9i RDBMS · Applied Computer Science · Kraków, Poland

Oct 2003 - Jun 2007

The State School of Higher Professional Education in Elblag (pol. Państwowa Wyższa Szkoła Zawodowa w Elblągu), The Institute of

Computer Science Engineer · Computer Science · Elbląg, Poland

Certifications & licenses

Oracle AI Vector Search Certified Professional

Oracle Cloud Infrastructure 2023 Architect Professional

Oracle Autonomous Database Cloud 2019 Specialist

Oracle Cloud Infrastructure Foundations 2020 Associate

OCM (Oracle Certified Master) 11g

Oracle GoldenGate 10 Certified Implementation Specialist

Oracle Exadata 11g Certified Implementation Specialist

OCP (Oracle Certified Professional) Oracle 11g

RHCT (Red Hat Certified Technician) RedHat 5

RHCSA (Red Hat Certified System Administrator) RedHat 5

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Serkan Kaya
Serkan Kaya

Operation and Maintenance of Oracle Middleware Products

View Profile
Bahriye Eser
Bahriye Eser

Freelance

View Profile
Werner Hendricks
Werner Hendricks

Oracle Database Migration Consultant

View Profile
Michal Budzyn
Michal Budzyn

Senior Golang Engineer

View Profile
Alexander Zhirov
Alexander Zhirov

Senior Data Architect & Data Engineer

View Profile
Stefan Moisa
Stefan Moisa

SAP Basis Administrator

View Profile
Jens Rehsack
Jens Rehsack

Technical Product Owner

View Profile
Sven Koebnick
Sven Koebnick

All-round admin

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Dirk Behringer
Dirk Behringer

Senior Consultant Database Administration and SQL

View Profile
Frank Eppink
Frank Eppink

DevOps

View Profile
Alex Odesser
Alex Odesser

Contractor

View Profile
Marcus Wiederstein
Marcus Wiederstein

Administrator, DevOps

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Jörg Trappschuh
Jörg Trappschuh

Database Expert and Software Developer

View Profile
Stefan Freundt
Stefan Freundt

Oracle Consultant

View Profile
Christian Dröge
Christian Dröge

Requirements Engineer

View Profile
Joachim Bleichert
Joachim Bleichert

Further development and maintenance of a company-wide monitoring database

View Profile
Artur Rekawek
Artur Rekawek

Senior DevOps Engineer

View Profile
Manfred Schirmer
Manfred Schirmer

Senior System Engineer Linux

View Profile
Stefan Corsten
Stefan Corsten

SSIS Development

View Profile
Marko Oršolić
Marko Oršolić

System administrator in a 6-person team

View Profile
Jorge Machado
Jorge Machado

Data Architect

View Profile
Werner Mühlmann
Werner Mühlmann

IT Support

View Profile
Josef Kroiss
Josef Kroiss

Architect / Senior Consultant

View Profile
Ben Spouse
Ben Spouse

Data Engineer/ ETL Developer

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Younes Hadrous
Younes Hadrous

Senior Backend Developer

View Profile
Djalil Moosawi
Djalil Moosawi

SAP Basis Consultant

View Profile
Yahya Vall
Yahya Vall

Co-founder & CEO

View Profile