I tell this story often when I introduce myself to customers or speak at events. Some friends have heard it so many times that they probably already know every line.

But it is a true story, and it explains how GoldenGate became part of my career.

Around 2010, I had a consulting company with my business partner, Bruce. We were hired to help migrate a critical energy trading application from Oracle 9i on Solaris to Oracle 11g on Linux.

From the database side, it was already a significant project: new infrastructure, RAC, Data Guard, backup and recovery, platform migration, and everything else that comes with moving a mission-critical Oracle environment.

Then, during one of our first project meetings, we learned about one additional requirement:

The application essentially could not go down.

I remember sitting in a conference room with maybe 10 or 12 people when that requirement came up.

I leaned toward Bruce and whispered:

“How are we going to do that?”

At that point, my DBA toolbox was full of the traditional migration approaches: export/import, backups, restores, RMAN, scripts, planned cutovers.

All great tools.

But they normally required an outage.

Bruce leaned back toward me and said:

“Have you heard about GoldenGate?”

“No.”

“Check it out.”

That night, I did.

And remember, this was 2010. Oracle had acquired GoldenGate only months earlier, and there was nowhere near the amount of online material available today.

I eventually found a step-by-step blog written by an Oracle ACE in Australia explaining how to configure replication.

So I created a couple of virtual machines and started experimenting.

Extract.

Pump.

Replicat.

Configuration files.

Checkpoints.

Trail files.

I followed the example step by step.

Sometime later that night, I looked at the second database and realized something pretty remarkable:

The data was moving.

The next morning, I walked into the office and told Bruce:

“I got it working last night.”

He looked at me:

“Really?”

“Yeah. I think we can do this.”

That simple lab eventually became part of a much larger architecture.

The project took close to a year. There were many challenges beyond GoldenGate: RAC, Data Guard, platform changes, endian conversion, backup and recovery strategy, testing, application coordination, and a rollback architecture in case the business needed to return to the original system.

But eventually we migrated that production system from:

Oracle 9i → Oracle 11g
Solaris → Linux
Old RAC environment → New RAC environment

with essentially zero database migration downtime.

The final interruption was measured by how quickly the application team could drain the old connections and redirect the application to the new environment.

Seconds.

And we never needed the rollback environment.

That project changed my career.

GoldenGate stopped being a product I had just discovered and became another tool in my DBA toolkit.

Over the following years, I started using it for more migrations, active-active architectures, disaster recovery strategies, operational data stores, data warehouse integrations, platform migrations, and many other architectures.

At the time, GoldenGate expertise was still relatively uncommon, especially among Oracle consultants. That combination of DBA knowledge and real-time replication experience opened a lot of doors.

Eventually I became a GoldenGate SME and spent years designing and implementing GoldenGate environments for organizations across North America, including highly critical systems in industries such as banking, telecommunications, energy, retail, healthcare, and government.

And eventually that journey brought me to Oracle, where today I work on GoldenGate from the product side.

Looking back, there was never really a moment where I sat down and said:

“I am going to specialize in GoldenGate.”

It happened because a customer presented us with a problem that the tools I already knew could not easily solve.

So I learned another tool.

That is probably the bigger lesson from the story.

Technology careers are often shaped less by carefully planned specialization and more by the problems we decide to take on.

Sometimes the technology that changes your career starts with a very simple conversation:

“How are we going to do that?”

“Have you heard about GoldenGate?”

Fifteen years later, I am still working on the answer.

#OracleGoldenGate #GoldenGate #OracleDatabase #DatabaseMigration #OracleDBA #DataIntegration #ChangeDataCapture #CDC #HighAvailability #DataArchitecture #DatabaseEngineering