ABM’s years of experience in implementing business critical systems in highly sensitive and secure environments means that we are well placed to offer a number of valuable services for any organisation.

Database Healthcheck

Database Healthcheck is a review of various aspects of your operating system and database environment, identifying areas for optimisation.

Our Technical Consultants will work with you to set up scripts, collect information, analyse the reviews and write an extensive report with recommendations.

The report includes detailed information on:

  • Hardware Analysis
  • Instance Analysis
  • SQL Performance
  • Memory Statistics
  • Database Parameters
  • Alert Logs & Trace Files
  • DBA Comments and Recommendations

Should any of the report findings require further ABM technical assistance (follow up) e.g. recommendations on hardware or patch upgrades; this will be highlighted, helping you to make an informed decision on the best course of action.

database-healthcheck

annual-dba-support

Annual DBA Support

Annual DBA Support provides a 12 monthly review of the environment by an ABM Technical Consultant; with the following tasks being performed:

  • Review of the database and application servers, production database and production Application Server (Oracle/JBoss)
  • Report identifying the status of the environment providing an ongoing history
  • Highlight of the issues
  • Recommendation on how to resolve these issues

Should any of these issues require further ABM technical assistance e.g. recommendations on hardware or patch upgrades; this will be highlighted, helping you to make an informed decision on the best course of action.

Backup Requirements

Protect your data and ensure availability and resilience of the system. Our Technical Consultants can help with your backup and disaster recovery strategy.

back-up-requirements

oracle-migrations

Oracle Migrations

If you would like to improve your systems performance and make sure it is supported, ABM can help you update your system to the latest Oracle version. Our technical services consultants will:

  • Prepare all media and environment specific software
  • Perform Test upgrade
  • Provide Production upgrade and technical go-live support

Fully change control documentation for both test and production upgrades.

Oracle Security Patching

ABM Technical Consultants can assist with review of existing state of your Oracle installation and identify target patch levels. They will also provide recommendations on the remedial work required to apply the required patches.

Our team will apply the patches, initially to a test system, if possible, then to the production system after User Acceptance Tests.

security-patching

oracle-training

1 Day Oracle Training overview Course

The course is designed for technical personnel who are new Oracle database administrators and are involved in the maintenance of ABM Applications running on Oracle databases.

It will enable the delegate to maintain Oracle databases on a day to day basis. It provides a basic introduction to Oracle administration for sites which have additional support and / or maintenance contracts or have only occasional exposure to Oracle and covers day to day maintenance.

The course is structured in such a way as to take the delegate step by step through maintenance of the database, users and assignment of permissions. Exercises on each lesson provide the delegates hands on experience.

2 Days Oracle DBA course for occasional DBA’s

The course is designed for technical personnel who are new Oracle database administrators and are involved in the maintenance of ABM Applications running on Oracle databases.

It will enable the delegate to maintain Oracle databases on a day to day basis. It provides a basic introduction to Oracle administration for sites which have additional support and / or maintenance contracts or have only occasional exposure to Oracle and covers day to day maintenance operations and basic backup and recovery.

The course is structured in such a way as to take the delegate step by step through maintenance of the database, users and assignment of permissions. Exercises on each lesson provide the delegates hands on experience.

Application Upgrades

Make sure you get the most out of your abmpegasusTM and abmintellicaseTM by keeping up to date with the newest releases. Our Technical Consultants will be happy to assist you with your upgrades by:

  • Preparing  all media and environment specific software
  • Testing upgrade (including training environment)
  • Performing Production upgrade and technical go-live support
  • Providing full change control documentation for both test and production upgrades.

application-upgrades