Case Study – Database as a Service (DBaaS) using Exadata – leading electricity distributor

The Client is a Government electricity distributor, providing the safe and reliable supply of electricity to 2.4 million people in households and businesses across Sydney’s Greater West, the Blue Mountains, Southern Highlands, the Illawarra and the South Coast.

OBJECTIVES

The Government electricity distributor invested in the deployment of high-end Oracle Exadata hardware platforms to host their Oracle databases so that they could implement a ‘Database as a Service’ (DBaaS) solution. The solution objectives were to:-

  • Provide a highly available and reliable Oracle Platform for internal Business applications based on an Exadata Maximum Availability Architecture (MAA); and
  • Reduce on-going license and support costs.

DELIVERABLE

Fusion Professionals were engaged to transform the existing infrastructure and architecture to a platform capable of delivering the ‘Database as a Service’ to their internal consumers. The engagement required:-

  1. The provision and configuration of Solution Architecture, Cloud Platforms and Data Management to meet the Exadata MAA; and
  2. To ensure the DBaaS platform and all PaaS capabilities were deployed in a timely and efficient manner with the least impact to the business.

These tasks included architectural design, private cloud deployment, database upgrade and migration to the new platform and the transition of Database-as-a-Service capabilities to consumption and support.

Fusion Professionals expertise and invaluable platform and architecture experience allowed the delivery of best practice solutions and processes to the entire lifecycle of the project.

DATABASE AS A SERVICE – CLOUD ARCHITECTURE AND DESIGN

Fusion Professionals wealth of experience in the development and deployment of Solution Architecture services and Cloud Platforms aided the success of architecting the entire DBaaS platform, designing DBaaS services and establishing database migration paths for their entire Oracle database estate.

The Cloud Architecture established the DBaaS standards to be used and identified the required components and their relationships. It also helped to build a comprehensive view of how to manage DBaaS component development and delivery to meet the business requirements for availability, service levels and cost. The Cloud Architecture was instrumental in managing change, avoiding the duplication of work and facilitating the reuse of the existing components.

DATABASE AS A SERVICE – CLOUD DEPLOYMENT AND DATABASE MIGRATION

Fusion Professionals specialist expertise in Exadata Cloud Infrastructure and Oracle Database technologies, were critical in identifying and deploying best practices, identifying and avoiding known pitfalls and staging issues when moving a clustered database and alternative solutions to common network. Throughout every stage of the deployment, Fusion Professionals creating detailed documentation for provisioning, migration procedures, testing and stress cases.

DATABASE AS A SERVICE – CLOUD OPERATE AND MONITOR

Fusion Professionals rich experience in establishing cloud support models and end-to-end monitoring frameworks provided considerable project benefit during the transition from “plan and build” to “operate and monitor” states. The DBaaS offerings were deployed and implemented effectively and are now supported efficiently, reducing the on-going license and support costs. The Government electricity distributor can now take advantage of best in case cloud capabilities including; quicker provisioning, consumption based charge back and higher availability.

DATABASE AS A SERVICE – DATA MANAGEMENT

Fusion Professionals expertise in the database technologies and data management services required for Oracle Exadata resulted in the delivery of a robust solution that could rapidly maximize the return on cloud technology investment. The Implementation risks were minimized by leveraging the Fusion Professionals proven migration methodology, DBaaS and Data Management experience and implementation services.

DATABASE AS A SERVICE – ON-GOING REVIEW AND CAPACITY FORECASTING

Using the Fusion Professionals Cloud platform optimisation and capacity forecasting capabilities, allowed the electricity distributor to identify and manage the lifecycle of DBaaS platform in terms of technology review, resource usage and data growth. This ensures the DBaaS will meet the current and future business demands.

TECHNICAL AND BUSINESS BENEFITS

The consensus from the DBaaS Post Implementation Review was that Fusion Professionals had successfully transformed the infrastructure to a platform capable of delivering ‘Database as a Service’ to the electricity distributor’s internal consumers. This not only enhanced the electricity distributor’s database offerings, it did so on time and within budget. Enabling the first Private Cloud PaaS capabilities and new features has resulted in the business being better able to proceed with its long-term business goals and strategies.

ACHIEVEMENTS

  • Fusion Professionals integrated two Exadata half Racks and ZFS appliance into the clients systems and established DBaaS private cloud platform.
  • Fusion Professionals designed, migrated, tested and accomplished various live database migrations without any service impact.
  • Fusion Professionals rebuilt the Data guard DR solutions onto the Exadata Platform.

Fusion Insights

Moving out from proprietary software seems like a daredevil act, considering the possible data security issues some open source databases…

MORE INFORMATION

The Challenge Complex IT environments can pose significant technical risk that, if not managed adequately, have the potential of major…

MORE INFORMATION

Fusion Professionals has signed a partnership agreement with Waterline Data ( https://www.waterlinedata.com/ ) the leading provider of Information Catalogs and…

MORE INFORMATION

Most people do not like change. As much as possible, they want things to stay the same that is why,…

MORE INFORMATION

Regardless of your infrastructure whether you are running in the cloud or on-premise, there will always be a need to…

MORE INFORMATION

Data Analytics tools provide Data Scientists and Data Engineers with the instruments to find patterns in data and provide business…

MORE INFORMATION

Fusion Professionals held its Fusion Meld 2018 event last Thursday, the 17th of May at the Terrace Hotel in North…

MORE INFORMATION

Over the past 10 years, data has grown into a behemoth that dominates business intelligence. A huge percentage of the…

MORE INFORMATION

A data lab is a well-equipped environment that allows organisations to explore and examine new ideas by combining new data…

MORE INFORMATION

Technology is changing our world at a rapid rate. For companies to stay competitive they must adapt to the changing…

MORE INFORMATION

Another 12 months passes and the AWS Summit rolls into town, now hosted at the new impressive Sydney ICC!   So what…

MORE INFORMATION

DevOps has well and truly arrived. Having a team combining development and operations is superseding the traditional model where these…

MORE INFORMATION

We may not know it, but we’re consuming huge amounts of data every day. Whether it’s through Siri, Google, Microsoft,…

MORE INFORMATION

Fusion Professionals, a Sydney-based IT consulting firm and a Gold level member of the Oracle Partner Network (OPN) today announced…

MORE INFORMATION

This week Fusion Professionals held their annual summit at the Rag & Famish hotel in North Sydney. The summit is…

MORE INFORMATION

Working with a large, well-resourced enterprise has many benefits –  including having the scope to look at new ways of…

MORE INFORMATION

Who doesn’t like some certainty in their lives?! It’s human nature to crave it. So, when we are lining up…

MORE INFORMATION

Building a business case is a familiar and routine process for any IT investment project. But is there a possibility…

MORE INFORMATION

Fusion Professionals and Australian research and advisory firm BigInsights, recently hosted an industry breakfast to discuss how organisations can capitalise…

MORE INFORMATION

Are you considering taking advantage of the Amazon Web Services (AWS) platform but are concerned about the risks involved in…

MORE INFORMATION