Senior Oracle Exadata/ExaCC DBA

➢
Administer RAC Databases with 100+ Terabytes sizes on Exadata & Oracle ExaCloud@Customer Platforms
➢
Database Migrations from legacy platform to Exadata & Oracle Cloud

Performing Physical Database Migrations using RMAN and Dataguard methods
➢
Performing Logical Migrations using datapump & transportable tablespaces
➢
Performing Cluster Build in Exa Cloud @Customer.
➢
Automating Tasks such as database refresh, backup using shell scripting and complex tasks using Python for Infrastructure automation.
➢
Managing and maintaining Python / Shell script Code in GIT repositories.
➢
Core Database upgrade and patching.
➢
Refresh of multi terabyte production data into UAT by restoring and recovering databases for user tests and requirements.
➢
Performed Oracle Exadata Full Stack Upgrades.
➢
Certifying the latest Patches releases for Oracle database.
➢
Worked with Oracle Support for critical issues by creating Oracle SR and provided necessary log info.
➢
Created the Database & the primary database storage structures (table spaces), SGA and database objects.
➢
Implemented, configured and maintained Data guards (physical, active, snapshot) for DR failovers.
➢
Worked with Project team on Critical Backup Audit findings and fixing the backup restore timings.

Applying Exadata Full Stack Upgrade Patches, which involves upgrading Exadata Storage Server version, Linux Version, Switch Version, Oracle Grid and Database homes version.
➢
Oracle Exadata Installation, OEDA Generation, Oracle Platinum Configuration
➢
Advanced Oracle DBA activities like RAC Installation, Troubleshooting existing setup and Performance tuning (DB and SQL).
➢
Architected OS backups strategy and setup consolidated reporting of status all servers across the environment.
➢
Architected and scripted RMAN incremental level backup and recovery for Exadata databases through ZDLRA appliance enabling the High Availability setup between multiple ZDLRAs between data center.
➢
Configuration of Exachk dashboard to automate and consolidate the Exachk runs of all Exadata machines in environment.
➢
Installation, upgrade, administration, backup, recovery, performance tuning, patching, network administration of oracle (RAC and Grid Control) OEM 12c, 11gR2 primary and standby databases using dataguard, enterprise manager and shell scripts
➢
Configure ZFS shares replication across Data Centers

Core DBA work spanning multiple releases like 10g, 11g R2 and 12c.
➢
Handling EXADATA Patching, DB & Cluster Upgrades, Capacity Planning, On-Site & Off-shore DBA and Infrastructure teams on 24x7
➢
Configure and maintenance of Standby databases.
➢
Tuning of the database, monitor databases performance, space utilization and table space fragmentation.
➢
Set-up Backup and Recovery procedures using RMAN.
➢
Set-up storage parameters of Database objects like Tables, Indexes etc.,
➢
Created Roles and User Profiles. Granting resources, privileges to users, roles.
➢
Planned for future storage requirements for production Database