Sr. Database Administrator Resume

PROFESSIONAL SUMMARY:

More than 14 years of extensive experiences in IT Industry focusing on Oracle Database management and Administration and Exadata DMA as Sr. Database Administrator, Database Consultant, Lead.
An Oracle Professional, self - motivated with strong problem solving and outstanding communication skills with around 10 years of IT experience as an Oracle DBA(12c/11g/10g/9i) and Exadata DMA.
Experience in Oracle Dataguard, RAC, ASM and flex environment
Worked in Logistics, Telecommunication and Insurance domains.
Extensive working experience in Exadata X2/X3/X4/X5/X6/X7/X8 machines
Experience in Exadata Builds, patching and Upgrade
Installation, upgrade, maintenance, administration of multiterabyte standalone and RAC databases on multiple platforms
Production support and day-to-day activities to support 24/7.
Exadata and RAC troubleshooting
Exadata reimaging, cell and database server rescue and patching issues resolution.
Provide and implement performance tuning recommendations of all components in Exadata database machine.
Extensive knowledge on Exadata smart features, Smart flash cache, Smart Scan, Hybrid Columnar Compression, IORM, Storage Indexes.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

Deep Understanding about Exadata specific features such as Smart Scan, Hybrid Columnar Compression, Flash Cache, Cell Offloading, IORM, Storage Indexes.
Hands on experience in Software and firmware maintenance of both Database and Storage servers in Exadata
Provide Performance tuning recommendations of all the components of Engineered Systems.
Experience in troubleshooting Baremetal, Dom0, DomU reboot, crash issues.
Cloud Control/OEM 12c/13c Configuration, Agent Installation, Machine Discovery for Exadata and Administration.
Expert in Root cause Analysis specific to Exadata related issues, RAC, ASM.
Expertise in Exadata Platinum patching support, Oracle EM discovery and troubleshooting.
Hands on in Bug analysis, ORA-600/7445 errors.
Expert in analyzing reports like, Sundiag, ILOM, SOSreport, Exachk, Hang Analysis, AWR, Exawatcher, TFA logs.
Hands on experience in Bare Metal Restore, cell node rescue methods, Database server USB rescue,
Hands on experience in Re-imaging the Cell nodes and DB nodes.
Deployment of Exdata machine using OEDA and fix any issues with install steps.
Understanding of ASR, CELLCLI and DCLI commands.

Confidential

Responsibilities:

Worked as a core DBA/Exadata DMA for a telecom project as migration specialist on Oracle 12c, 11g, 10g, 9i, RAC and Dataguard.
Experience in Grid Installation with RAC & ASM. Very good understanding of GpnP.
Installation, Upgrade, Maintenance and Administration of multi-terabyte standalone and RAC databases on multiple platforms.
Capacity planning for all Production and pipeline databases based on DB growth.
Schema refresh and migration.
Perform database troubleshooting and database tuning, SQL tuning.
Administering Dataguard Primary and Physical standby databases.
Implementation of Oracle Dataguard, conducting DR Drills
Configuration of active dataguard, physical standby databases.
Duplicated all the non-production databases on Exadata server according the Data warehouse development Project’s requirement. Help to compress lage volume Partition table by Using oracle HCC Hybrid Columnar Compression Techniques.

Confidential

Responsibilities:

Installation and Configuration of Oracle Databases on RHEL / IBM-AIX / Windows Server / Sun Solaris platforms.
Setup dataguard between multiple Data centers.
Cloning of databases using RMAN and expertise in Patching and Upgrade.
Troubleshoot database related errors and abnormalities and fix it.
Rebuilding the indexes, analyzing tables and Schemas for better performance.
Monitoring database, which include growth of objects, performance of the database.
Administering networking using listener.ora and tnsnames.ora.
Deployment, Administration of RAC, ASM databases.
Migrating databases from non-ASm to ASM

Confidential

Responsibilities:

Performing logical backups (using Export/Import, Data pump utilities).
Performing backup RMAN / Datapump and Export & Import backups
Maintaining Recovery catalog database.
Exposure to Migrating non ASM database to ASM environment.
Good Hands on 10g, 11g High Availability Features & Node RAC .
Build DB based on Dev, UAT and Production Request with Capacity Planning.
Have participated in Production Release Activity, Change Management and Crisis Management support for production database support.
Have worked with the database vendor in raising SR and resolving errors on metalink.

Confidential

Responsibilities:

User management including, Roles, Privilleges, Profiles. And Object privileges.
Managing physical and logical objects of the database.
Managing Tablespaces, Datafiles, Controlfile Multiplexing and Redo & Archive logs.
Good Hands on 10g, 11g High Availability Features & Node RAC.
Detecting Lock contentions, managing Undo segments
Expertise in User Managed Backup(Hot & Cold), Rman, and Logical Backup Export/Import.