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
Creating agent golden image with new RU and security fixes for full-scale environment OEM agent upgrade
Developing custom metric extensions and reports
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
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
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
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
Oracle 11g/12c (2TB+)Linux/AIX/WindowsRACData GuardGrid-/CloudControlOracle VM
Datev eG, Nuremberg (Germany)
6 Monate
2014-09 - 2015-02
Consolidation of Oracle infrastructure on Oracle Virtual Compute Appliance OVCA
Oracle Consultant
Oracle Consultant
Collecting prerequisite/coordination/realization of Proof of Concept
Designing of testing methodology and creating/performing numbers of test scenarios oriented on high availability
Installation of Oracle Virtual Machine(OVM3.3) on 4 nodes
Creating Repositories/Servers Pools
Deploying Oracle Templates and creating own-templates with variety of Oracle releases/configurations
Deploying Real Application Cluster on OVM with deploy-cluster scripts
Integration the Oracle VM Manager into Oracle CloudControl
Generating Load on databases and virtual machines
Comparing usage reports thought Chargback
Managing users for role-base separation within CloudControl
DBA, Oracle Consultantcorporate systems based on Oracle 9i/10g/11g (10TB+)ASMLinux/ HP-UX/ AIX/Windows...
DBA, Oracle Consultant
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
corporate systems based on Oracle 9i/10g/11g (10TB+)ASMLinux/ HP-UX/ AIX/WindowsRACData GuardGridControlE-Business SuiteWeblogicOracle VM
OPITZ CONSULTING, Cracow (Poland)
1 Jahr 4 Monate
2010-06 - 2011-09
Daily Oracle administration ? Remote-DBA PASM
Oracle DBA
Oracle DBA
Remote Administration on a daily basis for various customers on the production systems, Oracle versions 9i to 11g Release 2
Responsible for managing, troubleshooting, optimizing efficiency and high availability of Oracle databases
ensuring regular backup and restore
developing, implementing and managing security
Performance Tuning(AWR, Statspack, SQL Trace, set event 10046, 10053)
Data Guard (Primary + physical standby) installation and configuration
Installation and configuration of test environment
Oracle 9iOracle 10gOracle 11gOracle RACOracle Data GuardOracle ASMOracle WeblogicOracle E-Business SuiteOracle Real Application TestingAWROracle Grid ControlOracle Cloud ControlRedHatOELSUSE Linux Enterprise ServerSolaris 10IBM AIX 5.3HP-UXOracle Virtual MachineVMware ESX
- Monitoring GoldenGate environment, installation and configuration, performing initial data load, configuring the Manager process and Data Pump process
- Configuring online change synchronization and DDL-support synchronization, filtering and mapping data for ZeroDowntime cross-platform migration
- Carrying out of the tests
- Documenting of the results
Oracle 10gOracle SQL DeveloperOracle GoldenGateOracle 11gOracle Enterprise LinuxSUSE Linux Enterprise Server
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
Oracle 10q/11gASMLinux 10RACData GuardUnix systems
OPITZ CONSULTING, Cracow (Poland)
3 Monate
2011-03 - 2011-05
OCINS Install Server (Cobbler)
ConsultantShell-ScriptUnix ScriptingRed Hat Enterprise Linux...
Consultant
Configuration Linux installation server for rapid setup of network installation environments and creating environment for automatic Oracle installation during system boot for HA purpose
Creating central server with system-repositories
Cobbler installation and configuration
Test and implementation, managing Redhat, OEL and Suse scripts, snippets and distros
Configuration DHCP server for PXE-bootoption
Documenting of the results
Shell-ScriptUnix ScriptingRed Hat Enterprise LinuxSUSE Linux Enterprise ServerLinux
Zahnärztekasse AG
Zurich
1 Monat
2011-02 - 2011-02
Network tests: Multipathing, Bonding
Oracle DBASUSE Linux Enterprise ServerOracle 11gOracle RAC
Oracle DBA
Configuration multipathing for Storage-server connection using iSCSI, performance test, presenting LUN to database admin, HA various solution
Implementation bonding-solution for boost Interconnect speed between RAC-node, creating High-availability bonding
Performance-test and finding maximum throughput in a multiple switch topology
Documenting of the results
SUSE Linux Enterprise ServerOracle 11gOracle RAC
Opitz-Consulting
Krakau
2 Monate
2010-12 - 2011-01
Oracle Flash Cache
Oracle DBAPL/SQLShell-ScriptParametrisierung...
Oracle DBA
Aligning Flash Modules for optimal performance
Configuring Database Flash Cache, identifying ideal Oracle Database objects for Flash Storage and Accelerators with AWR or another tools
Test Flash Card for redologs, temp tablespace, heavily used database tables and indexes or all database on flash for max performance
Dip-Ing, Jagiellonian University (pol. Uniwersystet Jagiello?ski), Faculty of Physics, Astronomy and Applied Computer Science, Cracow (Poland)
Dip-Ing
Jagiellonian University (pol. Uniwersystet Jagiello?ski), Faculty of Physics, Astronomy and Applied Computer Science, Cracow (Poland)
Master Work: on request
3 Jahre 9 Monate
2003-10 - 2007-06
Study
Computer Science Engineer (Dipl.-Ing), The State School of Higher Professional Education In Elblag (pol. Pa?stwowa Wy?sza Szko?a Zawodowa w Elbl?gu), The Institute of Applied Informatics, Elbl?g (Poland)
Computer Science Engineer (Dipl.-Ing)
The State School of Higher Professional Education In Elblag (pol. Pa?stwowa Wy?sza Szko?a Zawodowa w Elbl?gu), The Institute of Applied Informatics, Elbl?g (Poland)
Diploma thesis: on request
Kompetenzen
Kompetenzen
Top-Skills
OracleDatenbankenAdministrationDatensicherungskonzeptDB-TuningOracle RACOracle Data GuardCloudAzureLinuxBackup-SystemeNFSSQLArchitekt
Produkte / Standards / Erfahrungen / Methoden
PERSONAL SKILLS AND COMPETENCES
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
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)
Datenbanken
AWR Warehouse
Exadata Database
OEM 12c
Oracle 11g
Oracle Data Guard
Oracle RAC
Hardware
Exadata
ZFS
AWARDS and PUBLICATIONS (more informations on request)
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
Creating agent golden image with new RU and security fixes for full-scale environment OEM agent upgrade
Developing custom metric extensions and reports
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
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
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
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
Oracle 11g/12c (2TB+)Linux/AIX/WindowsRACData GuardGrid-/CloudControlOracle VM
Datev eG, Nuremberg (Germany)
6 Monate
2014-09 - 2015-02
Consolidation of Oracle infrastructure on Oracle Virtual Compute Appliance OVCA
Oracle Consultant
Oracle Consultant
Collecting prerequisite/coordination/realization of Proof of Concept
Designing of testing methodology and creating/performing numbers of test scenarios oriented on high availability
Installation of Oracle Virtual Machine(OVM3.3) on 4 nodes
Creating Repositories/Servers Pools
Deploying Oracle Templates and creating own-templates with variety of Oracle releases/configurations
Deploying Real Application Cluster on OVM with deploy-cluster scripts
Integration the Oracle VM Manager into Oracle CloudControl
Generating Load on databases and virtual machines
Comparing usage reports thought Chargback
Managing users for role-base separation within CloudControl
DBA, Oracle Consultantcorporate systems based on Oracle 9i/10g/11g (10TB+)ASMLinux/ HP-UX/ AIX/Windows...
DBA, Oracle Consultant
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
corporate systems based on Oracle 9i/10g/11g (10TB+)ASMLinux/ HP-UX/ AIX/WindowsRACData GuardGridControlE-Business SuiteWeblogicOracle VM
OPITZ CONSULTING, Cracow (Poland)
1 Jahr 4 Monate
2010-06 - 2011-09
Daily Oracle administration ? Remote-DBA PASM
Oracle DBA
Oracle DBA
Remote Administration on a daily basis for various customers on the production systems, Oracle versions 9i to 11g Release 2
Responsible for managing, troubleshooting, optimizing efficiency and high availability of Oracle databases
ensuring regular backup and restore
developing, implementing and managing security
Performance Tuning(AWR, Statspack, SQL Trace, set event 10046, 10053)
Data Guard (Primary + physical standby) installation and configuration
Installation and configuration of test environment
Oracle 9iOracle 10gOracle 11gOracle RACOracle Data GuardOracle ASMOracle WeblogicOracle E-Business SuiteOracle Real Application TestingAWROracle Grid ControlOracle Cloud ControlRedHatOELSUSE Linux Enterprise ServerSolaris 10IBM AIX 5.3HP-UXOracle Virtual MachineVMware ESX
- Monitoring GoldenGate environment, installation and configuration, performing initial data load, configuring the Manager process and Data Pump process
- Configuring online change synchronization and DDL-support synchronization, filtering and mapping data for ZeroDowntime cross-platform migration
- Carrying out of the tests
- Documenting of the results
Oracle 10gOracle SQL DeveloperOracle GoldenGateOracle 11gOracle Enterprise LinuxSUSE Linux Enterprise Server
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
Oracle 10q/11gASMLinux 10RACData GuardUnix systems
OPITZ CONSULTING, Cracow (Poland)
3 Monate
2011-03 - 2011-05
OCINS Install Server (Cobbler)
ConsultantShell-ScriptUnix ScriptingRed Hat Enterprise Linux...
Consultant
Configuration Linux installation server for rapid setup of network installation environments and creating environment for automatic Oracle installation during system boot for HA purpose
Creating central server with system-repositories
Cobbler installation and configuration
Test and implementation, managing Redhat, OEL and Suse scripts, snippets and distros
Configuration DHCP server for PXE-bootoption
Documenting of the results
Shell-ScriptUnix ScriptingRed Hat Enterprise LinuxSUSE Linux Enterprise ServerLinux
Zahnärztekasse AG
Zurich
1 Monat
2011-02 - 2011-02
Network tests: Multipathing, Bonding
Oracle DBASUSE Linux Enterprise ServerOracle 11gOracle RAC
Oracle DBA
Configuration multipathing for Storage-server connection using iSCSI, performance test, presenting LUN to database admin, HA various solution
Implementation bonding-solution for boost Interconnect speed between RAC-node, creating High-availability bonding
Performance-test and finding maximum throughput in a multiple switch topology
Documenting of the results
SUSE Linux Enterprise ServerOracle 11gOracle RAC
Opitz-Consulting
Krakau
2 Monate
2010-12 - 2011-01
Oracle Flash Cache
Oracle DBAPL/SQLShell-ScriptParametrisierung...
Oracle DBA
Aligning Flash Modules for optimal performance
Configuring Database Flash Cache, identifying ideal Oracle Database objects for Flash Storage and Accelerators with AWR or another tools
Test Flash Card for redologs, temp tablespace, heavily used database tables and indexes or all database on flash for max performance
Dip-Ing, Jagiellonian University (pol. Uniwersystet Jagiello?ski), Faculty of Physics, Astronomy and Applied Computer Science, Cracow (Poland)
Dip-Ing
Jagiellonian University (pol. Uniwersystet Jagiello?ski), Faculty of Physics, Astronomy and Applied Computer Science, Cracow (Poland)
Master Work: on request
3 Jahre 9 Monate
2003-10 - 2007-06
Study
Computer Science Engineer (Dipl.-Ing), The State School of Higher Professional Education In Elblag (pol. Pa?stwowa Wy?sza Szko?a Zawodowa w Elbl?gu), The Institute of Applied Informatics, Elbl?g (Poland)
Computer Science Engineer (Dipl.-Ing)
The State School of Higher Professional Education In Elblag (pol. Pa?stwowa Wy?sza Szko?a Zawodowa w Elbl?gu), The Institute of Applied Informatics, Elbl?g (Poland)
Diploma thesis: on request
Kompetenzen
Kompetenzen
Top-Skills
OracleDatenbankenAdministrationDatensicherungskonzeptDB-TuningOracle RACOracle Data GuardCloudAzureLinuxBackup-SystemeNFSSQLArchitekt
Produkte / Standards / Erfahrungen / Methoden
PERSONAL SKILLS AND COMPETENCES
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
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)
Datenbanken
AWR Warehouse
Exadata Database
OEM 12c
Oracle 11g
Oracle Data Guard
Oracle RAC
Hardware
Exadata
ZFS
AWARDS and PUBLICATIONS (more informations on request)
Branchen
Branchen
Banking
Versicherungen
Telekommunikation
Maschinenbau
Softwarehouse
Rechenzentrum
Öffentlicher Dienst
Mikrobiologie und Life Science
Vertrauen Sie auf Randstad
Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung