SUMMARY:

• An Oracle Database Administrator with 6 years of experience with large - scale production environments across multiple platforms. Capacity to give high level technical support in all sections of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery. I provide support in configuring and supporting Oracle Real Application Clusters (RAC), Golden Gate and Data Guard. I can work both as an individual contributor and as a team player.
• Excellent experience in installation, setup and configuration of Oracle 10g, 11g and 12c in Sun Solaris, IBM AIX, Windows and UNIX/Linux environment
• Experience in configuring high-availability systems using physical standby
• Golden Gate setup to achieve unidirectional/bidirectional replication in Heterogenous and Homogenous platform
• 11g/10g Automated Storage Management (ASM) installation, configuration and maintenance
• Having hands on experience in Hot/Cold Backup, Recovery, RMAN backup and recovery, Data Guard Broker, Disaster Recovery environment
• Experience in Real Application Cluster (RAC) setup, configuration and cluster interconnection with automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability
• Installation, maintenance and tuning of Oracle 12c, 11g, 10g RAC databases including ASM and CRS
• Implementation of Oracle Backup and Recovery strategies in Data guard and RAC environment
• Good experience in applying Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) using O-Patch and run installer, also involved in Upgrading and Migrating of an Oracle server to higher version available
• Performance monitoring and tuning using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
• Experience in Performance tuning i.e. tuning applications, shared pool, I/O distribution, Rollback segments, buffer cache, redo mechanisms
• Effective troubleshooting of database and performance problems
• Proficient in managing Oracle instance, database storage structure, schema objects
• Involvement in multiple CLONING databases using manual method and RMAN utility. Refreshing pre-prod/dev databases
• Thorough understanding and excellent experience in tuning, assigning proper indexes such as BITMAP or B-Tree Index according to requirement.
• Data pump implementation, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database
• Working experience on Enterprise Manager Cloud Control 12c to monitor database performance and availability of various targets in database servers
• Managing Users and resources, controlling user privileges, roles and auditing
• Extensive knowledge in Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, and operating system
• Knowledge in oracle Data warehouse DBA skills relating to administration management of VLDB environments, Oracle OLTP
• Closely work with application teams on various performance support and configuration issues on day to day basis

PROFESSIONAL EXPERIENCE:

Confidential - Mooresville, NC

Oracle Database Administrator

• Supporting multiple databases for production, development, test and QA purposes on Linux and Windows environments
• Planning, Implementing and Validating various versions of Oracle Databases to 12c Release & upgrades on all the environments
• Applying PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
• Installing Oracle 11g on Linux platform using ASM
• Configuring and worked in Oracle golden Gate installation, configuration troubleshooting golden Gate issues
• Implementing Data Guard with high availability and performance configurations for disaster recovery and participating in Data Guard Fail over tests
• Involving in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform
• Creating a clone Database using RMAN on remote Server and used SRVCTL commands for real application Cluster (RAC) Databases
• Experience in migrating database from Non-ASM to ASM and Non-RAC to RAC
• Moving data across platforms using Transportable Tablespaces and Data pump import/export utilities
• Monitoring the CPU, memory usage, I/O contention on servers using TOP, IOSTAT, SAR, VMSTAT
• Assisting in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints whenever possible, amongst others
• Troubleshooting of various database performances by Analyzing the AWR, ADDM and TKPROF, for diagnosing the root cause of the issues
• Refreshing Dev and Test instances with data from production on a regular basis using data pump
• Successfully implementing Backup & Recovery using RMAN which includes hot backups and Cold backups
• Handling all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, data modeling, and developer support to enforce the referential integrity constraints and business rules
• Performing security and auditing at higher levels
• Performing zero downtime migration from non-Exadata machine to Exadata machine using Oracle Goldengate and Dataguard
• Writing UNIX/SHELL scripts to provide the reports
• Performing RMAN point in time recovery and instance recovery done on 11g
• Knowledge in Oracle Data warehouse DBA skills relating to administration management of VLDB environments, Oracle OLTP
• One-year experience in Postgres databases

Confidential, Rochester, NY

Oracle Database Administrator

• Implemented Advance Security using Transparent Data Encryption at tablespace and column levels
• Implemented Flashback technology of the Oracle 11g for a faster recovery of the databases and database objects
• Set up Oracle ASM storage for Oracle RAC standalone database
• Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g and 10g/11g environments
• Installed and configured Golden Gate replications, monitoring scripts for Golden Gate in Unix scripting
• Performed Database upgrade from Oracle 11g (11.2.0.4) to Oracle 12c
• Achieved optimized performance for the databases by rebuilding indexes on table
• Extensively used AWR, ADDM and explain plan for periodic performance tuning
• Performed full and incremental backup using RMAN and implemented recovery strategies
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts
• 24 X 7 Production & Development database support and administration

TECHNICAL SKILLS

Databases: Oracle 12c, Oracle 11g, Oracle 10g

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, EXPLAIN PLAN, AWR, ADDM, ASH, SQL, Developer, Grid Control

Operating Systems: IBM AIX, HP UX 11i, Solaris 10/9/8, Windows 2010/2012 Server