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

Human-to-machine communication has not yet been perfected, but enterprises are already beginning to integrate this groundbreaking technology into their operations,…

MORE INFORMATION

Fusion Professionals has signed a partnership agreement with MapR Technologies, provider of the industry’s leading data platform for AI and…

MORE INFORMATION

“Big data is at the foundation of all of the megatrends that are happening today, from social to mobile to…

MORE INFORMATION

In recent years data volumes have been increasing dramatically. This has created major challenges for traditional analytics platforms in terms…

MORE INFORMATION

With the increasing volumes of data that can be cost effectively stored in the cloud, comes increasing responsibility. The current…

MORE INFORMATION

With the advancement of technology and abundance of data your business receives on a daily basis, companies are now in…

MORE INFORMATION

Fusion Professionals held its annual Fusion Summit last Thursday the 18th of October at the Rag and Famish Hotel in…

MORE INFORMATION

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