Scribd
Upload
100 views2 pages

DBA Tasks and Maintenance Guide

The document outlines the daily, weekly, monthly, and ongoing activities performed by a Database Administrator (DBA). Daily activities include managing database data, disk space, backups, auditing, and performance monitoring. Weekly activities involve database refreshes for testing, capacity planning, and application deployments. Monthly tasks include reclaiming unused space and patching the operating system. Ongoing responsibilities cover various database administration duties like user management, backups, security, performance tuning, documentation, and ensuring database availability.

Uploaded by

Hanumantha Rao Mallela
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
100 views2 pages

DBA Tasks and Maintenance Guide

The document outlines the daily, weekly, monthly, and ongoing activities performed by a Database Administrator (DBA). Daily activities include managing database data, disk space, backups, auditing, and performance monitoring. Weekly activities involve database refreshes for testing, capacity planning, and application deployments. Monthly tasks include reclaiming unused space and patching the operating system. Ongoing responsibilities cover various database administration duties like user management, backups, security, performance tuning, documentation, and ensuring database availability.

Uploaded by

Hanumantha Rao Mallela
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

DBA Activities:

1. Daily activities:

a. Addition/extending database datafiles for tablespace as required.


b. Diskspace usage/filesystem usage. i.e.., adding space to filesystem/cleaning up of
alert/trace log files.
c. Database backups – daily database backups like archive log backup, Level 0 and level 1
backups.
d. Auditing – User access, changes to database structure.
e. Database Health check. i.e.., CPU utilization, SWAP/memory utilization, Process
utilization.
f. Performance monitoring – I/O utilization, Database locks/Deadlocks, Contention, SQL
plan changes etc..

2. Weekly activities:

a. Database refresh activities – Database refresh to lower environments, Export/importing


tables/schemas to lower environments for testing/development.
b. Capacity planning – Any planned deployments that consumes space and memory.
c. Major application changes deployments.

3. Monthly Activities:

a. Database re-org – claiming unused space in the database.


b. OS Level patching if any.
c. Critical Database patching/PSU patching, bug fixes etc..

4. Other database housekeeping activities:


a. User account creation/deletion, delegation of roles, creating roles, profiles and
assignment. Providing/revoking grants to user as per requirement.
b. Wallet management for transparent data encryption, vault management and centrally
managed users.
c. Database backups failure fixes.
d. Application Code deployments.
e. Database security patching/bug fixes.
f. Fixing any database lag between prod and BCP databases.
g. Resolving replication issues for tables/schemas.
h. Database performance tuning such as indexing, tuning, gathering stats and sql plan
changes.
i. Supporting database design, creation, and testing activities as per business
requirements.
j. Enabling alert mechanism like alerting and ticket creating, incase of any unforeseen
incident/outages.
k. Monitoring transaction volumes, response time and database
locks/contention/concurrency wait times.
l. Design and schedule backup and storage architecture/implementation strategy.
m. Database upgrades/database home patching/ deploying one-off patches.
n. Deploying and enabling security mechanisms for integrity and availability.
o. Design and implementing database standby builds.
p. Database parameter changes like, SGA, PGA, stream pools, buffer cache, log size,
archival, listeners, etc...,
q. Managing views, indexing, partitioning, functions, stored procedures, assigning keys on
tables, materialized refresh activities etc…
r. Assist in database support activities as per request from application/development
teams.
s. Database administration tools like Dataguard, goldengate, Oracle enterprise manager,
Identity management, Catalog database management for backups, SQL developer,
Oracle client installation/de-installation/upgrades.
t. CMDB relationship.
u. Database documentation includes – memory, processes, network, storage, user
accounts, access delegation, application/business requirement and support as per
design.
v. Database availability, logical and physical corruption, configuring services etc…

You might also like