
	eXiom Technologies Inc.

Creation Phase

Home

Our highly experienced consulting associates are the industry leaders in Oracle consulting. Additionally, we have a vast retail knowledge to implement Oracle DBA projects in a cost-effective and timely manner to meet the business needs.

Our Oracle DBA Services Include:

Analysis Phase

Environmental Assessment

•Current Database Setup

•Current Server Setup

•Storage Setup

•Application Setup

Business Requirement

•High Availability Clustering

•Service Level requirements

•Response Time requirements

•Data Archiving and Recovery

•Data Partitioning

Application Setup Review

•Review the Process Flow Diagram

•Entity Relationship Diagram

•Identify Performance bottlenecks

•ANALYZE/EXPLAIN PLAN for SQL statement

Capacity Planning

•Estimated Table Growths

•Estimated Storage Space

Recommendations

•Overall Oracle Architecture

•Server Configuration

•Network Devices

•Storage Devices

•E-R Diagram Model

•Database Archiving & Purging

•Oracle RAC Cluster environment

Creation of Oracle DB Phase

Oracle Physical Architecture

•Install Oracle Server

•Build Oracle Staging Physical Architecture including Database Schema, Instance, SGA etc.

Table Space Management

•Configure Oracle TableSpace

•DiskSpace Allocation

Table and Index Structure

•Unix scripts for managing Tables and Indexes

•Build special indexes for performance tuning

Database Security

•Define User Roles

•Define User Privledges

Configure & Tune Staging Environment Phase

Database Backup and Recovery

•Unix script for Export/Import

•Unix Script for RMAN backup

•Test Database Recovery

Database Reorganize

•Build database reorganization procedure

•Periodical cleanup/purge of the data

High Availability & Clustering

•Install and configure Oracle RAC

•Configure and test the RAC environment of load balancing and failover

•Tune RAC environment

Analyze Database Performance

•Identify Top 5-timed events

•Identify Server Bottlenecks (Network, I/O, RAM, CPU)

Tune Database Performance

•Necessary INIT.ORA changes

•Implement and Test Partitioning strategy

•Optimize SQL queries

•Optimize Network and Storage I/O

Advanced Database Monitoring

•Monitor by using Statspack reports

•Drill down using dynamic performance tables

•Monitor the log and define Oracle trace files

•Install scripts for Health-Check and database monitoring

Production Deployment Phase

Database Installation and Setup

•Oracle installation

•Database Schema creation

•Index and Partition Creation

Promote Unix scripts to Production

•Installation of Unix Scripts for Export/Import

•Installation of Unix Scripts for RMAN backups

•Installation of Unix Scripts for Data Re-organization

High Availability & Clustering Installation