SUMMARY

• Over 8+ Years’ experience as Confidential Database Administrator, OracleE - Business Suite (EBS), applicationDBAsupporting 24x7 production instances. Confidential 12c, 11g R2, 10g, Confidential 9i databases running on different environments such as Sun Solaris, HP-UX, AIX, Red Hat Linux, and Windows.
• Architecture, Installing, monitoring and maintaining (Single Node and Multi Node) Confidential Applications (E-Business Suite Version 11i & R12, R12.2).
• Expertise in Confidential Database Administration, Database Architecture.
• Strong experience with Confidential 12c/11g/10g/9i/8i Installation, Configuration, Monitoring, Upgrades, Migrations, Patching, Performance Tuning, Database Backup & Recovery, Cloning, Space Management, Troubleshooting, Physical and Logical database design.
• Hands on experience with AD Utilities: Adadmin, Adpatch, Adconfig, Adctrl, Adsplice & Adrelink.
• Hands on experience in maintaining high availability of databases for 24/7 global operation using Confidential RAC with ASM and Data Guard/Standby databases.
• Worked on various Confidential replication solutions like Confidential Data Guard, Golden Gate, Confidential Streams and Cloning of Database. Proficiency using Confidential Golden Gate replication, tuning and capacity planning.
• Expertise in Backup and Recovery operations ((Physical, Logical) using conventional hot & cold backups and RMAN.
• Strong knowledge and experience of managing Confidential 9i,10g 11g and 12c RAC environments using the OEM Grid Control.As part of the Upgrade team involved in Upgrading from 12.1.3 to 12.2.4.
• Having the hands-on experience with 11g OEM and knowledge on 12c OEM, TOAD, Visual Studio, Winscp, Clearcase, Kintana, Confidential Forms & Reports 10g, BI Publisher, Confidential Work Flow Builder and OEM
• Monitoring Alert Log for errors. Running tkprof, Stats-pack & AWR reports.
• Upgrade ADTXK5 to ADTX7.
• Experience in supporting Confidential Application modules like Confidential Financials -Financials Accounting Hub(Subledger Accounting),AP, AR, GL, FA, FCG, CM, HRMS, LM, SCM, I procurement, I expense
• Migrated the databases from non ASM to ASM.
• Good knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN, Confidential Tivoli Storage Manager (TSM), VERITAS Net Backup.
• Expertise in Database Performance Tuning & Optimization on Confidential 9i, 10g,11g & 12c.
• Experience in System Management Tools: Confidential Enterprise Manager (OEM), RMAN, ASM, AWR, ADDM, Flash-Back Recovery, Data Pump, Recycle Bin, Quest Software (TOAD), SQL loader, Data Migrations using Export/Import, BMC Remedy Tool.
• Experience in implementing 10g/11g/12c Grid monitoring application to monitor the Confidential Applications and Database.
• Set up and manage database security by creating new users, roles, profiles, and provide required userprivileges in development, test, and production environments.
• Responsible for monitoring and acting upon the alerts from Confidential Grid Control 10g.
• Responsible in switching over/switching back to Physical standby database and vice-versa and starting GoldenGate processes accordingly.

TECHNICAL SKILLS

Languages: C, Core Java, C, C++, Java 2, J2EEDatabase Tools Confidential 9iAS/ Confidential Internet Directory, Confidential Enterprise Manager,RMAN, TOAD, SQL*Loader, SQL*Plus, Designer2000, Erwin, Quest tools like TOAD & SQL Navigator, Confidential Enterprise Manager, Developer 2000/6i (forms 4.5/6.0 Reports 2.5/3.0), Crystal reports, Visual Studio.NET 2003, Microsoft Office 2003, IIS 6, Plesk 7, Norton Ghost, Desktop Authority, Veritas Backup Exec,Veritas Cluster 3.x, Veritas Net backup for Confidential

Relational Databases: Confidential 12c/11g /10g /9i /8i

Operating System: HP-UX 10.x/11.x, AIX 4.3x/5.1/5.2,6.1,7.1, WINDOWS NT/2000/2003 Server, Red HAT Linux 9/8/7.2/7.1/6.2 , RHEL 2.1/3.x/4.x,5.2,6.1,7.0, Sun Solaris 8/9/10

Database Tools: Confidential Enterprise Manager, TOAD 8.5, SQL Developer, rso, F-Secure Confidential, Hummingbird, SQL*PLUS, SQL- Navigator, ERWIN, Golden Gate, Database Replay, Log Miner and Flashback Data Archive, RMAN,LDAP, Telnet, Secure CRT, FTP

Applications: Confidential Application 11i / R12

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Production Confidential Apps DBA support for ERP suite of various clients of different environments. 24/7 support includes patches, cloning and utilities.
• Installing of Confidential Applications using rapid wiz.
• Securing Confidential Application by periodically changing apps and schemes passwords using FNDCPASS.
• Worked with various Confidential Applications Utilities such AD Administration, AD Controller, Auto config AD patch, AD ctrl etc.
• Experience on latest Confidential E-Business Suite version R12.2.4 and in advanced topics like Exadata, RAC, Data guard, PCP, DMZ setup, shell scripting and Fusion Middleware products.
• Support activities of Fusion Middleware products SSO/OAM Confidential Access Manager, Confidential Identity Management (OIM), Confidential Internet Directory (OID), WebLogic, Web Gate, and Access Gate.
• Space Fragmentation monitoring and reorganizing table and rebuilding indexes, tablespace usage monitoring.
• Installed the discover 10g and integrated with EBS 12.1.3.
• Upgrade the ERP from 12.1.3 to 12.2.4. Installed and Configured Confidential Database 11g stand-alone and RAC Databases.
• Configured Confidential Database backups for Test/Dev Environment using RMAN combined with Veritas Net Backup.
• Installation, configuration, and maintenance of Confidential Replication Tool Confidential Golden Gate.
• Performance Troubleshooting using different Confidential tools AWR, ASH, ADDM and SQL Tuning, Advisor, SPM, SQLT and Real Time Sql Monitoring Using OEM.
• Troubleshooting operational issues and documenting detailed resolution steps.
• Optimizer statistics collection using DBMS STATS package and Optimizer tuning using relevant init.ora parameters, Hints, SQL Profiles, and SQL PLAN MANAGEMENT (SPM).
• Tuning SQL statements using Explain Plan, Execution Plan, SQL Baselines and SQLT tool.
• Root cause analysis of Database performance issues.
• Worked on upgrading RAC environment from 11.2.0.3 to 11.2.0.4
• Migrating data between different database instances whenever required, using Data pump or exp/imp utilities and RMAN cloning.
• Cross Platform migration and upgrade of databases.
• Performed huge amount of Data movements between Databases using Transportable Table spaces.
• Working off hours at times supporting issues when encountered in Production Environment.
• Worked on upgrading of Confidential databases from 10g to 11g/12c
• Working closely with upstream and downstream clients in migrating data using Confidential replication tool Golden Gate.
• Recovery of Database using RMAN (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, recovering from Block Corruption).
• Backup of Archive Logs, Control Files, and SP File on Tapes to Ensure Complete Recovery can be achieved.
• Placement of Confidential Files (Control Files, Redo Logs, Rollback Segments, System Data Files, etc) for Optimized Performance, Backup, and Recovery.
• Clone of EBS 11i/R12 Instances Multi-Node to Multi Node, Multi node to Single Node
• Working closely with development team in providing the required support from Database standpoint like creating required roles, granting required privileges and creating new schemas as and when required.
• Modification of the database structure, as necessary, per directions given by the application developers. Candidate should be able to advise development staff on implications of any proposed changes.
• Collecting Diagnostic information using tools like RDA, Ora-debug utility and OSWatcher.
• Contacting Confidential Support for technical assistance in resolving problems in a timely fashion.
• Document backup and recovery policy of RMAN Backups
• Implemented Confidential 11g Active Data guard for Disaster Recovery Solution.
• Participated in requirements gathering meetings with customer while building out new db environments.
• Prioritizing database related tasks on daily basis and completing them as per the schedule.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Develop and maintain hot and cold backup scripts. Perform complete and incomplete database recovery. Plan and perform Disaster/Recovery testing.
• Identified bugs and worked with Confidential Support to get the required patches.
• Refresh Dev, Test, Pre-Prod databases from Prod on a regular basis using RMAN.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Data extraction and Loading using Export/Import and SQL*Loader

Environment: Confidential 10g/11g/12c databases, Data Guard 10g/11g, RAC 10g/11g, EBS 12.1.3 to 12.1.4, Data pump, Export/Import, SQL*Loader, Physical Backups, Red Hat Enterprise Linux 4, TCP/IP, Confidential -AIX 5.3/6.1, Sun Solaris 9/10, HP-UX 11.23, Confidential Enterprise Manager 10g/11g, ASSH, ADDM, SQL, RMAN, SQL* Net, SQL* Plus, UNIX, Statspack

Confidential, Dublin, CA

Oracle Database Administrator

Responsibilities:

• Configured RMAN Backups and Clones using scripts.
• Production Assessment Tests and maintained to the global standards
• Planning and Administration of backup and recovery strategies.
• Database Upgrade from 9i to 10g.
• Using TKPROF, EXPLAIN PLAN and AWR for the Better performance.
• Transferring files by using SCP, SFTP, FTP and PSCP.
• Partitioning strategies for very large tables.
• Provide 24x7 production support of Confidential EBS 12.1.3 and 11GR2 multi node RAC.
• Performed multiple iterations of Confidential EBS upgrade from 11.5.10.2 to R12.2.3.
• Experience on technologies like Shared APPL TOP, Parallel Concurrent Processing(PCP), Standby Databases and Confidential Real Application Clusters(RAC) .
• Applying patches with ADOP in R12.2.5.
• Involved in analysis, design, development, testing and implementation of Confidential Applications R12.
• Involved in implementing and supporting Confidential Financials Modules: Account Receivables(AR), Account Payables(AP), General Ledger(GL), Fixed Assets(FA) and Cash Management.
• Excellent perspective on converting the functional specifications into technical design and development.
• Working with Vendor Confidential through Service requests for standard Confidential issues.
• Provides support to business during their Financial Period close.
• Involved in developing reports, concurrent programs, AOL objects etc. as per the business requirements.
• Involved in resolving business critical issues by fixing the code in Forms, Reports, and PL/SQL packages.
• Coordinating with offshore team in status and completion of assigned tickets and service requests
• Diagnose and troubleshoot Database problems and failures
• Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Monitoring of database for growth and performance.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Involved in Database sizing, Capacity Planning.
• Performed Space Management & Troubleshooting the database issues.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Setup and configured Confidential Physical Standby database (Data Guard) for disaster recovery.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning/exp/imp tables to setup identical databases in the production and development environments.
• Performed Cloning/Refresh to setup Test and Development database.
• Create and maintain users, roles and privileges & Auditing Triggers.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Transformed logical database designs into physical databases.
• Build and implemented test, quality assurance, production databases and environments.
• Coordinated strategies to move data between databases.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs.
• Automate Logical Backups using export/import, data pump on applications through grid control.
• Implemented and maintained database security (created and maintained users and roles, assign privileges).
• Documenting and maintaining the process related to Confidential database installations, patching, migrations and upgrading.
• Worked with Confidential global support/metalink team for various Confidential database issues and software version bugs.
• Followed the Confidential metalink standard documents and procedures for various database related deployments and changes.
• Communicated with external and internal teams on various database related projects.
• Followed the change board management policies for deploying changes in Confidential databases.
• Worked with application support teams to gather requirements and document them properly.

Environment: OracleApplications 11i/R12, RedHat Linux 4/5, Confidential AIX 5/6, Confidential 9i, 10g, RMAN, Data Guard, Golden Gate, OEM, ASM, statspack, ADDM.

Confidential, Pleasonton, CA

Oracle DBA

Responsibilities:

• Responsible in providing 24*7 On call support for Production Databases.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Backup and recovery using RMAN. Cloning development databases using RMAN.
• Designed and implemented data load process that is running two or more SQL* LDR together to improve Confidential database loading capacity.
• Performed Multi Node installation of Confidential EBS 11.5.10.2
• Cloning the Confidential Applications 11i environment from Production to UAT, QA, DEV boxes.
• Set up Printers and Workflow mailer setup in Confidential Applications 11i Prod, UAT, QA, DEV Environments.
• Experience in troubleshooting issues related to database and E-Business (Concurrent Managers, Forms, Apache, XML Publisher, workflow and Notification mailer).
• Monitoring the Confidential Applications through OAM and Troubleshooting the issues.
• Experience with AD utilities and SYSADMIN activities of Confidential Applications environments.
• Applied Patches for Developers Bug fixes and Scheduling Maintenance on Confidential Applications.
• My database and application knowledge, experience and expertise includes, RDBMS versions 11g, 10g, 9.x, e*Business Suite 11.5.9, 11.5.10, and R12.1.3 and Sun Solaris Administration and Linux Server management.
• Responsible for installing OEM agents and configuring database Target’s.
• Creating table spaces, sizing the system table space, allocating default table spaces for users.
• Responsible for monitoring and acting upon the alerts from Confidential Grid Control 10g.
• Responsible in instantiating Physical standby databases sizing about 20TB using RMAN Image copy.
• Experience in using GoldenGate to support data replication in the Confidential database environment.
• Experience in installing and configuring GoldenGate 10.4 and setting up Uni-directional between source and Target.
• Used AWR, ADDM, ASH reports and SQL Trace for database performance statistics.
• Utilized TKPROF to read the execution plan.
• Managed performance tuning and find the root cause of performance problems with STATSPACK, and developed scripts to automate process and monitored database usage.
• Responsible for the creation of database and application objects (tables, views, indexes, packages, triggers, etc.).

Environment: Confidential 10g, linux/unix, Confidential EBS 11.5.10.2, Confidential enterprise manager (oem), EBS 11.5.9, 11.5.10, and R12.1.3, Sun Solaris Administration, Linux Server, recovery manager(rman), sql loader, goldengate, data pump(expdp/impdp), statspack

Confidential

Jr. DBA

Responsibilities:

• Worked on finding the performance improvements for all the production databases
• Implementation of high availability solutions with Confidential 11g RAC, Physical and Logical Standby database using Active Data Guard and Confidential Golden Gate.
• Extensively worked with GGSCI commands executed at the ggsci line utility, are used to setup, manage,monitor and troubleshoot the different components of the Goldengate Replication configuration.
• Database refresh from one environment to other(Prod to UAT2)77
• Checking the status of important services like concurrent manager, forms server, web server, application listener and listener up.
• Clone the instances using Rapid Cloning for 11.5.10.2.
• Installed SRAT agent to monitor the servers utilization as per Confidential requirement.
• Creation of Database Users and Registering in Confidential Applications.
• Migrated the Single Instance database to Confidential RAC(Cluster ware Database 11g)* Resolved cluster (CRS) communication issue as socket files were cleared from the temporary location * RAC Database and scan listener administration with srvctl.
• Designing and deploying Integration server Integration services using MS SQL server and performing backup,restore and routine maintenance.
• Design, develop and maintain database solutions using MS SQL server and related application.
• Created SSIS packages to load data from XML Files, Ftp server and SQL Server 2008 to SQL Server 2012 by using Lookup, Derived Columns, Condition Split, Ole DB Command, Term Extraction, Aggregate, Pivot
• Transformation, Execute SQL Task and Slowly Changing Dimension
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse.* Developed Validation Plans for SSIS packages for checking the functionality of each component and code review.
• Scheduled jobs for executing the stored SSIS packages that was developed to update the database on dailybasis using SQL Server Agent.

Environment: Confidential 11gRel2, Confidential 10g Rel2, MY SQL Server, web server applications, OEM Grid Control, Confidential data guard, AIX 7.1, 6.1, oracheck, oswatcher, crsctl, cluvfy, srvctl, SQLTXPLAIN, Autosys.

Confidential

Data Base Administrator

Responsibilities:

• Created package (procedure, function) for dropping index, analyze, validate etc to provide fast tuning approach in the large database
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load and data parsing using PL/SQL procedures, Korn shell scripting, Perl scripts and SQL*Loader.
• Responsible for managing 10g/11g production, development & test databases and 11i applications.
• Handled administration of 24*7 Production Test & Development Databases.
• Worked with variousOracleApplications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, Auto Patch, Rapid Install etc.
• Patching the Application System using ad patch (minipacks, one-offs).
• Cloning using Rapid clone, Auto config and adclone utility.
• Involved in database migrations cloningOracleApplications 11.5.10.2 production system, for testing and development purpose using rapid clone.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of Backup and Recovery strategies.
• Configured and Upgraded toOracle11gR2 from 10g and from 11.2.0.2 to 11.2.0.3.
• Perform other regular DBA activities including Space Management and Performance Monitoring.
• Extensively working with performance tuning and memory (SGA) tuning, optimizing and troubleshooting of databases.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installed Grid system and managed shared memory in 10g database.
• Used Flashback to recover database, table.
• Manage and maintain Confidential Database on AIX-UX servers.
• Responsible for handling and supporting the Production, Development and testing Environment on AIX-UX Servers.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Used different types of indexes and cluster creation.
• Provided partitioning of the large tables to reduce the access time.
• Analyzed tables and indexes.
• All the approach held in testing database and was deployed in production.
• Written code in shell scripts to filter the columns and table names from scripts of PL/SQL Packages and procedures.
• Interaction with web design team to provide real change in code and E-R modeling based on addition of any primary key in the table in OLTP and data warehousing environment.
• Installation and Maintenance of Stand by database.
• Conducting sizing& capacity planning for Confidential databases.

Environment: Confidential 10g, 11g, Solaris, Unix, netapp, RAC, VCS, Dataguard, TRACE FILE, TKPROF, EXPLAIN PLAN, STATSPACK, PL/SQL, AIX-UX servers, Korn shell scripting, Perl scripts and SQL*Loader, 10g/11g production