Welcome!

@CloudExpo Authors: Yeshim Deniz, Liz McMillan, Elizabeth White, Zakia Bouachraoui, Pat Romanski

Related Topics: @CloudExpo, Microservices Expo

@CloudExpo: Article

The New DBA for the Cloud

Five skills that enterprise DBAs need to acquire to manage cloud

Cloud Database Administration:
Database administration skills are the core of traditional enterprises in the data center. DBAs with skills in replication, backup, recovery and  clustering have been in high demand over the years due to the way the enterprises have taken care all aspects of the database administration.

However, the advent of the Cloud has shifted much of the DBA duties from the Cloud Consumer  (Enterprises) to the Cloud Providers (EC2, Azure and more).

Is the role of DBA irrelevant in a Cloud world? This article discuss five new skills that regular enterprise DBAs should acquire to make their presence as unique as always.

1. Improve On NOSQL Database Usage And Skills
In computing, NoSQL is a term used to designate database management systems that differ from classic relational database management systems in some way. In a cloud managed environment, NOSQL databases are here to stay, and they have their own advantages especially  in processing large amounts of distributed data.

  • Google's BigTable
  • Amazon SimpleDB
  • Windows Azure Storage BLOB Storage

All the above mean that the Non-Relational database usage is here to stay and the current DBAs should identify appropriate usage and maintenance of them.

2. Capacity Planning in Terms of On-Demand Usage Cost
Over the years, DBAs have been very successful in reactive monitoring of storage usages in terms of  GB, TB of disk space and also in predicting future capacity planning. However, as the entire trust of Cloud Computing is about a chargeback model based on storage, it becomes even more important for the DBA to understand the costing models behind the storage and help the enterprise with the best model possible for a given cloud provider.

  • For example, SQL Azure Business Edition databases are charged at $99.99 up to 10 GB per month and goes on based on further storage , Data transfers = $0.10 in / $0.15 out / GB - ($0.10 in / $0.20 out / GB in Asia)
  • Similar Amazon RDS On Demand DB Instances cost $2.60 price per hour for a extra large DB instance and similarly data transfers are priced separately. Apart from this the concept of Reserved Instances and Backup storage additionally alter the pricing.

With the additional concepts behind Cloud storage and pricing, it is the DBAs who need to have these details behind them and can provide the organizations about accurate information of how the storage and usage costs of the database will look like in a cloud environment.

3. Multi Tenancy & Data Partitioning
Earlier DBAs have big  servers and databases with unlimited storage at their disposal and most times the databases have been exclusively owned by enterprise vertical domains and  very little DBAs worried about the size of a single database and the  tenants who share the database.

  • SQL Azure has a 50 GB Limit per database
  • For each DB Instance class, AmazonRDS provides you with the ability to select from 5 GB to 1 TB of associated storage capacity for your primary data set. While the storage is unlimited , provisioning storage on demand rather pre allocating , makes it more efficient.

The new limitations in the database storage and the need to store multiple tenants require DBAs to think of different ways of partitioning data across multiple databases, which will go a long way toward an efficient data organization for Cloud.

4. Monitoring
On-demand instances are provisioned based on the  usage of the application and hourly demands. Also  much of the  instances  are virtual server based and the IP Addresses that connect are virtual and may get changed over time. All these require that much more  monitoring capabilities need to be brought in by the DBAs to make sure how the databases behave to the demands and how they can be managed.

  • Amazon RDS makes DB Instance metrics available via theAmazon AWS CloudWatch service. You can access your metrics using theAmazon CloudWatch API Toolsor via the API itself.
  • MicrosoftSQL Azure Database enables a subset of dynamic management views to diagnose the performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on.

The above concepts clearly proves that the traditional DBA needs to know new tools and  new concepts behind monitoring a Cloud Database.

5. Data In & Data Out  Between Cloud & Data Centers
For very small organizations, it would almost be impossible for an enterprise to run its entire business on the Cloud. So with the Cloud adoption it will still be a hybrid environment of:

  • Continued usage of ‘On Premise' data center for mission critical applications
  • SaaS usage for certain scenarios
  • PaaS or IaaS usage for other scenarios

In this Hybrid situation, it's important for the DBA to have all the options to move data in and out of the cloud seamlessly in an efficient manner.

With SQL Azure Data Sync CTP2  Microsoft  delivering an update to SQL Azure Data Sync to enable synchronization between on-premises SQL Server and SQL Azure, giving customers greater flexibility in building solutions that span on-premises and the cloud. With SQL Azure Data Sync CTP2, customers can:

  • Extend enterprise data to the cloud rather than replace it
  • Move workloads to the cloud in stages preserving investment in existing infrastructure
  • Extend data to remote offices and retails stores
  • Enable new scenarios spanning enterprise and cloud

Similarly  Amazon RDS has multiple tools based on MYSQL Engine that supports loading data from  data center applications into Cloud.

Summary
Cloud has abstracted certain traditional DBA needs in an enterprise:

  • Installation
  • Backup
  • Recovery
  • Replication
  • Stand By Servers
  • Fail Over Servers

Cloud has indeed brought in new DBA skill requirements and hence the role of DBA is as important as before in a cloud managed environment. However, now the DBAs can concentrate more on the business needs and can support the ‘Do More With Less' slogan that marks the  Cloud Platform usage in enterprises.

More Stories By Srinivasan Sundara Rajan

Highly passionate about utilizing Digital Technologies to enable next generation enterprise. Believes in enterprise transformation through the Natives (Cloud Native & Mobile Native).

CloudEXPO Stories
CI/CD is conceptually straightforward, yet often technically intricate to implement since it requires time and opportunities to develop intimate understanding on not only DevOps processes and operations, but likely product integrations with multiple platforms. This session intends to bridge the gap by offering an intense learning experience while witnessing the processes and operations to build from zero to a simple, yet functional CI/CD pipeline integrated with Jenkins, Github, Docker and Azure.
The now mainstream platform changes stemming from the first Internet boom brought many changes but didn’t really change the basic relationship between servers and the applications running on them. In fact, that was sort of the point. In his session at 18th Cloud Expo, Gordon Haff, senior cloud strategy marketing and evangelism manager at Red Hat, will discuss how today’s workloads require a new model and a new platform for development and execution. The platform must handle a wide range of recent developments, including containers and Docker, distributed resource management, and DevOps tool chains and processes. The resulting infrastructure and management framework must be optimized for distributed and scalable applications, take advantage of innovation stemming from a wide variety of open source projects, span hybrid environments, and be adaptable to equally fundamental changes happen...
CloudEXPO New York 2018, colocated with DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Bill Schmarzo, Tech Chair of "Big Data | Analytics" of upcoming CloudEXPO | DXWorldEXPO New York (November 12-13, 2018, New York City) today announced the outline and schedule of the track. "The track has been designed in experience/degree order," said Schmarzo. "So, that folks who attend the entire track can leave the conference with some of the skills necessary to get their work done when they get back to their offices. It actually ties back to some work that I'm doing at the University of San Francisco which creates an "Outcomes-Centric Business Analytics" degree." Bill Schmarzo, author of "Big Data: Understanding How Data Powers Big Business" and "Big Data MBA: Driving Business Strategies with Data Science" is responsible for guiding the technology strategy within Hitachi Vantara for IoT and Analytics. Bill brings a balanced business-technology approach that focuses on business ou...
For years the world's most security-focused and distributed organizations - banks, military/defense agencies, global enterprises - have sought to adopt cloud technologies that can reduce costs, future-proof against data growth, and improve user productivity. The challenges of cloud transformation for these kinds of secure organizations have centered around data security, migration from legacy systems, and performance. In our presentation, we will discuss the notion that cloud computing, properly managed, is poised to bring about a digital transformation to enterprise IT. We will discuss the trend, the technology and the timeline for adoption.