Specialist-Application Operations

Managing and administrating the Exadata Database server, Storage Server and InfiniBand Network (X5-2, X6, X7, X8-M).

Change Data Capture (CDC) Administration.

Administration of Sun ZFS Storage.

Oracle RAC administration and troubleshooting.

Good knowledge of cellci, dcli and other Exadata specific utilities.

Administration of Storage, InfiniBand and compute nodes.

Exadata component monitoring and alert handling.

InfiniBand architecture and its application.

Expertise in 12c, 19c Database and Grid Infrastructure upgrade.

Hardware replacement like HDD and Flashcard.

Good Knowledge of Oracle 12c/19c RAC and ASM Configuring and Supporting Data guard.

Oracle database Cloning, Oracle Home cloning and patching.

Knowledge of Oracle Architecture Handling Database Corruption Issues and Troubleshooting Database Performance issues. Configuring and using RMAN, User Managed Backup and Recovery.

Using Export/Import utilities and Data pump.

Technical Scope

Configuring and using Flashback Features for an Oracle database.

Creating/Managing Table Partitions, DB Reorganization, Rebuild, Truncate, Purge and Gather Stats.

Controlled and monitored user access to the database including granting and revoking privileges and roles, allocation of resource limits and table space Management.

Using Oracle Enterprise Manager for monitoring and maintaining Clusters, RAC databases and other Targets. Monitoring Oracle Database Server to ensure proper database Availability, Performance and Capacity and Oracle server load, User sessions and long running operations on the Server. Alert Handling and Monitoring tasks. Managing Database Connectivity, networking and Storage Monitoring and resolving Lock Conflicts in oracle database. Basic day-to-day Admin commands Linux/Unix Monitoring Systems Performance (CPU, Memory, I/O). Basic Shell scripting & automating the routine tasks through shell scripts. Tune database queries Monitor application related jobs and data replication activities.