Case Study : Transforming the infrastructure to a platform capable of delivering ‘Database as a Service’

The Client is a Government Health Organisation, operating in providing World-class, patient-centred and digitally enabled healthcare with the goal “‘the right care, in the right place, at the right time” for everyone.

OBJECTIVES

The Health Organisation invested in the deployment of a high-end Oracle Exadata and Cisco FlexPod hardware platforms to host their Oracle and SQL databases and was looking to implement a ‘Database as a Service’ (DBaaS) solution to be serviced from this equipment to provide:

  • A highly available and reliable Oracle and SQL Database Platform for internal Business applications based on an Exadata and Cisco FlexPod Maximum Availability Architecture (MAA); and
  • Reduced on-going license and support costs.

DELIVERABLE

Fusion Professionals were engaged to transform the infrastructure to a platform capable of delivering ‘Database as a Service’ to their internal consumers. The assignment encompassed providing our Solution Architecture, Cloud Platforms and Data Management expertise, to ensure the DBaaS platform and all PaaS capabilities were deployed in a timely and efficient manner with the least impact to the business. Tasked included architectural design, private cloud deployment, testing and transition of Database-as-a-service capabilities to consumption and support.

Fusion professionals were able to bring invaluable experience, delivering best practices to the entire lifecycle of the project.

DATABASE AS A SERVICE – CLOUD ARCHITECTURE AND DESIGN

Fusion Professionals success has historically stemmed from its Solution Architecture services and our wealth of experience in Cloud Platforms area aided the success of architecting entire DBaaS platform, designing DBaaS services and formulating costing for each service offerings.

Cloud Architecture established the DBaaS standards to be used and identified the 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 / service levels. The Cloud Architecture was instrumental in managing change, avoiding the duplication of work and facilitating the reuse of the components.

DATABASE AS A SERVICE – CLOUD DEPLOYMENT AND TRANSITION

The project prospered from Fusion Professionals specialism in Cloud Infrastructure (Exadata and FlexPod) and Database technologies (Oracle and MS SQL), outlining best practices, known pitfalls when moving to a clustered database and alternative solutions to common network and staging issues. At every stage creating detailed documentation for provisioning, migration procedure and test cases.

DATABASE AS A SERVICE – CLOUD OPERATE AND MONITOR

Fusion Professionals has rich experience in establishing cloud support model and end-to-end monitoring framework. The project benefited from our expertise to transit from plan & build to operate & monitor state. Thus, the DBaaS offerings have been consumed effectively and supported efficiently reducing on-going license and support costs as well as provide full cloud capabilities such as quicker provisioning, consumption based charge back and higher availability.

DATABASE AS A SERVICE – DATA MANAGEMENT

Our expertise in the database technologies and services required for Oracle Exadata and FlexPod resulted a robust and rapid solution delivery to maximise the return on cloud technology investment. Implementation risk were reduced by leveraging our proven transition methodology, experience and management services.

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

Using our Cloud platform optimisation and capacity forecasting capabilities, we have been continuously helping the Health Organisation to manage the lifecycle of DBaaS platform in terms of technology review, resource usage and data growth to ensure DBaaS meets current and future demands.

TECHNICAL AND BUSINESS BENEFITS

The consensus from the DBaaS Post Implementation Review was that Fusion Professionals’ successful transformation of the infrastructure to a platform capable of delivering ‘Database as a Service’ to their internal consumers, not only enhanced the department’s capabilities of the database offerings but indeed made it possible within the time-frame. Enabling first Private Cloud PaaS offerings, new features, the IT Health Organisation had never thought possible and ultimately resulting in the business being able to proceed with its long-term goals and strategies.

ACHIEVEMENTS

  • Created DBaaS Architecture solution to transform the infrastructure to a platform capable of delivering ‘Database as a Service’ to internal consumers.
  • Defined a fine grain service offerings, service catalogue and pricing model.
  • Successfully deployed provisioning, security, availability, monitoring and reporting DBaaS capabilities.
  • Reduced on-going license and support costs.

Fusion Insights

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

Fusion Professionals is a proud sponsor of the Nikola Tesla – Unlimited Mind Exhibition in Sydney.  For the very first…

MORE INFORMATION