Oracle DB Support

We eGolem provides committed database services to client databases in all part of the Globe. Our DBA experts understand client database model/architecture and offers services to suit their business needs.

We eGolem offers end to end complete Database services, Build Services => Administration => Maintenance => Monitoring => Performance optimization => High Availability => Backup & Recovery => Upgrade & Migration => Security.

Build Services: Our DBA's are expert in installation & configuration of different Oracle version(8i,9i,10g,11g,12,18c) on various platforms(Linux, OEL, Solaris, AIX, Windows etc).

• Database creation
• Database installation
• Database virtualization
• Tools configuration

Database Monitoring: Proactive monitoring of different database metrics is important to avoid any potential issues.

We are experts in offering Oracle database monitoring using

• OEM 12c/13c
• OS Cron jobs
• Customized DB scripts
• Nagios

Disaster Recovery and Data Backup Services Disaster recovery management is the key responsibility of a DBA; this is our core competency too! Database recovery time solely based on type of backup strategy and we are specialized in understanding business requirement and develop backup strategy accordingly.

• Automate backup using RMAN script.
• Automate backup using EXPDP script.
• Automate backup using Storage Volume snapshot.
• Automate backup using OEM job.
• Offload DB backup on Cloud.
• Asynchronous/Synchronous Standby DB setup.
• Site replication using Golden Gate.

High Availability For business continuity we offer different oracle high availability features

• Oracle Real Application Clusters.
• Oracle Data Guard.
• Oracle Flashback.
• Oracle Golden Gate.
• RMAN

Performance Tuning: Oracle database tuning is critical for business continuity at same pace, we cover all aspects of database tuning. Our tuning expertise area:

• Database memory tuning
• Operating system tuning
• Storage I/O tuning
• SQL tuning

Database Upgrade: DB upgrade is essential to exploit the enhanced features of next version as well as avoid DB outages due to known/unknown bugs in current version. We used different upgrade techniques depending on business model and tolerable downtime window.

Upgrade process Flow

Requirement analysis & Upgrade strategy => Analyse new version features => Upgrade on test environment => Actual successful upgrade => Sanity check & monitoring => Support post upgrade issue if any

Database Migration: Our experts provide Database migration from one flavour to another depending on business requirement like SQL server to Oracle, Oracle to NoSQL and vice versa. We do also offer Database migration from On-Prem to Cloud like migrating Oracle Database from OnPrem to Oracle cloud/Microsoft Azure/AWS.

Database Maintenance: Regular maintenance of database is important to keep the database in shape; we access the client environment and automate various maintenance jobs.

• Database Patching
• Index coalescing/rebuilding
• Strategically removing Table fragmentation
• Up-to-Date Database object statistics
• Maintenance on LOB objects.

Database Security: Depending on various business models and their requirement we are expert in suggesting & implementing different security layers to protect Oracle database from various threats.

• User accounts creation.
• Authentication methods.
• Privileges & Roles.
• Application security.
• Row level & Column level access control using VPD.
• Encryption using Oracle wallet.
• Auditing DB activities.
• Oracle Database vault.
• Oracle Audit vault.
• Oracle Label security.