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.
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.
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:-
- The provision and configuration of Solution Architecture, Cloud Platforms and Data Management to meet the Exadata MAA; and
- 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.
- 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.
The Client is one of major NSW government departments providing services to public. The Department had been experiencing performance issues…MORE INFORMATION
Though its conception dates back to 1979, containers made their mark as much needed, major technology assets in 2000. Digital…MORE INFORMATION
Objective The intelligent mobile app-based lending system is a new field, blending recent technical developments in mobile phones and Artificial…MORE INFORMATION
Our Client is a well-known Australian freight logistics company, operating in railway freight and shipping. The company embarked on a…MORE INFORMATION
Data warehouse management and data analytics always had the challenge to decide what data to store and for how long…MORE INFORMATION
Cloud computing is becoming a preferred storage platform for IT managers and organisations in general. In Australia alone, 31 percent…MORE INFORMATION
Serving your customer in the best possible, most efficient way should always be the major goal of any organisation. The…MORE INFORMATION
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