π Who is the Database Administrator?
A Database Administrator (DBA) is a professional responsible for managing, maintaining, and securing databases within an organization. The DBA ensures that databases are available, reliable, efficient, and secure.
<div class="infographic-dba" id="dbaWrap">
<style>
.infographic-dba {
--ink: #1a1a1a;
--ink-soft: #5c5c5c;
--paper: #ffffff;
--paper-alt: #f6f3ee;
--accent: #2563eb;
--accent-soft:#e3ebfd;
--line: #ddd6c9;
background: var(--paper);
color: var(--ink);
font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Helvetica, Arial, sans-serif;
padding: 2.5rem 1.5rem;
border-radius: 14px;
box-sizing: border-box;
max-width: 920px;
margin: 0 auto;
}
.infographic-dba[data-theme="dark"] {
--ink: #e8e6e1;
--ink-soft: #9a968c;
--paper: #121212;
--paper-alt: #1e1e26;
--accent: #5b8def;
--accent-soft:#202942;
--line: #2c313d;
}
.infographic-dba * { box-sizing: border-box; }
.dba-eyebrow {
font-size: 0.72rem; letter-spacing: 0.12em; text-transform: uppercase;
color: var(--accent); font-weight: 700; margin: 0 0 0.4rem;
}
.dba-title { font-size: 1.55rem; font-weight: 700; margin: 0 0 0.4rem; letter-spacing: -0.01em; }
.dba-sub { font-size: 0.9rem; color: var(--ink-soft); margin: 0 0 1.75rem; max-width: 55ch; }
/* --- Hub: grid + detail panel (desktop) --- */
.dba-hub { display: grid; grid-template-columns: 1.1fr 1fr; gap: 1.5rem; align-items: start; }
.dba-grid {
display: grid; grid-template-columns: repeat(2, 1fr); gap: 0.6rem; align-content: start;
}
.dba-cell { display: flex; flex-direction: column; }
.dba-item {
display: flex; align-items: center; gap: 0.65rem;
background: var(--paper-alt); border: 1px solid var(--line); border-radius: 9px;
padding: 0.6rem 0.7rem; font: inherit; color: var(--ink); text-align: left;
cursor: pointer; transition: border-color .15s, background .15s;
width: 100%;
}
.dba-item:hover { border-color: var(--accent); }
.dba-item.is-active { background: var(--accent-soft); border-color: var(--accent); }
.dba-badge {
flex: 0 0 auto; width: 26px; height: 26px; border-radius: 50%;
background: var(--paper); border: 1.5px solid var(--line);
display: flex; align-items: center; justify-content: center;
font-size: 0.72rem; font-weight: 700; color: var(--ink-soft);
}
.dba-item.is-active .dba-badge { border-color: var(--accent); color: var(--accent); }
.dba-item-label { font-size: 0.82rem; font-weight: 600; line-height: 1.25; }
.dba-panel {
background: var(--paper-alt); border: 1px solid var(--line); border-radius: 12px;
padding: 1.4rem 1.5rem; min-height: 220px;
}
.dba-panel > *:last-child { margin-bottom: 0; }
.dba-panel-title { font-size: 1.05rem; font-weight: 700; margin: 0 0 0.9rem; color: var(--accent); }
.dba-panel-list { margin: 0; padding-left: 1.1rem; font-size: 0.9rem; line-height: 1.55; }
.dba-panel-list li { margin-bottom: 0.4rem; }
.dba-panel-list li:last-child { margin-bottom: 0; }
/* --- Inline accordion detail (mobile only, hidden on desktop) --- */
.dba-detail {
display: none;
overflow: hidden;
max-height: 0;
opacity: 0;
}
.dba-detail-inner {
background: var(--accent-soft); border: 1px solid var(--line); border-top: none;
border-radius: 0 0 9px 9px; padding: 0.7rem 0.8rem; margin-top: -1px;
}
.dba-detail-list { margin: 0; padding-left: 1.1rem; font-size: 0.8rem; line-height: 1.45; }
.dba-detail-list li { margin-bottom: 0.3rem; }
.dba-detail-list li:last-child { margin-bottom: 0; }
@media (max-width: 700px) {
.dba-hub { grid-template-columns: 1fr; gap: 0; }
.dba-grid { grid-template-columns: 1fr; gap: 0.5rem; }
.dba-panel { display: none; }
.dba-cell.is-active .dba-item { border-radius: 9px 9px 0 0; }
.dba-detail {
display: block;
transition: max-height .35s ease, opacity .3s ease;
}
.dba-cell.is-active .dba-detail {
max-height: 260px;
opacity: 1;
}
}
@media (prefers-reduced-motion: reduce) {
.infographic-dba *, .infographic-dba *::before, .infographic-dba *::after {
animation-duration: 0.001ms !important; transition-duration: 0.001ms !important;
}
}
</style>
<p class="dba-eyebrow">Behind the Scenes</p>
<h2 class="dba-title">Roles & Responsibilities of a DBA</h2>
<p class="dba-sub">Nine things a database administrator handles daily β click one to see what's involved.</p>
<div class="dba-hub">
<div class="dba-grid" id="dbaGrid"></div>
<div class="dba-panel" id="dbaPanel"></div>
</div>
</div>
<script>
(function () {
var wrapper = document.getElementById('dbaWrap');
// Dark mode detection β body attribute wins, then cookie, then light default
var bodyAttr = document.body.getAttribute('data-darkmode');
var dark;
if (bodyAttr === 'true') {
dark = true;
} else if (bodyAttr === 'false') {
dark = false;
} else {
var match = document.cookie.match(/(?:^|;\s*)darkMode=([^;]+)/);
dark = match ? match[1] === 'true' : false;
}
if (dark) wrapper.setAttribute('data-theme', 'dark');
var duties = [
{ title: 'Installation & Configuration', points: [
'Setting up new database systems β Oracle, MySQL, SQL Server, PostgreSQL.',
'Configuring the database software and underlying hardware.'
]},
{ title: 'Database Maintenance', points: [
'Performing regular tasks such as backups, updates, and patches.'
]},
{ title: 'Performance Tuning', points: [
'Optimizing performance by analyzing queries and indexing.',
'Monitoring system resources and tuning configurations.'
]},
{ title: 'Backup & Recovery', points: [
'Creating and managing backup strategies.',
'Restoring data after failures or accidental loss.'
]},
{ title: 'Security Management', points: [
'Setting up user roles and permissions.',
'Ensuring only authorized users can access sensitive data.'
]},
{ title: 'Data Integrity & Consistency', points: [
'Enforcing rules and constraints to keep data accurate.'
]},
{ title: 'Monitoring & Troubleshooting', points: [
'Detecting and resolving database errors or slowdowns.'
]},
{ title: 'Capacity Planning', points: [
'Forecasting future database growth and planning for scalability.'
]},
{ title: 'Documentation', points: [
'Maintaining up-to-date documentation on configurations and procedures.'
]}
];
var grid = document.getElementById('dbaGrid');
var panel = document.getElementById('dbaPanel');
function listHtml(points, cls) {
var html = '<ul class="' + cls + '">';
points.forEach(function (p) { html += '<li>' + p + '</li>'; });
html += '</ul>';
return html;
}
function renderPanel(i) {
var d = duties[i];
panel.innerHTML = '<h3 class="dba-panel-title">' + d.title + '</h3>' + listHtml(d.points, 'dba-panel-list');
}
var cells = [];
duties.forEach(function (d, i) {
var cell = document.createElement('div');
cell.className = 'dba-cell' + (i === 0 ? ' is-active' : '');
var btn = document.createElement('button');
btn.type = 'button';
btn.className = 'dba-item' + (i === 0 ? ' is-active' : '');
btn.innerHTML = '<span class="dba-badge">' + (i + 1) + '</span><span class="dba-item-label">' + d.title + '</span>';
var detail = document.createElement('div');
detail.className = 'dba-detail';
detail.innerHTML = '<div class="dba-detail-inner">' + listHtml(d.points, 'dba-detail-list') + '</div>';
btn.addEventListener('click', function () {
cells.forEach(function (c) {
c.classList.remove('is-active');
c.querySelector('.dba-item').classList.remove('is-active');
});
cell.classList.add('is-active');
btn.classList.add('is-active');
renderPanel(i);
});
cell.appendChild(btn);
cell.appendChild(detail);
grid.appendChild(cell);
cells.push(cell);
});
renderPanel(0);
})();
</script>.demo {
font-family: system-ui, sans-serif;
padding: 16px;
}
.demo h1 {
color: #2563eb;
margin: 0 0 8px;
}
.demo p {
color: #4b5563;
margin: 0;
}document.querySelector('.demo h1')?.addEventListener('click', () => {
alert('Hello from live preview!');
});Types of DBAs:
System DBA β Focuses on the physical aspects like installation and performance tuning.
Application DBA β Works closely with developers to optimize application-specific databases.
Development DBA β Helps design and implement databases during application development.
Data Warehouse DBA β Specializes in managing large-scale data warehouses.