|
DBA Services covers all aspects of running a production database system including
production and development database support; software revisions; custom code support;
performance tuning; database management tasks including table, view, user and index
creation, security management; and backup and archival services.
The main reasons for using a remote DBA service:
High Quality - Junior Oracle DBAs are the bane of corporate
world. Oracle Corporation white papers suggest that more than 75% of all Oracle
database outages are attributable to human error. By hiring the services of
recognized Oracle experts, companies avoid the potential downtime.
Low Cost - With remote DBA services, you buy only those
DBA services that you require, and only at the levels you require the service.
Full - time Oracle DBAs commonly cost over $80,000/year and require more than $5,000
in training per year to keep them current with the technology. Many corporations
with stable Oracle databases cannot justify the costs of a full time DBA.
High Availability - With remote DBA support you can
be assured that your database is being supported by a competent professional who
is thoroughly familiar with your database. With a full-time DBA, high attrition
has become a major problem.
Security - Protecting your organization's privacy and
ensuring the integrity of your network and database security is critical.
We always provide connectivity to customer database management systems using established
customer security methodologies. We safeguard your information, comply with
all regulations and laws related to privacy, and assess new technologies for protecting
your information as they become available.
Benefits to Clients:
- Single point of contact
- Minimized costs for database administration
- Consistent staffing solution
- Convenient annual contract
Services:
Installation and Configuration :
- Installation of ORACLE, Sybase, MS-SQL RDBMS on different platforms like Microsoft
Windows NT / 2000 / 2003 and Linux
- Hardware, operating system and database planning services for new systems
- Resolving the installation issues for better performance
- Capacity planning
- Storage layout and configuration
- Resolving the installation issues for better performance
- Oracle disk architecture and disk load balancing
- Creation of Oracle standby database and failover databases
- Database installation and upgrade services
- Onsite installation and technical DB support
Database Design: :
- Logical design and physical design
- Conceptual data design (ER - Diagrams)
- Schema design and Schema design changes
- Normalization of tables
- Oracle design reviews
Backups and Recovery:
- Backup / disaster recovery plans.
- Proven recovery strategies for better recovery of the databases
- Automated scripts for all backups and recoveries
- Database backup scheduling
- Crash recovery, version recovery, roll forward recovery
- Problem analysis and resolution activities in all aspects of the recovery of the
database
- Configure backup using third party software
Tuning and Monitoring:
- Tuning database parameters
- SQL monitoring through explain plan utility
- Explaining and monitoring different logs and dump files
- Daily database performance statistics
- Periodic performance analysis & tuning
- Oracle SQL tuning
- Proactive monitoring and critical system alerts
- Database performance data
- System trend analysis data
- Collect performance and resource metrics
- Automated performance decisions of collected metrics
- All the memory parameters monitoring
- Tablespace monitoring
- Automated reports will be generated and sent to concerned people through e-mails
User and Schema management:
- User wise security management
- All other schema managements like table, view, partition and index creation etc
|
