SUMMARY

• Around 8+ years of IT experience as an Oracle database administrator in Oracle database administration, installation, configuration, migration, sizing and space management, backup and recovery, cloning, upgrades, RAC, standby, replication, patching, performance tuning and troubleshooting, strategic planning, database security, TAR/SR support, Unix shell scripting and documentation, auditing and implementation of technology solutions.
• Involved in different scenarios of OLTP and Dataware housing databases.
• Experienceincreatingdevelopment, test, stage, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Worked in 24x7 on - call production database support team and also as a Primary DBA in database engineering team.
• Expertise in installation and configuration of oracle 8i, 9i, 10g,11g, 12c on various platforms like IBM-AIX, SUN SOLARIS, HP-UX, RedHat Linux and Windows.
• Having a sound knowledge of new features of Oracle11g.
• Have a valuable experience in Identity and Access Management domain.
• Has been working on development and implementation of both Oracle Identity Manager 11g R1 and Oracle Identity Manager 11gR2PS2.
• Experience in implementing DR (Disaster Recovery) & High availability solutions using DataGuard (11g/10g), Standby Database (9i) and oracle 9i, 10g, 11g RAC.
• Proactive monitoring in identifying bottlenecks in the application and database using Statspack, AWR, ADDM and 12c OEM Cloud Control Monitoring.
• Configured GoldenGate to achieve unidirectional and bidirectional replication.
• Upgraded Oracle GoldenGate v10 to v11.
• Implemented and configured GoldenGate on a 2-node RAC cluster.
• Troubleshooting and fixing GoldenGate errors in a 2 node RAC production environment.
• Experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica PowerCenter/Datastage.
• Expertise in database backup/recovery strategy (BCV mirroring, RMAN, Export/Import & Datapump), Performance Tuning, Capacity Planning, Standby database (Logical, Physical), Oracle configuration management, database cloning, refresh, and patch management.
• Have a good knowledge on small flash cache and troubleshooted Exadata small scan off load issue.
• Compressed data in distinct levels using Exadata.
• Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA, and the basic, low, high compression methodologies.
• Worked on Exadata Database Machine X4-2 Half Rack, X3-2.
• Implemented new Exadata Machine features like Exadata smart scan, Flash Logging, Storage Index, HCC and enabling Smart Scan on Exadata Databases.
• Migrated databases into Exadata Machine with minimal downtime using Dataguard.
• Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Application Tuning and Database/Instance Tuning.
• Experience in performance-tuning services like EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g/11g/12c OEM Grid Monitoring, custom scripts troubleshooting Oracle databases using sqltrace.
• Involved in oracle technical support process through Metalink and other procedures.
• Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in basic and advancedreplication using Oracle Streams.
• Experience in using OEM, TOAD, Data migrations using export/import, Data pump, RMAN.
• Experience in configuring and troubleshooting shareplex replication.
• Maintaining Database Security using security compliance auditing, capacity planning.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Good Written and verbal Communication skills with a customer service oriented attitude.
• Good experience in facing Clients during hard situations.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3, 6.1, 7.1 Red Hat Linux RHEL 2.x, 3.x, 4.x, 5.x, 6.x and Windows NT/2000//XP.

RDBMS: Oracle 12c/11g/10g/9i/8i

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, C,C++

Tools: TOAD, SQL Tools, FastReader, Informatica PowerCenter

Oracle Tools: RAC,RMAN, ASM, OEM(11g, 12c), SQL*Loader, exp/imp, expdp/impdp, GoldenGate

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,AWR, ADDM

Database Modeling: Erwin 4.0, Toad Data Modeler.

Other: VERITAS Netback up

PROFESSIONAL EXPERIENCE

Confidential, Bakersfield, CA

Sr. Oracle Apps DBA

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008,OEM, Oracle RAC, Data-Guard, TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Responsibilities:

• Worked as a primary DBA for several databases and provided application support when and as required.
• Installed and configured Oracle12c,11g, 10g 64 Biton Linux for Production, Development and Testing.
• Installed, configured and tested oracle 10g and 11g RAC environment and trouble shooting.
• Implemented Migration of Databases from 10g to 11g and applying patches whenever required.
• Worked on Migration of Databases from IBM/AIX RISC System/6000: Version 11.2.0.4.0 to Linux: Version 11.2.0.4.0. Worked on migration of all the environments starting from DEV to PROD.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Daily administration ofOracleApplications R12 and R11.
• Monitored and SupportedAppsin new 11g RAC, 11g ASM.
• MigratedOracleapplication 11.5.10.2 from HP UX 11.13 toOracleenterprise Linux and upgraded the database to 11.2.0.4 from release 10.2.0.4
• Upgraded ofOracleEBS Applications to R12.1.3, R12.2.5 and R12.2.6 andOracleDatabase to 11.2.0.4.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
• Having Experience with Oracle 11g new features including ADR and Database Replay.
• Wrote UNIX Shell Scripts (Korn Shell, C-shell), SQL, PL/SQL, stored procedures, functions and database triggers to automateDBA activitieslikebackupsandperformancemonitoring.
• Worked with Automatic Storage Management (ASM)Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• High-speed data transfer between one database to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
• Load balancing, Databases/Schema/TableRe-organization for faster performance using export/import & Move procedures.
• Health Check Up of the Database using STATSPACK, AWR, ADDM. Performance tuning of Database Objects by fixing row chaining, I/O and CPU bottle necks.
• Monitoring database performance during peak and non-peak loads using OEM Grid Control.
• Configured GoldenGate to achieve unidirectional and bidirectional replication.
• Configured GoldenGate on production servers.
• Upgraded Oracle GoldenGate v10 to v11.
• Setup classic capture replication mechanism using GoldenGate.
• Successfully tested initial Data load during environment build.
• Setup GoldenGate User with necessary privileges.
• Implemented and configured GoldenGate on a 2-node RAC cluster.
• Troubleshooting and fixing GoldenGate errors in a 2 node RAC production environment.
• Test impact of multiple Extract and Replicat processes on a Single Node.
• Prepare GoldenGate parameter files for Extraction and Replication.
• Investigate, trace fix and report replication failures using LogDump.
• Identify risks involved with replicating highly volatile tables with large data volume.
• Supported Bi-Directional replication, broadcasting data from Enterprise Data warehouse to downstream database at client location.
• Upgraded Oracle Identity Manager (OIM) from 11g R2 PS2 to 11g R2 PS3.
• Expertise in troubleshooting problems encountered in the implementation, upgradation and integration of Oracle Identity Management suite components.
• Oracle Identity Manager (OIM) product development, systems integration and infrastructure management including lifecycle patching, upgrades and support.
• Implemented and customized Oracle Identity Manager (OIM and OAM) 11gR2 according to the requirements.
• Involved in moving databases in Exadata on various versions on half node RAC environments.
• Experienced in compressing data in various levels using Exadata.
• Closely worked with Designingteam in configuring Oracle 12c on Exadata boxes.
• Documented Cron jobs, replication setup, post migration and post upgrade procedures
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous performance monitoring through TOAD, OEM tuning pack, diagnostics pack, Statspackand Unix Shell Scripts like system resources, hit ratios, I/O, locks and Latch contention.
• Managed clients during critical situations.
• Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
• Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
• Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.
• Worked on 12c cloud control and resolved the events/incidents as reported.
• Hands on experience in finding the root cause of the problems that occurred and providing a solution to avoid them in future.
• Worked on Compliance reviews and quarterly auditing support.

Confidential, Dallas, TX

Sr. Oracle DBA

Environment: Oracle 10g/11g, RAC, Solaris 10, UNIX Shell scripting, REDHAT Linux 5, Windows Server, Oracle Grid Control 11g, 12c, RMAN, DataGuard, Oracle Streams, Toad.

Responsibilities:

• Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, Development and QA databases.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netbackup.
• Used Flashback Technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects.
• Performing Database Refreshes using Exp/Imp, Datapump and RMAN.
• Configured and setup CRON jobs and AUTOSYS jobs.
• Involved in Capacity planning and benchmarking for Databases.
• Setup reporting server using ORACLE Streams from various data sources.
• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
• Enhancing performance using various components like ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
• Installed GoldenGate software in Test and Dev environments.
• Migrated databases using GG and RMAN for 2 node RAC
• Implemented broadcasting and bi-directional replication
• Resolved replication issues in GoldenGate.
• Automating tasks using Cron for GoldenGate restart.
• Replicated to a disaster recovery site for increased server manageability and availability.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
• Performed Table, Index Partitions for increased performance and for better storage management.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of numerous sizes - 10TB.
• Documented the Role Transition method from Primary to Standby and vice versa of DataGuard environment.
• Wrote Shell and Perl scripts for monitoring and automating tasks of various Databases.

Confidential, West Des Moines, IA

Sr. Oracle DBA

Environment: Oracle 10g/11g, RAC, UNIX Shell scripting, REDHAT Linux 5, HP-UX 11.2, Oracle Grid Control 11g, 12c, RMAN, Shareplex, DataGuard, Oracle Streams, Toad.

Responsibilities:

• Providing full life cycle on DBA/on call support for Production Databases, Administering, UAT, and Development and QA databases.
• Translating technical and Business requirements into efficient Logical and Physical data models.
• Configured and Installed ORACLE 10g, 11gsoftware on Red Hat Linux 5 Servers.
• Created and monitored Physical standby databases on maximum protection, performance mode using DataGuard for Disaster Recovery and performing production databases Maintenance.
• Configured Automatic Storage Management (ASM) for 11g RAC databases.
• Implemented Data Guard for Disaster recovery system using Oracle 10g.
• Supported installation and setup of ORACLE Cluster’s and RAC database.
• Monitoring and Administrating ORACLE RACdatabases on ORACLE 11g Clusters.
• Used Erwin data modeling tool for creating the logical and physical data models for forward and reverse engineering.
• Involved in Capacity planning and benchmarking for Databases.
• Setup reporting server using ORACLE Streams from various data sources.
• Implement the Streams Replication for store data. Configuration of streams from nine databases to one target database. And provide the failover through Datagaurd for the target Database. Configured Grid control to monitor the Streams.
• Capture, Propagation, apply using Golden Gate and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Performed database Migration from Windows platform to Linux using RMAN (Convert) and Datapump.
• Analyzing the Automatic Database Diagnostic Monitor Reports from various Databases in various time intervals, creating BASELINE and monitoring performance metrics of Databases WORKLOAD.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Upgraded few production databases from version ORACLE 10g to ORACLE 11g.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Identifying instance Top Waits root cause and bad queries, writing suggested solution reports about Instance tuning and Query tuning.
• Performed Table, Index Partitions for increased performance and for better storage management.
• Monitoring and performance enhancement using session Tracing, Statspack and CPU utilization.
• Identifying bottlenecks and wait based analysis using Oracle Wait Interface.
• Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes - 10TB.
• Documented the Role Transition method from Primary to Standby and vice versa of DataGuard environment.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
• Performed software cloning, tuning, patch management and deployment using Configuration and Provisioning, Diagnostic and Tuning Packs.
• Performing Backups (BLI, Full, Cumulative, Differential), Recoveries using RMAN-Netbackup.
• UsedFlashback Technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects.
• Performing Database Refreshes using Exp/Imp, Datapump and RMAN.
• Configured and setup CRON jobs and AUTOSYS jobs.

Confidential, Carrollton, TX

Oracle DBA

Environment: Oracle 8i/9i/10g, Oracle 10g/9iOAS, Solaris 9, UNIX Shell scripting, Red Hat Enterprise Linux 5, HP-UX 11.2, RAC, IBM SAN Volume Controller, Windows 2003, Grid Control 2 and TOAD

Responsibilities:

• 24x7 Oracle Database Administration of Production, Development, Testing databases.
• Setup and configured Standby Databases for disaster recovery and reports generation in maximum performance mode using DataGuard.
• Setup and Configured Physical Standby and Logical Standby Databases for various production systems.
• Involved in Data Modeling, Design, Implementation and Creation of Databases.
• Worked closely with System Administrators, Network Administrators to build the RAC environment.
• Involved in setting up of ORACLE 10g RAC Databases for test prototype environment with three nodes-clusters on Red hat Enterprise Linux 4.
• Setup Automatic Storage Management to reduce I/O contention and support RAC databases.
• Documented the procedures for adding a node for current DATAGUARD environment.
• Involved in Capacity and Resource planning. Estimated the size of Data files and Redo log files based current transactions rate, time for recoveries etc.
• Designed various Backups/Recovery strategies for Oracle databases as per SLA requirements.
• Configured users into consumer groups and set the resource utilization based upon business activity using RESOURCE MANAGER.
• Expert in maintaining very Large Databases involved in Data warehouse and ERP Applications of various sizes - 10TB.
• Configured and performed automated and various levels of backups using RMAN.
• Performed Fine Grained Auditing and maintained security on different objects in various level of the database.
• Installed ORACLE Enterprise Manager GRIDCONTROL and configured it with server targets for a centralized monitoring system.
• Monitored databases Performance using ORACLE Enterprise Manager (OEM) and Grid Control.
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.
• Worked on AWR repository, Statspack report and Session Trace 10046 to find/fix root causes for performance degradation in the databases.
• Responsible for Instance Tuning, I/O Tuning, Identifying and fixed contention waits.
• Used ORACLE Wait Interface, to identify the top most wait events and their causes.
• Used advisor, tasks like ADDM, Access Tune and Undo Advisors for performance tuning.
• Installed and updates critical security Patches using Enterprise Manager and OPATCH.
• Worked extensively with tools like Datapump, Exp/Imp,for loading data into database and monitoring and querying databases using TOAD etc.
• PartitionedTables, Index for increased query performance and easier maintenance.
• Analyzed query plan using Plan Table, Explain Plan, optimizer Hints and for estimating CPU & Query costs.
• Refreshed PROD, DEV, UAT databases using Datapump, RMAN, and TransportableTablespaces etc.
• Resolved Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.
• Developed Shell Scripts to carry out routine checks on databases and perform various tasks on the database.

Confidential

Oracle DBA

Environment: Oracle11g/10g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting,Quest Performance Analysis, Quest Space Management tool, DB Artisan, Toad, PL/SQL, OEM, Windows NT/XP.

Responsibilities:

• Database Administrator for Production, Development and UAT databases and provided on-call support for production databases.
• Configured DataGuard disaster recovery procedure using Physical Standby Databases.
• Monitored Standby Databases and performed switchover and failover mechanisms of DataGuard.
• Installed ORACLE 9i/10g software’s on Windows and Unix Platforms.
• Supported CRS/RAC Database installation for HA, Scalability of databases.
• Setup and Upgraded ORACLE 9i databases to ORACLE 10g databases.
• Setup backup procedures for various PRODUCTION databases based upon SLA.
• Took Full/Incremental backups using ORACLE Recovery Manager (RMAN).
• Created Entity Relationship model (Entities, Attributes, elements and relationship) normalizing data up to Third Normal Form (3NF).
• Administrated database regarding space related issues- monitoring Tablespaces, users’ security of data accessibility and Configuring Archive log destinations and Flash Recovery Area (FRA).
• Applied various patches on regular basis to oracle software homes.
• Monitored databases using Enterprise Manager and resolved issues based upon severity level.
• Created Clone and Duplicate databases for load testing, Acceptance testing etc. using RMAN.
• Created Materialized Views/Materialized Views Logs for data replications.
• Analyzed databases using AWR, Statspack Report and resolved issues to maintain performance.
• Created user assigned Profiles-Resource limits, maintained Security with Roles/Privileges granting and revoking upon requirements.
• Monitored and tuned rollback segment, temporary Tablespaces, redo log buffer, sort area size.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Assuring Load balancing, monitoring disk I/O statistics, Data file I/O statistics read/write ratios and fixing problems.
• Create Triggers and defined constraints to maintain the data integrity in the databases.
• Migrated Data from one server to another server using Data pump operations.
• Managed and resolved design issues during development stage. Worked closely with developers.