Soocs

About Me

My name is Stefan Koehler and i am a freelance consultant and the founder of Soocs.
I started my career with an "IT specialist / system integration" apprenticeship in 2001 and completed successfully 3 years later as one of the best in my year. Afterwards i worked as a classic *nix admin (primarily focusing on IBM AIX and Linux) and Oracle DBA for round about 2 years before i joined the SAP area with the main focus on Oracle databases and SAP performance tuning.
In 2011 i founded my own freelance company Soocs to provide independent and specialized consulting services for Oracle databases and SAP performance tuning in mission critical environments.

Since +13 years i follow my passion about Oracle and specialized in Oracle and SAP performance tuning, especially in Oracle cost based optimizer (CBO) and database internal related topics. I am not just interested into understanding how an Oracle database feature works, but also how it is implemented in detail. In consequence i research a lot of Oracle database internals for education purpose or on client’s needs. In addition Oracle High Availability and Oracle Backup and Recovery are completing my skill set.

Nowadays i primarily work as a freelance Oracle database performance consultant and SAP performance analyst in large mission critical environments (e.g. +10 TB databases or +4000 concurrent SAP users) for market-leading companies or multi-billion dollar enterprises in various industries all over the world. I usually support my clients in understanding / solving complex Oracle performance issues and troubleshooting nontrivial database issues on short-term contracting basis.

I constantly share my experiences, findings and knowledge with the Oracle and SAP community through my blog and my activity on Oracle-L, Oracle technology network, SAP community network and Twitter. Sharing knowledge is one of my key aspects when working with clients or interacting with the community. I am also one of the leading contributors on the SAP community network in the "SAP on Oracle" area and i received awards by SAP for being the #1 SCN Topic Leader (2012/2013) – SAP on Oracle and #2 SCN Topic Leader (2013/2014) – SAP on Oracle. In 2015 i received the greatest honor in my professional career as i was invited to join the well-known OakTable network, an informal organization of Oracle experts around the world, who believes in better ways of administering and developing Oracle based systems.
Stefan Koehler

Consulting services

I am your reliable partner for mission critical issues or “must not fail” projects and always up to go the extra mile with you. I keep the focus on your needs and issues without wasting time by playing political games. This level of expertise has never been so affordable, so flexible or so easy to acquire – just call me. All activities are provided under confidentiality agreements.


Oracle RDBMS

  • Performance analysis and tuning of Oracle databases
  • Performance analysis and tuning of SQL statements
  • Analysis and benchmarking of performance and scalability
  • Application design and instrumentation for Oracle databases
  • Troubleshooting of Oracle database issues (e.g. crashes)
  • Design and implementation of Oracle Data Guard solutions
  • Design and implementation of Oracle RAC solutions
  • Design and implementation of Oracle RMAN solutions


  • Operating system

  • AIX performance tuning as platform for Oracle or SAP
  • Linux performance tuning as platform for Oracle or SAP
  • Design of operating system architecture for Oracle or SAP
  • Implementation of HA infrastructure for Oracle or SAP
  • SAP on Oracle

  • Performance analysis and tuning of SAP systems
  • Performance analysis and tuning of SAP applications
  • Performance analysis and tuning of R3load based migrations
  • Analysis and benchmarking of performance and scalability
  • Near zero downtime OS/DB migrations based on advanced Oracle database technologies
  • Your advantages by using my services

  • Knowledge about Oracle cost based optimizer (CBO) internals
  • Knowledge about Oracle database core component internals
  • Active researching of Oracle database internals and operating system integration (e.g. DTrace, GDB, Perf, Procstack, etc.)
  • Specialized knowledge about Oracle for SAP systems
  • Live analysis or troubleshooting with your IT staff
  • Client-specific performance workshops (e.g. about cost based optimizer, troubleshooting, etc.)
  • Flexible booking and short-term availability in general
  • Standby and Go-Live support for cut-over activities

  • If you have any further questions about my services, please get in contact directly.

    Clients & Reviews

    Clients

    The following list is just an extract of my clients due to particular confidentiality agreements - especially with my US clients. Please contact me for more detailed information.


    Public client reviews

    Stefan is a genuine Oracle database expert with in-depth knowledge and understanding of database internals and optimizer. He is able to efficiently work out a straightforward solution to all kind of different problems around the database, even complex performance bottlenecks, hanging issues and system crashes. If you need a quick solution for an urgent issue with an Oracle database, he is a right consultant to hire.
    Nenad Noveljic, Head Databases and Middleware Engineering & Support, Bank Vontobel AG

    Contact

    Name (required)

    Email (required)

    Company

    Address

    Code / City

    Phone

    Message (required)



    soocs
    Stefan Koehler
    Gustav-Freytag-Weg 29
    D-96450 Coburg
    Germany

    Phone: +49 (0) 172 / 1796830
    Mail: contact{at}soocs.de
    VAT Reg. No.: DE283352582

    LinkedIn - Stefan Koehler Skype - Cyberfree_ger Twitter - Stefan Koehler Xing Stefan Koehler Oracle Technology Network - Stefan Koehler SAP Comunnity Network - Stefan Koehler 

    Public Appearances

    Upcoming

    Past

    November 15 - 18, 2016 - DOAG 2016 Conference + Exhibition in Nuremberg: Talk about Hacking Oracle's memory - About internals & troubleshooting
    October 20, 2016 - Regional DOAG group meeting in Nuremberg: Talk about Hacking Oracle's memory - About internals & troubleshooting
    September 28 - 29, 2016 - Trivadis Performance Days 2016 in Zurich: Talk about Troubleshooting Oracle performance issues beyond Oracle wait interface
    June 16, 2016 - Regional DOAG group meeting in Nuremberg: Talk about Troubleshooting Oracle performance issues beyond Oracle wait interface (Extended Version)
    May 19, 2016 - Regional DOAG group meeting in Nuremberg: Participant & Meet up
    November 17 - 20, 2015 - DOAG 2015 Conference + Exhibition in Nuremberg: Talk about Identifying performance issues beyond Oracle wait interface

    Disclaimer

    Content
    The author reserves the right not to be responsible for the topicality, correctness, completeness or quality of the information provided. Liability claims regarding damage caused by the use of any information provided, including any kind of information which is incomplete or incorrect,will therefore be rejected.
    All offers are not-binding and without obligation. Parts of the pages or the complete publication including all offers and information might be extended, changed or partly or completely deleted by the author without separate announcement.

    Referrals and links
    The author is not responsible for any contents linked or referred to from his pages - unless he has full knowledge of illegal contents and would be able to prevent the visitors of his site from viewing those pages. If any damage occurs by the use of information presented there, only the author of the respective pages might be liable, not the one who has linked to these pages. Furthermore the author is not liable for any postings or messages published by users of discussion boards, guest books or mailing lists provided on his page.

    Copyright
    The author intended not to use any copyrighted material for the publication or, if not possible, to indicate the copyright of the respective object.
    The copyright for any material created by the author is reserved. Any duplication or use of objects such as images, diagrams, sounds or texts in other electronic or printed publications is not permitted without the author's agreement.

    Privacy policy
    If the opportunity for the input of personal or business data (email addresses, name, addresses) is given, the input of these data takes place voluntarily. The use and payment of all offered services are permitted - if and so far technically possible and reasonable - without specification of any personal data or under specification of anonymized data or an alias. The use of published postal addresses, telephone or fax numbers and email addresses for marketing purposes is prohibited, offenders sending unwanted spam messages will be punished.

    Legal validity of this disclaimer
    This disclaimer is to be regarded as part of the internet publication which you were referred from. If sections or individual terms of this statement are not legal or correct, the content or validity of the other parts remain uninfluenced by this fact.
    TOP