Jakub Szepietowski
Oracle Consultant
Erfahrungen
Dez. 2017 - Apr. 2024
6 Jahren 5 Monaten Frankfurt, Deutschland
Oracle Consultant
Airline Sector
- Environment: Oracle 11g/12c/19c (>1TB+; >100+ databases), Linux, RAC, Data Guard.
- Microsoft Azure: Design/Shape/Capacity analysis including PoC.
- Microsoft Azure: Final implementation for migration from on-prem RAC to SI Data Guard environment.
- Performance Tuning/Troubleshooting for Crew Management Systems(pilots/briefings).
- Design and implementation of disaster recovery aware system based on RAC-Extended Cluster and DataGuard.
- OEM: Oracle Cloud Control OEM Maintenance: Installation + Upgrade of OEM 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(plus configuration of Incident Rules based on Target LifeCycle).
- Upgrade of GI from 11.2.0.4=>12.1.0.2, 12.1.0.2=>18.4, 18.4=>19.6+.
- Upgrade of Databases from 11.2.0.2=>12.1.0.2, 12.1.0.2=>19.18+.
- Redesign and license optimization based on Oracle SE on ODA and DBVisit.
- Design of virtualized platform based on OLVM(Oracle Linux Virtualization Manager - KVM) and license optimization using hard partitioning.
- Migration of databases from BareMetal to OLVM.
Jan. 2015 - Juni 2025
9 Jahren 6 Monaten Frankfurt, Deutschland
DBA, Oracle Consultant, Exadata SME for EMEA, Primary DBA for SEPA(Single Euro Payment Area Database)
Banking Sector
- Environment: Oracle 11g/12c/18c/19c (100TB+; 10000+ databases), Linux/Solaris, RAC, Data Guard, X5/6/7/8/9 Exadata Multi-Rack.
- Exadata Full Stack Patching including compute nodes, storage cells, Infiniband switches to recent versions.
- Exadata Maintenance, Storage reorganization on Cell/Grid/ASM level for production/UAT/Dev clusters.
- OCI Cloud: Architecture planning for migration to ExaCC(Exadata@Customer) biggest private cloud in Europe/World.
- OCI Cloud: Onboarding new virtualized Exadata(with and without node subsetting).
- Consulting: Engineered Systems, RAC, Backup&Restore, Tuning, Capacity Planning.
- Migrations: using DataPump/Data Guard Standby switchover with minimal downtime, using TTS with endianness conversion and image copies on External Storage.
- Upgrades: Oracle Database from 11+ to 19c, GI Upgrades > 18 and 19c.
- Onboarding 4 Exadata X7-8 and 1x X7-8 Full Rack+ setup ZFS backup infrastructure for both DC for SEPA.
- Deep dive Performance Tuning/Troubleshooting for mission-critical OLTP/DWH databases (Exadata+ RAC+DataGuard+ASM+ZFS) using AWR/ASH/snapper/OEM, 10046/10053 traces/oradebug etc. and fixing via SQL Profiles/SQL Baselines/Hints and other methods.
- Consolidation of two projects on Full RACK X6-2 including initial reconfiguration of storage, patching to newest Exadata Image(18.1.4), GI upgrade to 18c and implementation of IORM based on application teams 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 (New Release of Oracle Database/Grid software)and onboarding new Exadata in the bank.
Aug. 2015 - Dez. 2015
5 Monaten Braunschweig, Deutschland
DBA, Oracle CloudControl Consultant
Volkswagen Financial Services AG
- Environment: Oracle 10g/11g/12c (5TB+; 2000+ databases), Linux, RAC, Failover DB, CloudControl, IBM TEC(Tivoli Enterprise Console).
- Monitoring Migration from IBM TEC to Oracle Cloud Control 12c.
- Building Monitoring Templates for databases, clusters, hosts, WebLogic and OIM targets.
- Building customer specific Metric Extensions(ME: Agent-Site and Repository-Site) to extend Oracle monitoring capabilities.
- Creating reports based on ME data and CloudControl target-metadata.
- Creating Incidents and Notification Rules.
- Monitoring of performance degradation over time with AWR Warehouse and Repository Metrics(buffer gets).
- Automatic identification of database configuration issues like: high number of redolog switchs, logfile sizing, Undo issues in clusters, failover databases monitored by wrong agent.
- Rewriting shell scripts to OEM format.
- Creating documentation in Confluence.
- Troubleshooting, performance tuning(sql-,instance-, storage-level) test/QS/production DB.
- Integration HP BSM with OEM trough Connector.
Juni 2013 - Juli 2015
2 Jahren 2 Monaten Nürnberg, Deutschland
DBA, Oracle Consultant
Datev eG
- Environment: Oracle 11g/12c (2TB+), Linux/AIX/Windows, RAC, Data Guard, Grid-/CloudControl, Oracle VM.
- Validation of enterprise backup/restore strategy.
- Creating, implementing and installation of high available environment for mission critical OLTP databases(RAC+ DataGuard, including Client Failover).
- Consulting and support in area: Real Application Testing, Engineered Systems like Exadata, ODA/OVCA, Automatic Degree of Parallelism.
- Creating company-wide procedure for installing and administration Oracle product according to Best Practices (orachk-tool).
- Collecting prerequisite/coordination/realization of PoC: OVM as high available and consolidated platform (IaaS, DaaS) with new usage reporting model (Chargeback) and OVM-Integration with CloudControl for role-based separation.
- Troubleshooting, performance tuning(sql-,instance-, storage-level) test/QS/production DB.
- Data modeling with: RationalRose Model Integrator, MID Innovator, Embarcadero DB Change Manager and ER Studio DataArchitet.
- Third level support for the local team of Oracle DBAs.
- Technical project management.
Juni 2011 - Mai 2013
2 Jahren Krakau, Polen
DBA, Oracle Consultant of ProActive System Management
Opitz Consulting
- Environment: Large corporate systems based on Oracle 9i/10g/11g(10TB+), ASM, Linux/HP-UX/AIX/Windows, RAC, Data Guard, GridControl, E-Business Suite, Weblogic, Oracle VM.
- Day-to-day Oracle DBA tasks(ticket system).
- Backup, restore and disaster recovery procedures.
- Regular clones of production system for development and testing purposes.
- Designing/installation/configuration/adminitration/troubleshooting of production and development Oracle based systems.
- Designing and implementing of high availability (HA) and replication concepts for Oracle based systems (with RAC, Data Guard/Standby Systems, Oracle GoldenGate).
- Troubleshooting and Performance Tuning, solving performance problems in the enterprise multi-tier environment (rdbms-storage level) using STATSPACK/AWR/Snapper, supporting Oracle developers.
- Engineering and documenting new solutions based on the Oracle newest technologies(Project Exadata/Flash Cache/Cards).
- DB patches regression tests and installation.
- Technical project management.
- Third level support for the local team of Oracle DBAs and coaching new DBAs.
Juni 2010 - Juni 2011
1 Jahr 1 Monate Krakau, Polen
Junior DBA, Junior Consultant of Service Engineering Department
Opitz Consulting
- Environment: Oracle 10q/11g, ASM, Linux 10, RAC, Data Guard, Unix systems.
- Day-to-day Oracle DBA tasks.
- Backup and recovery (with RMAN).
- Maintenance and documentation tasks.
- Installation/configuration/administration/troubleshooting of production and development Oracle databases/ GridControl environments.
- Installation and configuration of small prod/test RAC/Data Guard environments.
- Administering of LAN/WAN environment.
- Translating German documentation.
Jan. 2007 - März 2008
1 Jahr 3 Monaten Krakau, Polen
RemoteHelp Desk Consultant
Telekomunikacja Polska SA
- Customer Service.
- Supervising and administering remotely clients computers and servers.
- Creating electronic documentation.
- Administering of LAN/WAN environment.
- Remote maintenance.
Zusammenfassung
- 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 till the latest X9, ZFS Storage
- Supported Middleware: GoldenGate 10/11
- 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 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)
Sprachen
Polnisch
Muttersprache
Deutsch
Verhandlungssicher
Englisch
Verhandlungssicher
Ausbildung
Okt. 2007 - Juni 2010
Jagiellonian University
Master, Performance Tuning of Oracle 9i RDBMS · Faculty of Physics, Astronomy and Applied Computer Science · Krakau, Polen
Okt. 2003 - Juni 2007
The State School of Higher Professional Education in Elblag
Computer Science Engineer · The Institute of Applied Informatics · Elbląg, Polen
Zertifikate & Bescheinigungen
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 RedHat 5
RedHat
Red Hat Certified System Administrator
RedHat
Ähnliche Freelancer
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.