Cookies on this site

We would like to use cookies to understand how the site is used and to measure our campaigns. Nothing is set until you choose, and you can change your mind at any time from “Cookie settings” at the foot of every page. Privacy policy

Contact UsContact Us

Services / Oracle Consulting

Oracle migrations and database care, without the downtime.

Our DBAs move and run mission-critical Oracle databases for banks, cities and software companies. We plan every cut-over so the business keeps running, and we stay on call afterwards.

30 TB
moved for a global bank with zero downtime
Zero
downtime across our published Oracle migrations
4
database engines on call: Oracle, PostgreSQL, SQL Server, MySQL

Zero-downtime Migration

Move the database while the business keeps using it

We build the new platform alongside the old one and keep both in sync in real time with Oracle GoldenGate. Users keep working on the old system until the new one has been tested end to end, and the final switch is planned, rehearsed and reversible.

More on GoldenGate Zero-Downtime Migration →

What we do

  • Version upgrades and hardware moves, such as 10g on Solaris to 12c RAC on AIX
  • Real-time replication with Oracle GoldenGate
  • Rehearsed cut-over with a tested way back
  • Data validation before and after the switch

Heterogeneous Migration

Change database engines without starting over

Moving from Sybase or SQL Server to Oracle, or from Oracle to PostgreSQL, means converting the schema, the code and the data. We automate the conversion, replicate continuously during the move and validate table by table.

More on Heterogeneous Database Migration →

What we do

  • Schema and stored-procedure conversion
  • Continuous replication until cut-over
  • Row-count and checksum validation
  • Performance tuning on the new engine

Database Administration

Senior DBAs on call, remotely

Our remote DBA team looks after Oracle, PostgreSQL, SQL Server and MySQL: tuning, patching, backups, high availability and urgent fixes when something breaks. When you call, you reach someone who has seen the problem before.

What we do

  • Oracle RAC, Data Guard and GoldenGate
  • PostgreSQL, SQL Server and MySQL
  • Health checks, patching and upgrades
  • Database rescue for urgent incidents

In depth

More on Oracle Consulting

Case studies

Oracle Consulting in practice

Client names are withheld. We are happy to share details on a call.

All case studies
  • Delivered

    30 TB, zero downtime

    Financial services

    Oracle

    Zero-downtime move of a 30 TB Oracle database for a global retail bank

    The bank's transaction database served thousands of users around the clock. We built the new Oracle 12c RAC platform on IBM AIX alongside the old Solaris system, kept the two in sync with Oracle GoldenGate, tested everything and switched over with no downtime and no data loss.

    • 30 TB moved with zero downtime
    • Zero data loss at cut-over
  • Delivered

    Zero downtime

    Legal technology

    Oracle

    Sybase to Oracle with zero downtime for an e-discovery company

    Sybase was holding back a platform that processes large volumes of legal data. We converted the schema, kept both databases in sync with continuous replication, validated the data and switched over without interrupting the business.

    • Zero downtime at cut-over
    • No disruption to client workflows
  • Delivered

    No service disruption

    Local government

    Oracle

    A city's Oracle database moved off ageing Solaris hardware

    A major California city ran a mission-critical Oracle database on Solaris servers nearing end of life. We mapped the dependencies, confirmed the applications would work unchanged and re-platformed the database to Linux without disrupting public services.

    • No disruption to public services
    • Minimal application changes
  • Delivered

    Fixed within hours

    Not disclosed

    Oracle

    Production database rescued within hours

    A client's in-house team had worked an unstable production database for some time without finding the cause. Our DBAs joined a secure screen-share, found the root cause and gave them a step-by-step plan to recover and to prevent a repeat.

    • Root cause found and fixed within hours
    • Prevention plan handed to the client's team

From the blog

Writing on Oracle Consulting

All Oracle & databases articles

Related services

On-site IT support across New Jersey, New York City and Philadelphia. Remote services wherever you are. Areas we serve →

Planning an Oracle migration? Get a fixed-scope plan in two weeks.

Inventory, risks, cut-over approach and a cost range, before you commit to anything.

Tell us what you are working on

A few lines is enough. The engineers who do this work will reply within one business day.

Or email it.services@princetonits.com or call +1 (212) 507-9350.