v
www.kastechssg.com [email protected]
v
High Availability Configuration (e.g., RAC, Data Guard)
Platform Migration (e.g., Windows to Unix, Unix to Windows)
Core Oracle Database Services:
www.kastechssg.com [email protected]
HealthCheck, Maintenance & Patching
Virtual/Cloud Services Configuration
System Design & Architecture
Remote Monitoring and Troubleshooting
Performance Tuning (e.g., Database)
Backup & Recovery Planning and Configuration
Software installation & Database Creation
v Application-Specific Oracle Database Services
www.kastechssg.com [email protected]
01 02 03 04
Fusion Middleware Configuration
Application System Administration
E-Business Suite installation and
Upgrades (e.g., Database, EBS Technology
stacks)
Performance Tuning
(e.g., E-Business Suite)
v
• RAC • Patching (CPU, PSU… etc)
• Active Data Guard & DR • Backup (Cold, Hot)
• Data Guard Broker Setup • Cloning/Refresh
• Golden Gate • Performance tuning
• HealthCheck • Data Migration (Data Pump)
• Alerts • Code Migrations
• Space Management • OEM
Managed Services
www.kastechssg.com [email protected]
• 24x7 support for production, non-production systems
• Fixed/Variable bucketed hours support
• Onsite/Remote/Offshore/Hybrid support models
• Support includes:
v Data Tuning/Refreshes/Space Management
www.kastechssg.com [email protected]
Performs a tuning assessment of the Customer’s production database and will provide tuning recommendations
Single to Single
Various types of refreshes upon customers’ request with Cold Backup
and Hot Backup using tools like RMAN, Data Pump… etc
Utilization of storage resources within the database and at the file system
level for all managed products.
Data Tuning Refreshes Space Management
v Code Migration
www.kastechssg.com [email protected]
• Migration of SQL/PL-SQL code into the Customers’ environment.
• Works with the Customer to develop a code migration and deploys code as defined.
• Works with the Customer to develop a code migration and deploys code as defined.
v Database Schema Management
www.kastechssg.com [email protected]
Works with Customer to define and integrate database schema elements on “as needed” basis including:
• Creation and maintenance of new schema objects (tables, indexes, sequences, etc.)
• Creation and maintenance of database links, user privileges, roles, synonyms, grants, etc.
• Object storage clause definition for space management Database object reorganization
v Managed Projects
www.kastechssg.com [email protected]
Database version upgrade Backup interface, with third party
The design and implementation of fail over setup
The design and implementation of disaster recovery setup
The automation of monitoring processes
Database migration
01
02
03 04
05
06
Managed Projects
v Data Resiliency
www.kastechssg.com [email protected]
Data Resiliency
Cluster setup and configuration Our Oracle DBAs are deeply involved at all phases of Oracle clustering.
Mirroring and log shipping We will configure multiple database for mirroring and/or log shipping as required by your database architecture needs.
Defined maintenance operations DBA Services customers receive a standard, defined set of maintenance operations on their environments. The current list of supported tasks can be found at DBA Services Product Terms.
Failover management and recovery Where high-availability and disaster response solutions are deployed, we help manage switchover during failure and test events.
Customized maintenance plans We will develop individualized maintenance plans for one-time and/or complex maintenance events for your database related systems (for example, data migrations, OS upgrades, and database upgrades.)
Point-in-time recovery We can restore your systems to a specified point in time constrained by the limits of your architecture.
v Troubleshooting
www.kastechssg.com [email protected]
Our team is available 24x7 to help respond to downtime events and performance degradations.
We help you identify optimizations, upgrades, or changes that can help your database achieve better and more consistent performance. (Additional license fees may apply.)
We work with storage and backup engineers to resolve issues with the restore or backup systems.
Upon request, we will investigate database related incidents and provide guidance on how to mitigate or avoid such incidents in the future..
Database backup issues
In-depth incident retrospectives
Availability issues in production
Performance tuning and diagnostics
v Implementations
www.kastechssg.com [email protected]
Implementation and administration of
Oracle 10G, 11G and 12C multi node RAC.
Provisioning GRID/CRS infrastructure.
Convert standalone database to RAC database.
End-to-End implementations
starting with Discover requirements, Storage Layout design, Implementation and
deliver the system to business.
Install Golden Gate and configure the Replication.
Oracle Wallet Installations. MVDC enablement for Oracle databases with Active Passive
architecture.
Implementation and administration of Data Guard
on RAC.
v Upgrades
www.kastechssg.com [email protected]
Upgraded database from 10g to 11g, 10g (10.2.0.5) to 12c and 11g
to 12c.
Oracle EBS upgrade from 11i to R12.1.3, 11i to R12.2, R12.1 to
R12.2
Upgrade of Java / JRE of middle tiers. Database and EBS point upgrades.
v Migrations
www.kastechssg.com [email protected]
Migration of databases and EBS applications from windows to UNIX and cloud.
Data migration using data pump method.
Migration of databases between Physical to VM, VM to Physical and VM, Physical to Cloud.
Migrations