Transcript here - Fountainhead Technologies, Inc.

To be successful, database
administration outsourcing
requires careful planning and
execution.
Concerns…







What is involved in administrating databases?
Why outsource database administration?
What are the challenges faced when outsourcing?
What tasks can be outsourced?
What are the types of outsourcing models?
How do you succeed in outsourcing?
What is the future of database outsourcing?
Role of operational DBA

Install, upgrade, and migrations

Troubleshooting and corrective actions

Space and account management

Database monitoring and reporting

Performance and tuning
Distribution of time
Backup rec
load/unload
Security planning
License/doc training
5% 5%
Scripting coding
20%
5%
25%

Backup and recovery

Capacity planning

Data load/unload and
synchronization
40%
Performance/tr
oubleshoot
Install, upgrade,
patch, migration
Role of application DBA
Distribution of time
• Database design and modeling
• Application administration
• Coding — SP, triggers, objects etc
Backup and security
Coding and
tuning
5%
5%
Doc/training
25%
• New install, upgrade and migrations
• Backup and recovery
• Define process and integration
• Documentation
• Backup DBA for operational systems
15%
Install,
upgrade, load
50%
Apps admin and
DB design
Database administration challenges
Resource
issues
Security issues
6%
Backup/recovery
Rep/sync
Planning
6%
8%
26%
Perf/troubleshoot
8%
11%
21%
14%
Change mgt.
Forrester survey: 52 Enterprises with $500 or more in revenue, 2004
Patch/upgrade
Why outsource database administration?
• To save money
• Most administration tasks can be managed remotely
• Databases are becoming a commodity
• Other infrastructure components are being outsourced
• Stable environment, with minimal changes
• Free internal resources for other purposes
• Get resources that are not available internally
What are the outsourcing challenges?
• Lack of security
• Poor turnaround time
• Hidden costs
• Minimal cost savings
• Quality of service
• Lack of depth in troubleshooting
• Lack of business knowledge
• Lack of performance metrics
• Communication issues
Do you currently or plan to outsource database
administration?
Yes
Don’t know
16%
15%
69%
No
Source: 52 enterprises surveyed with $500 or more in revenue, 2004
Have you seen the expected savings from offshoring IT?
40%
37%
28%
19%
20%
7%
2%
0%
Too early to
tell
Have seen the
savings that we
expected
43 North American IT and business executives, Jan. 04
Have seen
savings but not
what we
expected
Have not
achieved any
savings
Savings have
exceeded our
expectations
What administration tasks can be outsourced?
Administration tasks
Success rate
Patch deployment
High, except complex patches*
Upgrades
Moderate, avoid large upgrades*
Backup & verification
High
Space management
High
DBMS tuning
High
SQL tuning
High
Proactive monitoring
High
DBMS install
Low, difficult to perform remotely*
Security management
Moderate, avoid*
Object management
Moderate, should be supported internally
HA management
High, except initial setup
DR management
High, except initial setup
Data load/unload
High, can be automated and monitored
Database recovery
Moderate, depends on complexity of environment*
Startup/shutdown DBMS
High, but depends on DBMS support
Auditing
High
* Will change in future
Database administration outsourcing model
Partial outsourcing
Database
Tech Support
Remote Admin
Agents
DB
DB
DB
Users
Company A
Location 1
DB
Admin
Location 2
Database administration outsourcing model
Complete outsourcing
DB
DB
Data center
Company A
Remote admin
Users
Database
tech support
Top database administration outsourcing vendors
Large vendors
Small vendors

IBM

Fountainhead Technologies

Oracle

DbaDirect

EDS

Ntirety

Pythian
Offshore vendors

TCS

Satyam

Wipro
How to succeed in outsourcing?

Before making a decision
 Consolidate
 Standardize
 Formalize
 Stabilize
 Secure


Perform a cost-benefit and impact analysis
Choose the right vendor
How to select an outsourcing vendor?






Operational center — Location,
Infrastructure, redundancy
Expertise — DBMS, apps, other
technology stack layers

Tools used — Agents, frequency

Accountability – How handled

SLAs — Response time
Hidden costs — What is not
covered?
Administrators located —
Geographic locations
Security infrastructure — Access
to data, VPN

Formalize — Steps and
documented procedures
Reports provided — Portals,
frequency

Support coverage — 24x7

References — Ask for them

Communications — Issues, clarity
DBA to database ratio
• Current ratio:
» A DBA manages up to 1 TB database collectively
» Average 21 databases per DBA
8,000
Databases
50
Databases
40
30
5,000
DB Size
20
2,000
10
0
-1,000
2001 2002 2003 2004 20052006 2007 2008 2009 2010
Source: Forrester Research
(GB) - Collective DB Size
60
Forecast: Database administration challenges
Performance & tuning
Patch/Upgrade
B&R
Security
2002
2003
2004
2005
2006
2007
2008
2009
2010
Database administration cost is declining
($) Administration cost
14000
12000
10000
8000
6000
4000
2000
0
2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
Future of database outsourcing




Utility-based model
More aggressive pricing
More vendors will offer such service
Complete stack level integrated focus
Recommendations





Understand the impact on operations/applications
Determine cost benefits
Flush out security concerns
Understand the vendor’s position
Small companies should look at full outsourcing
Contact Information
Anthony Co
[email protected]
Ferdinand Reyes
[email protected]
+63 918 8883338