<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=2233467260228916&amp;ev=PageView&amp;noscript=1">
EN
  • Cloud operations
  • Software
  • Consultancy

#MeetOurTeam – Kim

We want to showcase our employees through what we have called #MeetOurTeam. Meet Kim!

Cegal-Kim-Berg-Hansen
Name:

Age:

Cegal office:

Role:

Comes from:

Years in Cegal:

Kim Berg Hansen

54 years

Mix of Copenhagen, Skanderborg and home office

Lead Software Developer

Middelfart, Denmark

1,5 month

What does a typical workday look like to you?

Typically, I have the Oracle SQL Developer tool open and look for slow SQL queries in my clients' databases, then rewrite them to be faster or find alternative methods.

Which technologies do you work with?

Mainly Oracle SQL, and Oracle PL/SQL, and then I work with a bit of everything needed in the project in question.

The SQL language is necessary to work with data in the database, and the more you can utilize all facets of SQL, the better and faster the application can run. And thus you save on CPU (Central Processing Unit), which in turn means money on the bottom line in these Cloud times.

What drives you at work and in your role, what's fun?

I am driven by my professional pride. I thrive when I create value for the customer. Or when a customer has a good experience with something I've created, for example making the customer's applications faster. I am also proud when a colleague or developers elsewhere in the world do something smart that they have learned/received tips from me. They may have received tips through my work, via the internet or from my book.

Cool - you've written your own book - can you tell us a bit more about it?

The name of the book is Practical Oracle SQL and is a book for those who already know basic SQL, but who would like to learn how to make more efficient SQL statements by utilizing the all the features modern SQL supports (rather than sticking to the SQL-92 standard.) I started as a speaker at conferences in 2012 by giving lectures on analytical functions based on practical examples from my everyday life, and it turned out that the participants learned much better because it was practically oriented. After several years as a speaker, Apress encouraged me to write a book that similarly teaches about more advanced SQL via practical examples - I have used a fictitious beer trading company as an example in the book.

During the Oracle Community Tour this autumn you gave several lectures, can you say a little more about this?

Yes, I am so lucky that I was offered by OUGN (Oracle User Group Norway) to entertain a whole afternoon with three lectures: "Analytical functions in real life" with a review of some practical examples (for developers in the same target group as the book), "External Tables" about the possibilities of using data from external files directly into SQL statements (both for developers and DBAs), as well as "Shape-Changing SQL" about different ways of "building SQL" as a tool to expanding the possibilities of SQL (for the most hardcore SQL developers .) As you can see, a good mix of topics, but I hope the audience had an exciting afternoon and that they learned a few new things.

What is the best thing about working in Cegal?

Nice colleagues to share experiences with and great clients with interesting tasks that give me a lot of variety in my work.

Which app do you use the most?

It will probably have to be Twitter (which is a hair's breadth ahead of Gmail.) On Twitter I have my largest network of friends and colleagues in the Oracle world.

What is your favorite quote?

I don't just have a specific one - there could be many different ones. But the closest is probably the favorite answer most IT people can give: "It depends!!" - Maybe not a specific quote, but I always think of Tom Kyte when I use it.

Tom Kyte (the original Tom at asktom.oracle.com) has always been a great role model of mine, and he often replied "It depends!" to indicate in the answers that there is almost never a 100% general answer that covers all cases - there will almost always be different correct answers in different circumstances.

What du you prefer?

Android or iPhone?

Podcast or radio?

Streaming or linear-tv?

Call or text?

Emoji or text?

Snapchat or Instagram?

iPhone

Radio

Linear-tv

Send messages

Lots of text well mixed with emojis

Neither - Twitter

Is there anything else fun we should know about you?

I'm responsible for cooking and shopping at home - not that I'm trying to be a fancy chef à la Price, I cook everyday food, and it's inspired by all kinds of different cuisines. From grandma's food via Italian to Asian (I rarely follow the recipe 100% ). I am also a member of Danish Beer Enthusiasts and have slowly started to try my hand at homebrewing.

I can't avoid saying that Oracle SQL is also my hobby in addition to work, good to be able to make a living from your hobby. I have e.g. as already mentioned written book (Practical Oracle SQL), then I make quizzes for Oracle Dev Gym, and I am a volunteer organizer of the Oracle Development Tools User Group's annual Kscope conference in the USA.

Fun fact: My book has been translated into Polish.

Kim matlaging

At the OUG Tech Days 2019 in Tel Aviv, Israel, the conference speakers had to prepare the food themselves for the "Speakers Dinner", which was organized as a "Master Chef" concept😋