Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Day in the life of a DBA

No description
by

Donna Grewal

on 18 September 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Day in the life of a DBA

Day in the life of a DBA
DBA's within an Organisation
Different types
of DBAs

8am-5pm
What's it like to
be a DBA?

Frustrating
Pressure
Responsibility
Exciting
Rewarding
Oncall
24x7
Change Management
Production Problems
Daily Emails
Project Meetings
Dev refreshes
Monitoring
Performance
Disk Space
Logs filling up
ORA-123456 Errors
"The database is running slow"
Tablespace
filling up
Alert Log
Trace Files
Security
Reset Password
Log switches
Satisfying
Project vs
BAU
Apps
DBA
Proactive vs Reactive
Start/End
of Career
Too Much Pressure
Under-Resourced
Lost interest
Not listened to
Does what they have to
Look for the
Easy way
Not engaged in work
Job-hunting
Enjoy their work
More Time and resources
Happy
Look for ways
to improve things
Learning new technologies
and features
Do things better
and smarter
Save time,
be more efficient
Looking for a challenge
Improve knowledge
and skills
Good reputation
in business
Bureaucracy
DBA
Security
Change Management
Service Desk
Desktop Support
Business Owners + Users
Application Support
Project Managers
Testers
Developers
Storage Support
Unix/Windows
Support

What makes
the boss happy?

Performance
System Availability
SLA's met
Business/Customer
happy
Time saving
Resources going
further
Projects on time,
to budget
Timesheets
Done
Security
Efficient Problem resolution
Chocolate
Kittens on a
sunny day
Operations Managers
Architects
BA's

A SIDE NOTE:
How long does it take to do stuff? - why so long?
Small organisations have DBA's that do a little of lots of things
Large organisations have DBA's that have set boundries about what they can and can not do
Unix admin
Storage
Application Support
Get coffee
Help Desk
Be a DBA
Desktop Support
What happens
when there is a production problem?
Do that
Don't do that
That other group is
suppose to do that
You should have done that
- "but no one told me!"
Save Money
6-12+ Months
1-6months
DB Upgrade
Patch DB
Implement DR
Implement RAC
Create new database
DB Refresh
Performance Tuning
What process does a
funding request go through?
Team meetings
news/plans
Who does a DBA report to/
Structure of IT?
Do DBA's get a
say in DB direction?
Respected
Specialist
Empathy
Complex DB upgrade
Implement new application/system
Implement RAC
on complex systems
(Management of DB's)
When does a DBA usually get involved in a project?
Uptime
Response time to incidents
eg. 1hr for P1s
Service Level Agreements
Main reasons I've been asked to upgrade a DB??
Fear of Desupported Database - that's it!
New Features are great, but its of work to upgrade systems
lots
Small
Organisations
Large
Organisations
May think
they know better
Tried & Trusted
Scripts
Sell them stuff that makes things easier for them - they will like that
$$
$$
$$
$$
$$
$$
$$
$$
"Good place to start to ask who to talk to"
Full transcript