Cleanup after hacker attack
I en større international servicevirksomhed oplevede man et massivt „ransomware‟ angreb, hvor en betydelig del af de centrale og forretningskritiske IT-systemer blev ødelagt af en „crypto locker‟.
One of the destroyed systems were an Oracle based system.
Martin Berg Consult var involveret intensivt i flere uger og fik reddet alle data indtil sidst „committede‟ transaktion før angrebet.
Opgaven indbefattede blandt andet et antal „prioritet 1‟-sager med Oracle Support med deraf følgende krav om 24×7 respons.
Increasing profitability of hosted solution
Martin Berg Consult described and made recommendations for a new hosting architecture for a hosted solution being offered by a large solution and hosting provider in Denmark.
The suggested changes included both server platform and Oracle Database.
The end result was an 50% reduction of the costs incured by providing the hosted solution.
Optimization of complex SQL
I a system intended for administration of service offering to citizens a performance analysis revealed that a very significant part of the database load and user response time could be attributed to one particular database query.
This query was used to determine the relation between citizens and service personell and was was implemented with a database view containing more that 1000 lines of code.
This one database view was implementing 11 different principles for matching citizens and service personell (depending on customer) and had as a consequence of several years of stepwise maintenance gotten so complex that none of the resident developers wanted to change it.
Unfortunately no documentation had been created.
The performance problem could not be solved by adding indexes or by making simple code changes – the result being that a total rewrite was required.
Denne blev udført – blandt andet med introduktion af „materialiserede views‟ – og der blev udarbejdet en fyldestgørende dokumentation og testdata til at verificere, at den oprindelige komplekse funktionalitet var implementeret korrekt.
The optimization resulted in a 10-fold reduction of response times and a significant reduction of the database server load.
Using Oracle Enterprise Manager in a large organization
In a large goods producing company most of the internal systems has been developed in-house.
The systems are by a large fraction deployed on an full Oracle stack (Oracle Weblogic, Oracle Database and Oracle Linux).
The server and database portfolios are counted in the 1000’s.
For monitoring of all of this several tools for monitoring has been deployed – including Oracle Enterprise Manager.
Despite the efforts put down for developing and maintaining the monitoring tools, the system owners in general considered their systems to have no relevant monitoring.
The assignment was described as a staff function with the purpose of determining and documenting the gaps between the existing monitoring and the needed monitoring – one system at a time.
The assignment was not continued to completion due to expenditure control, but it was accomplished to assess several systems and to initiate improvement processes.
Over the years there has been many assignments and customers.
As a general rule the name of the customers will not be revealed – many of the assignments dealt with mission critical internal systems and it is expected that the details on these are kept confidential (in many cases this is explicitly included in the contract).
Det vil dog stadig være relevant at beskrive nogle af de interessante opgaver – hvor der med „interessant‟ både kan henføres til den forretningsmæssige betydning eller det tekniske indhold af opgaven.
English (UK) 
Dansk