The Onsite DBA Service makes use of the Installgen
and Repgen applications
and other 3rd party applications to provide an extensive range of
services billed at an economical
hourly rate. These services include database installations requiring
customization beyond the standard fixed price install service. Database
analysis, troubleshooting, Advanced
Replication implementation, standby
database implementation, and performance
tuning services are also available.
The features and benefits of using the Onsite DBA Service
include:
Well
Documented and Standardized Process - The services performed as
part of the Onsite DBA service are well documented during the task
completion process. Tasks
which can be performed with the Repgen
or Installgen applications
are documented and available for client review prior to the start
of work.
Implementation
of Oracle Best Practices - If possible, the Onsite DBA service will
make use of scripts, procedures and documentation generated by the
Repgen and Installgen
applications. Extra care has been taken to include Oracle´s
best practices into each script because the philosophy is to write
the scripts once, but write them with the highest possible quality.
This means generating scripts to perform multiple
backup procedures for each new database installation in order
to give the DBA the flexibility to pick the most appropriate procedure
to use for a particular database instance. This means setting up 3
conflict resolution methods when configuring Advanced Replication
based upon actual production server experience.
Improve
Skillsets - The Onsite DBA service provides specialized Oracle DBA
skills in areas such as Advanced
Replication, Backup
and Recovery strategies and high availability server design. A
short term consulting project by .com Solutions Inc. can improve the
skillsets of your staff DBAs in these specialized areas.
2x
- 8x Improved PL/SQL Performance - PL/SQL performance can be improved
2 - 8 times over interpreted performance by taking advantage of Oracle
9i native PL/SQL compilation on Solaris servers.
15
Database Recovery Scenarios - A comprehensive listing of common
database recovery scenarios is can be created for new or existing
databases. Virtually all of these recovery scenarios contain customized
text using the parameters which were entered into the Installgen
graphical
interface. Each commonly required recovery process is documented
well in advance of the time when it will be needed in order to reduce
mistakes. During the high-stress environment of a database recovery
you don´t want to be looking around for notes concerning how
to recover your database. This information pre-written, and customized
for the exact database you are recovering. Each scenario is summarized
at the start of this section of the document in order to reduce the
amount of time required to find this vital information.
The Onsite DBA service follows the same support
matrix as the Installgen
and Repgen
applications. These support matrixes are referenced in order to take
advantage of the core competencies of .com Solutions Inc. staff.
Installgen
Demo Available for download...
Repgen
Demo Available for download...
