What we do is: APEX, PL/SQL, Forms, Reports, BI Publisher

 We know people who do: PHP

We have done this for: The Great Orchestra of Christmas Charity

1. We’ll design a complete migration path for you
2. We’ll advise which versions and hardware you should choose
3. We’ll carry out the migration with the minimal data base down time
4. If you fancied to migrate your Windows, we’ll dissuade you from this irresponsible intention 😉
5. We will take responsibility for all problems which will for sure appear after all these changes.

We have done this for:

CODGiK (as Infovide Matrix subcontractor)

Packet I – EXADATA FOR START

We will suport you technically with administration of Oracle Exadata, we will maintain intrastructure and data bases. We will analyse, configure what it needs to be configure and we will implement system adjustments.

Packet II – EXADATA ADVANCED

We will provide detailed audit of security, optimize Oracle Exadata for efficiency, we will consolide and migrate where it is needed, and at the end we will establish laborsaving processes.

We know the problem.

We’ll carry out training sessions where we’ll put both teems on the same page and lead them to their common victory.

That’s ok. We fear that one day we’ll forget to buy beer.

1. We’ll design HA procedures for you
2. We’ll create appropriate backup and restore scripts
3. We’ll provide SLA

We have done this for: AmRest (as a Betacom contractor)

1. We’ll design a database that meets all the standards – we’ll follow some on them and some override, because they are just pointless
2. We’ll create ETL processes for you
3. And match tools and licenses according to your needs and your inclination for spending money

You know why?

YES – but I don’t know what to do about it.

1. We’ll conduct an in-depth analysis of the areas that you indicate
2. We’ll make the recommendations and rewrite the code
3. We’ll suggest the solutions to scale your performance in the event of your application being built up

NO – it just doesn’t work.

1. We’ll carry out an AWR analysis, if you have  a diagnostic pack
2. If not, we’ll create a statspack repository and we’ll make use of its reports
3. We’ll suggest the solutions to scale your performance in the event of your application being built up
4. We’ll carry out a detailed wait events analysis and we’ll tell you where the problem is
5. We’ll help you with talks with your application supplier and sooth your strained nerves with a cooled pint or two…

We have done this for: Asseco

Someone will sit with you and figure out what to do. We’ll make a brainstorm and we will become your personal problem-solvers.

We have done this for: Advatech

• Analisis of instalation and configuration Oracle environment;
• Analisis of operational system’s configuration paying special attention to good practices for Oracle database;
• Analisis of system and object privileges for individual database users;
• In case of finding privileges presumed as exessive – point of potential attack vectors and escalation paths of privileges;
• Analisis of PL/SQL code paying special attention to the potential atacks like SQL Injection;
• Audit ended with recommendation report

.

• Interview with administrators and users of the application and database server;
• Analisis of the AWR or Statspack reports depending on the own license;
• Corelation the results of the reports with the database processes – analise on the grounds of performance views V$ and X$ and trace files;
• Analisis of the operating system configuration for the database environment research;
• Creating performance report which describes the database server situation – the report will contain recommandations;
• Audit of the specific process or SQL query;
• Analisis of the plan of the query execurion;
• Corelation specific stages of the query execution with the expectations;
• Analisis trace files like 10046 and 10053;
• Analisi of database objects which take part in the process;
• The result of our work is the report with the recommentations or amended version of SQL quere.