SUMMARY

• Confidential has over 10 years of experience in IT Industry as an Oracle Core and Application DBA specializing in Golden Gate, RAC, Data Guard, ASM, RMAN, EBS R12, and OBIEE.
• Good level of experience in installation/upgrade/patching, configuration of oracle RAC environments (10g/11g/12c) and administration of the cluster environments.
• Support includes routine DBA tasks such as database upgrades, migrations, refreshes, clones backup and recovery of full and partial databases using RMAN, implementation and support for database availability performance tuning of SQL and PL/SQL code, system and databaseperformance tuning of database environments.
• Extensive experience on Golden Gate Implementation, configure, maintain, trouble shoot, and upgrade of golden gate environments.
• Support Oracle applications e - business suite (EBS) 11i and R12 installations, Upgrade, configuration, cloning, security, patching, upgrades and maintenance using AD and other utilities.
• Integration of Oracle EBS environment with golden gate and OBIEE for Data Ware House environment setup, worked on OBIEE (Business Intelligence tools) related activities for DAC, Informatics and RPD.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g and 12c

Operating Systems: Red Hat Linux, HP-UX, Sun Solaris

Middle ware: Oracle Web Logic Server, Oracle SOA, AIA, PIPs, OBIEE, Web tier

Web Server: OHS, IIS, Apache, Tomcat

Monitoring tools: 11g EM/12cEM/ Fog light

Languages: SQL, PL/SQL, C, Shell Scripting.

Utilities: Golden Gate, RMAN, ASM, Oracle Grid Control, Data Guard, SQL*Loader, EXP, IMP, Data pump, SQL developer, VERITAS Net Backup, APEX

Tools: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ASH, AUTO Trace, AD Tools, Pl / Sql Developer, putty.

ERP: Oracle Apps 11i, R1213, R12.2, SAP

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential

Responsibilities:

• Golden Gate implementation for server migrations from Solaris to Linux
• Implementation of Golden Gate with unidirectional using source as data file to target oracle DB table
• Experienced in Golden Gate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.
• Troubleshoot Golden Gate issues related extracts, replication lag, Tran data, mapping issues etc.
• Configure capture, extract and replicate process for Golden Gate
• Proficiency in implement, build, setup Golden Gate environments.
• DBA Support for 12c/11g/10g RAC Multi Node configurations
• Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP.
• Planned and implementedOracle RAC 10g, 11g, 12c and StandbyDatabases(Data Guard)for High availability and Disaster Recovery(DR).
• Experience in upgrading the RAC databases 10g/11g and Migration of the tables spaces using transportable table spaces, logical backup and recovery usingexport/import, and data pump utilities.
• UsedOpatchutility for applyingCPUandOne-offpatches &RDBMSpatch set Upgrade(PSU).
• Installed and configured oracleGrid controland deployed agent on managed targets.

Senior DBA

Confidential

Responsibilities:

• Implementation of Golden Gate with unidirectional and bi-directional model.
• Experienced in Golden Gate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.
• Custom object Setup for OBIEE in the Golden Gate replication
• Troubleshoot Golden Gate issues related extracts, replication lag, Tran data, mapping issues etc.
• Configure capture, extract and replicate process for Golden Gate
• Monthly Golden Gate environment refreshes /setup activities for the test and pre-production environments
• Proficiency in implement, build, setup Golden Gate environments.
• Integration of EBS/Golden Gate with OBIEE for reporting purposes
• OBIEE support for DAC, Informatics, RPD re-instantiation and Fusion Middle configurations.
• Production DBA Support for 11g/10g RAC Multi Node configurations
• Implementation and configuration of Oracle GOLDEN GATE.
• Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.
• Setup and configure RAC environments 10g/11g/12c
• Upgrade RAC environments 10g/11g/12c
• Planned and implementedOracle RAC 10g, 11g, 12C and StandbyDatabases(Data Guard)for High availability and Disaster Recovery(DR).
• Experience in upgrading the RAC databases 10g/11g/12cand Migration of the databases using transportable database, table spacesexport/import and data pump utilities.
• UsedOpatchutility for applyingCPUandOne-offpatches &RDBMSpatch set Upgrade(PSU).
• Installed and configured oracleGrid controland deployed agent on managed targets.
• Good experience withOracle grid control, Oracle enterprise manager (OEM), ASM,AWR,ADDM, Flashback Technology,SQL tuning advisor, SQL access advisor, andSQL serverundo advisor.
• Migrate non-RAC to RAC EBS database
• Implemented OEM 11g/12c
• Support Oracle applications e-business suite (EBS) 11i, R12 and R12.2 installations, configuration, cloning, security, patching, upgrades and maintenance using AD and other utilities.
• Migrate customizations from previous release.
• Utilize extensive experience in applying patches through adop.
• Work with experience in applying patches on FMW products.
• Perform with good experience in refreshing R12.2 instances - single node and multi-node.
• Interact closely with system administrators, developers, technology stack team and server tech team.
• Implement 11g/12C OEM grid.
• Execute Oracle EBS administration and monthly clones and support on day-to-day critical activities.

DBA Analyst Lead

Confidential

Responsibilities:

• Assisting the team lead in managing, leading the analysts on the database team as well as managing the team workload in order to achieve an effective, useful and versatile database environment.
• Coordinate with DBMS vendor support services regarding database problems and issues.
• Configuration, Setup, Design, Install & Implementation of Oracle 10g Grid/10g RAC, ASM,RMAN / 11g/10g RAC (Real Application Clusters)
• Implemented Golden gate unidirectional replication on RAC using ACFS file system.
• Implemented 11g Grid control (Multi OMS architecture) on 11.2.0.3 database, Standby OMS architecture is under progress.
• Monitored Golden gate using 11g Golden gate Plugin and shell scripts for alerting GG process down alerts.
• Create, configure and Upgrade databases 10g/11g
• Experience with multiple facets of Data Guard including logical, physical, Active DG
• Coordinate requests of server resources with the server Systems Administration teams.
• Install, configure, and test database and database related software patches, packages, and new releases.
• Perform and maintain database backups, recovery, and refreshes.
• Coordinate with Application Development/Production Support teams on creating and maintaining user access, roles, and privileges.
• Manage and maintain database architecture including DR database replication and backups.
• Used Erwin tool for Designing database objects
• Ability to multi-task and balance the different paces of development and support for multiple applications in support mode and projects in flight in providing application DBA services.
• Strong understanding of application and infrastructure technologies.
• Performance Tuning:Experienced in identifying poor performing SQL statements usingEXPLAIN PLAN,STATSPACK,TKPROF,SQL TRACE and OEM Grid Monitoring.
• Worked on transportation of Table spaces, Data archival, Re-organization of tables and restoration.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottlenecks. Provide technical direction to system administrators for tuning.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Analyzed SQL statements, re-organized database objects and created indexes to improve the performance of the queries.

Associate (Developer & DBA)

Confidential

Responsibilities:

• Created Schema, Users, Tables, Constraints, Indexes, Triggers, Privileges, Roles, Cursors, Ref Cursors, User Profiles, anonymous blocks, directories, sequences, and synonyms.
• Granted resources, privileges and roles to users
• Tuned SQL queries using EXPLAIN PLAN, Hints and SQL*Plus Auto trace report for query optimization
• Wrote Audit programs for data consistency check and validation
• Automated SQL*Loader to load the data from the flat files
• Used Materialized Views, Packages and Dynamic SQL
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables
• Tested and modified codes for quality