SUMMARY

• Oracle Certified Professional (OCP) with 11 Years of experience as Oracle Database Administrator providing 24/7 Production support/ Engineering for Oracle databases 12c/11g/10g/9i on various Unix platforms like Solaris, HP - UX, Linux, AIX and Oracle Engineered System - Exadata.
• Implemented Oracle Real Application Clusters (RAC) for a high transaction volume OLTP application with Transaction Application Failover.
• Hands on experience on RAC database /EXADATA maintenances such as patching / disk replacement / supporting hardware failure repair.
• Performed Database migration from 11g to 12c using Goldendate(DB Size ~ 52 TB)
• Performed Database migration from 10g to 12c
• Performed Cross Platform Database migrations from Solaris/HP-Unix to Linux (DB Size ~ 8 TB)
• Providing weekly rotation on-call support for escalated high and critical Incidents
• 11gR2 Grid and database binary Installation
• Set up RAC Standby database and Dataguard broker configuration
• Database upgrade from 9i/10g to 11g
• Upgrading the databases from 11.2.0.2 to 11.2.0.4 using out-of-place upgrade method
• Cloned databases up to 40TB on Exadata
• Applied one-off patches in 12c databases on Exadata
• Applying PSU patches
• Administering RAC, ASM and Dataguard databases
• Performed Oracle E-Business Suite R12 Application cloning
• Administering Oracle EBS R12 database and application environment.
• Coordinating with Oracle Exadata platinum support for patching the exadata servers/databases
• Extensive experience in supporting very large and mission critical Oracle databases in both OLTP and OLAP environment with database size over 50+ TB.
• Responsible for performing Data guard switchover/failover and fixing GAP issues.
• Perform the capacity management for the Databases and Administering Databases of size in TBs.
• Troubleshoot Performance issues in databases using OEM and all available tools like AWR, ADDM, SQLT, SPM and other functions/ packages.
• Perform Table Partitioning activities such as Addition, Merge, Split, Exchange and Drop partition.
• Involved in and successfully performed a number of restore and recovery operations.
• Coordinating with various teams and Oracle support during Sev-1 issues.
• Involved in Problem management and provided Service Improvements.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Result oriented, self-motivated, team player with ability to work independently. Managed a team of 20+ members across locations - offshore, Nearshore and Onsite.
• Excellent analytical and problem-solving skills with good written and verbal communication skills.

TECHNICAL SKILLS

Operating systems: Red hat Linux, Sun Solaris, IBM AIX, HP UX

Databases: Oracle 9i/10g/11g/12c

Database tools &Utilities: Goldengate, RMAN, Datapump, Dataguard, RAC, ASM, SRVCTL, GGSCI, EMCTL, CRSCTL, AWR, ADDM, DBArtisan, TOAD, OEM, DBCA, OUI, SQLT, adadmin, adctrl, fndcpass, Opatch and Exadata.

Languages: Unix shell scripts, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Responsibilities:

• Perform Dataguard switch over for maintenance and special purposes.
• Performed Oracle Database migration from 11g to 12c using Goldengate(DB Size ~ 52 TB)
• Hands on experience on Exadata Cell Maintenance / patching / hardware failure repair
• Applied one-off patches in 12c databases on Exadata
• Performing PSU patching activity in Rolling method on RAC databases.
• Managing the databases on Automatic Storage Management (ASM).
• Providing weekly rotation on-call support for escalated high and critical Incidents
• Performing database cloning and restoration of very large sized databases using RMAN.
• Perform Object and schema refreshes using data pump.
• Experience in deploying secondary and disaster sites with physical standby databases using Data Guard.
• Coordination with Unix team for platform migrations.
• Troubleshoot Performance issues in databases using OEM and all available tools like AWR, ADDM, SQLT, SPM and other functions/ packages.
• Experience in identifying TOP SQLs consuming OS and database resources and perform tuning using Unix/Linux utilities like SAR, IOSTAT, TOP, VMSTAT.
• Perform Table Partitioning - Addition, Merge, Split and Drop partition.
• Administering Databases of size in Terabytes.
• Analyze the database growth and perform necessary capacity planning.
• Analyze the Dataguard GAP issues and fix them.
• Hands on experience on RAC database maintenance.
• Coordination with Oracle Platinum support for Exadata patching.
• Experience in managing security through grants, roles, privileges and profiles.
• Experience in handling a team of 20 + members in offshore / Nearshore / Onsite.

Confidential

Database Administrator

Responsibilities:

• 11gR2 Grid and Database Installation
• Performed Cross platform transportable tablespace migration using incremental backup (DB Size ~ 8 TB)
• Setup RAC Standby database
• Data guard broker configuration
• Applying PSU Patches
• Deploying 12c OEM agent and discovering targets
• Configured OEM Health report for Production databases
• Creating ASM disk group and adding disks
• Performed Node Removal/Addition in a 4 node RAC environment
• Administering the RAC databases

Confidential

Database Administrator

Responsibilities:

• Installing and Upgrading the databases from 11.2.0.2 to 11.2.0.3 using out-of-place upgrade method
• Applying PSU Patch and application patches(adpatch)
• Reconfiguring targets in 11g and 12c OEM grid control
• Data masking in 11g and 12c OEM grid control
• Database Vault installation and Configuration
• Audit Vault Agent installation and Configuration
• Administering the Oracle Applications (ERP) oriented databases.
• Database clone using RMAN as per business requirement.
• Oracle application patch analysis and applying patches
• Oracle E-Business Suite R12 Application cloning
• Troubleshooting concurrent manager issues
• Reconfiguring targets in 12c OEM grid control
• Restored OCR Voting disk from backup and started the cluster service
• Creating ASM disk group and adding disks
• Administering the RAC databases
• Administering databases of size in tera bytes
• Schema refresh using export/import and Data Pump
• Supporting development and testing team for application migrations.
• On-call Support and Queue Monitoring

Confidential

Database Administrator

Responsibilities:

• On-call Support and Queue Monitoring
• Agent Installation and discovering targets in OEM
• Applying monitoring templates in OEM
• Creation of tablespaces, datafiles, users etc., for project requirement
• Backup Configuration
• Database Cloning and DR Rebuild
• Schema refresh using export/import and Data Pump
• Administering databases of size in tera bytes
• Performed capacity planning to avoid tablespace issues
• Knowledge on administering physical standby database and RAC systems
• Manually applying logs on Physical standby database
• Coordinating with different departments like, Applications, UNIX, Storage, Change Management team.
• Involved and successfully performed restore and recovery operations
• Leading the shifts without escalations
• While on-call support, handled many outages successfully and received appreciation from the service management
• Resolved incident tickets in time to meet SLA by working with oracle support and implementing the solutions

Confidential

Database Administrator

Responsibilities:

• Monitoring the production, development and test database using Oracle Enterprise Manager.
• Monitor the instance and plan for future availability of storage on user’s tablespaces.
• Monitoring the Usage of Indexes, Segment Space Management
• Planning Oracle Database Backup for future Recovery using export Backup.
• Creation of tables, views, sequences and constraints for the development team.
• Migrating the Oracle 9i database to 10g using Export / Import
• Backup and Recovery Management through (RMAN/HOT/COLD)
• Configuring RMAN repository for database backup and maintenance of the repository.
• Analyzing the schema and database for performance upgrade and identify the table growth
• Export / Import of Database, Schemas & Tables using exp/imp & Data pump utilities
• Creation of Database links for remote databases
• Proactively monitoring alert log files and perform database health check up
• Handling the connection related issues - resolving problems in client systems due to errors in tnsnames.ora.
• User Management - Allocating Quota, Managing Profiles and Granting / Revoking privileges, locking / unlocking the User Accounts
• Querying different advisors and performing the tuning based on the advisors results in order to maintain the performance of database