Database Automation for the DBA Shortage

By Robert Gardos

September 12, 2008

As the amount of data continues to grow, the need for experienced database administrators (DBAs) is exploding. The U.S. Department of Labor and Statistics reports that employment of DBAs is expected to grow significantly and outpace the growth of all other occupations through 2016. The DBA has a very specific, technical set of skills that makes the position one of the most difficult to fill in the datacenter. With only a handful of skilled database administrators, many companies will struggle to meet this demand.

Database automation is going to play a much greater role for future success. By implementing database automation technologies, DBAs can focus on strategic issues and allow junior staff to perform tasks traditionally executed by more skilled workers. This is a win-win situation for business decision makers; the highly skilled DBAs can focus on revenue-generating strategy, while the less skilled employees can maintain compliance metrics and best practices.

According to the leading analysts, DBAs spend the vast majority of their time performing mundane tasks that focus on keeping the ship afloat. Senior DBAs have been reduced to robot operators, following run books, escalating to support, and constantly reacting to the latest wave of fires. When you consider that these are your data people and the importance of understanding your data can mean a company’s success or failure, it is surprising that so little has been done to change this situation, especially considering the following:

  • The number of databases and amount of data tracked is growing, and growing fast.
  • Database environments are getting more complex as the number of databases and amount of data within those databases continue to increase. Combined with hundreds of different patch levels, the introduction of new versions and security updates, it’s all DBAs can do to keep up with their job.
  • The DBA is a high-turnover position. Nearly half of all DBAs will leave their job within 24 months. Additionally, the DBA is one of the most difficult positions for an organization to replace.

With these concerns and the U.S. Department of Labor and Statistics reporting that the “database administrators occupation is expected to grow 37 percent,” how will you prepare for the demand? As the amount of data under management and the standards by which that data is managed are exponentially increasing, companies have no choice but to alter the way they manage information. Automation is the answer.

While automation has spread widely across the datacenter, DBAs have yet to apply these principles to the database. Companies need to implement a centralized, automated mechanism to manage their databases. With automation tools, senior DBAs are free to stop “pushing buttons.” They can give the repetitive tasks to less skilled workers and focus more on strategy and revenue-generating practices. Meanwhile, mid-level workers can take on roles that were traditionally reserved for the IT industry experts. Because automation eliminates human error, business leaders can be assured that jobs are performed to their satisfaction.

Once the power of automation is realized, the implementation begins. The first step toward implementing a complete automation solution is creating an extensible and maintainable framework. This framework must be able to handle several system requirements, such as deploying an entity to a server, executing a script in the context of a database object, and removing the database object. However, it is quite challenging to create a framework that is adaptable enough to manage complex databases and is easy to use. Interacting with a complex application, such as Oracle DBMS or Microsoft SQL Server, requires running several commands, each with unique arguments and each in a unique way to determine if the task was successful or not. Frequently, running these specific commands requires the execution of additional commands just to judge the results of a prior act. The framework must be able to deal with these interactions independent of the architecture (e.g., clustered, non-clustered) and environment (e.g., different operation systems, different database versions, etc.).

Each organization also has customizations beyond the scope of managing the actual database application that must be integrated into the automation framework. These requirements can exceed the complexity of the core database automation. In many cases, organizations can leverage preexisting work to ensure this logic is incorporated into the activities being automated.

It’s not a good use of time or money to design or implement your own automation framework and scripts to manage the database. It’s also unlikely you are the only candidate for automation, so if you are considering automation, it’s best to buy rather than build this aspect of your infrastructure. There are solutions that have this framework and come with pre-built automation that understands and adapts to database versions, operating systems and architecture. There is a constant stream of work required to update an automation framework based on new requirements. Beyond that, the actual code used to call out to the managed applications is fluid, due to the managed software updates.

Implementing an automation process for your DBAs to manage is a win-win solution for business decision makers. It allows the highly skilled DBAs to focus on revenue-generating strategy, while the less skilled employees maintain compliance metrics and best practices. If companies are able to adopt an automation strategy into the mix, they will be able to leverage the skills of their existing staff, without hiring additional staff in the coming years. Given that the U.S. Department of Labor and Statistics has predicted that employment of DBAs is expected to grow “much faster than average,” demand for this type of skilled worker is very high and qualified candidates will demand highly competitive salary and benefit packages. Why not make them as efficient as they can be? Now is the time for organizations to consider automation as an essential part of running an effective database environment.

Subscribe to HPCwire's Weekly Update!

Be the most informed person in the room! Stay ahead of the tech trends with industry updates delivered to you every week!

MLPerf Inference 4.0 Results Showcase GenAI; Nvidia Still Dominates

March 28, 2024

There were no startling surprises in the latest MLPerf Inference benchmark (4.0) results released yesterday. Two new workloads — Llama 2 and Stable Diffusion XL — were added to the benchmark suite as MLPerf continues Read more…

Q&A with Nvidia’s Chief of DGX Systems on the DGX-GB200 Rack-scale System

March 27, 2024

Pictures of Nvidia's new flagship mega-server, the DGX GB200, on the GTC show floor got favorable reactions on social media for the sheer amount of computing power it brings to artificial intelligence.  Nvidia's DGX Read more…

Call for Participation in Workshop on Potential NSF CISE Quantum Initiative

March 26, 2024

Editor’s Note: Next month there will be a workshop to discuss what a quantum initiative led by NSF’s Computer, Information Science and Engineering (CISE) directorate could entail. The details are posted below in a Ca Read more…

Waseda U. Researchers Reports New Quantum Algorithm for Speeding Optimization

March 25, 2024

Optimization problems cover a wide range of applications and are often cited as good candidates for quantum computing. However, the execution time for constrained combinatorial optimization applications on quantum device Read more…

NVLink: Faster Interconnects and Switches to Help Relieve Data Bottlenecks

March 25, 2024

Nvidia’s new Blackwell architecture may have stolen the show this week at the GPU Technology Conference in San Jose, California. But an emerging bottleneck at the network layer threatens to make bigger and brawnier pro Read more…

Who is David Blackwell?

March 22, 2024

During GTC24, co-founder and president of NVIDIA Jensen Huang unveiled the Blackwell GPU. This GPU itself is heavily optimized for AI work, boasting 192GB of HBM3E memory as well as the the ability to train 1 trillion pa Read more…

MLPerf Inference 4.0 Results Showcase GenAI; Nvidia Still Dominates

March 28, 2024

There were no startling surprises in the latest MLPerf Inference benchmark (4.0) results released yesterday. Two new workloads — Llama 2 and Stable Diffusion Read more…

Q&A with Nvidia’s Chief of DGX Systems on the DGX-GB200 Rack-scale System

March 27, 2024

Pictures of Nvidia's new flagship mega-server, the DGX GB200, on the GTC show floor got favorable reactions on social media for the sheer amount of computing po Read more…

NVLink: Faster Interconnects and Switches to Help Relieve Data Bottlenecks

March 25, 2024

Nvidia’s new Blackwell architecture may have stolen the show this week at the GPU Technology Conference in San Jose, California. But an emerging bottleneck at Read more…

Who is David Blackwell?

March 22, 2024

During GTC24, co-founder and president of NVIDIA Jensen Huang unveiled the Blackwell GPU. This GPU itself is heavily optimized for AI work, boasting 192GB of HB Read more…

Nvidia Looks to Accelerate GenAI Adoption with NIM

March 19, 2024

Today at the GPU Technology Conference, Nvidia launched a new offering aimed at helping customers quickly deploy their generative AI applications in a secure, s Read more…

The Generative AI Future Is Now, Nvidia’s Huang Says

March 19, 2024

We are in the early days of a transformative shift in how business gets done thanks to the advent of generative AI, according to Nvidia CEO and cofounder Jensen Read more…

Nvidia’s New Blackwell GPU Can Train AI Models with Trillions of Parameters

March 18, 2024

Nvidia's latest and fastest GPU, codenamed Blackwell, is here and will underpin the company's AI plans this year. The chip offers performance improvements from Read more…

Nvidia Showcases Quantum Cloud, Expanding Quantum Portfolio at GTC24

March 18, 2024

Nvidia’s barrage of quantum news at GTC24 this week includes new products, signature collaborations, and a new Nvidia Quantum Cloud for quantum developers. Wh Read more…

Alibaba Shuts Down its Quantum Computing Effort

November 30, 2023

In case you missed it, China’s e-commerce giant Alibaba has shut down its quantum computing research effort. It’s not entirely clear what drove the change. Read more…

Nvidia H100: Are 550,000 GPUs Enough for This Year?

August 17, 2023

The GPU Squeeze continues to place a premium on Nvidia H100 GPUs. In a recent Financial Times article, Nvidia reports that it expects to ship 550,000 of its lat Read more…

Shutterstock 1285747942

AMD’s Horsepower-packed MI300X GPU Beats Nvidia’s Upcoming H200

December 7, 2023

AMD and Nvidia are locked in an AI performance battle – much like the gaming GPU performance clash the companies have waged for decades. AMD has claimed it Read more…

DoD Takes a Long View of Quantum Computing

December 19, 2023

Given the large sums tied to expensive weapon systems – think $100-million-plus per F-35 fighter – it’s easy to forget the U.S. Department of Defense is a Read more…

Synopsys Eats Ansys: Does HPC Get Indigestion?

February 8, 2024

Recently, it was announced that Synopsys is buying HPC tool developer Ansys. Started in Pittsburgh, Pa., in 1970 as Swanson Analysis Systems, Inc. (SASI) by John Swanson (and eventually renamed), Ansys serves the CAE (Computer Aided Engineering)/multiphysics engineering simulation market. Read more…

Choosing the Right GPU for LLM Inference and Training

December 11, 2023

Accelerating the training and inference processes of deep learning models is crucial for unleashing their true potential and NVIDIA GPUs have emerged as a game- Read more…

Intel’s Server and PC Chip Development Will Blur After 2025

January 15, 2024

Intel's dealing with much more than chip rivals breathing down its neck; it is simultaneously integrating a bevy of new technologies such as chiplets, artificia Read more…

Baidu Exits Quantum, Closely Following Alibaba’s Earlier Move

January 5, 2024

Reuters reported this week that Baidu, China’s giant e-commerce and services provider, is exiting the quantum computing development arena. Reuters reported � Read more…

Leading Solution Providers

Contributors

Comparing NVIDIA A100 and NVIDIA L40S: Which GPU is Ideal for AI and Graphics-Intensive Workloads?

October 30, 2023

With long lead times for the NVIDIA H100 and A100 GPUs, many organizations are looking at the new NVIDIA L40S GPU, which it’s a new GPU optimized for AI and g Read more…

Shutterstock 1179408610

Google Addresses the Mysteries of Its Hypercomputer 

December 28, 2023

When Google launched its Hypercomputer earlier this month (December 2023), the first reaction was, "Say what?" It turns out that the Hypercomputer is Google's t Read more…

AMD MI3000A

How AMD May Get Across the CUDA Moat

October 5, 2023

When discussing GenAI, the term "GPU" almost always enters the conversation and the topic often moves toward performance and access. Interestingly, the word "GPU" is assumed to mean "Nvidia" products. (As an aside, the popular Nvidia hardware used in GenAI are not technically... Read more…

Shutterstock 1606064203

Meta’s Zuckerberg Puts Its AI Future in the Hands of 600,000 GPUs

January 25, 2024

In under two minutes, Meta's CEO, Mark Zuckerberg, laid out the company's AI plans, which included a plan to build an artificial intelligence system with the eq Read more…

Google Introduces ‘Hypercomputer’ to Its AI Infrastructure

December 11, 2023

Google ran out of monikers to describe its new AI system released on December 7. Supercomputer perhaps wasn't an apt description, so it settled on Hypercomputer Read more…

China Is All In on a RISC-V Future

January 8, 2024

The state of RISC-V in China was discussed in a recent report released by the Jamestown Foundation, a Washington, D.C.-based think tank. The report, entitled "E Read more…

Intel Won’t Have a Xeon Max Chip with New Emerald Rapids CPU

December 14, 2023

As expected, Intel officially announced its 5th generation Xeon server chips codenamed Emerald Rapids at an event in New York City, where the focus was really o Read more…

IBM Quantum Summit: Two New QPUs, Upgraded Qiskit, 10-year Roadmap and More

December 4, 2023

IBM kicks off its annual Quantum Summit today and will announce a broad range of advances including its much-anticipated 1121-qubit Condor QPU, a smaller 133-qu Read more…

  • arrow
  • Click Here for More Headlines
  • arrow
HPCwire