PROFESSIONAL SUMMARY:

• Oracle DBA (Apps DBA and CORE DBA) with 7 years of IT experience which includes Application Lifecycle Implementation, Installation, Management, Maintenance and Administration of OracleApplications E - business Suite R12.x.x/11i andOracleDatabase11g, 10g, 9i/8i for major clients.
• Experienced in Installation, Configuring, and Maintenance Oracle Enterprise Manager Grid Control agents for enterprise database monitoring.
• Involved in Oracle EBS upgrade from R12.1.3 to R12.2.2 and 11i to R12.
• Responsible for installation and configuration of Oracle Demantra, High Availability, PCP, Shared APPL TOP and Load Balancer with E Business 11.5.10.2 and R12.
• Well versed in installation ofOracleHRMS for R12.1.1 on Linux and AIX environments withOracle Database 11g as database platform and patching ofOracleHRMS for global legislation.
• Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup &Recovery (RMAN), Cloning, Troubleshooting production issues, and Physical Database Design.
• Managing oracle 12c, 11g RAC (6, 4, 2 node) in production, Development and non-production environments.
• Experience includes using Golden Gate to support data replication in theOracle database environment.
• Proven Experience in high Availability like RAC and implemented 11g RAC 2/4 Node with ASM/Non-ASM storage.
• Involved in Database Migration from RHEL 5.7 to Oracle Unbreakable Linux Network (ULN) OEL 5.7 using RMAN.
• Provided 24×7 support of production database environments and worked with OEM 11g Grid Control, Exadata, Discoverer, BI reporting and Hyperion.
• Well versed with SQL and PL/SQL, Strong Unix shell scripting skills for automating theDBAtasks.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Good experience in applying security patches and migration of Oracle server from 10g to 11g, 9i to 10g & 8i to 9i.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Install/Support/Maintain on SQL Server databases with NoSQL/Mongo database.
• Worked with SAN, NAS for ASM disks
• Configured Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g.
• Extensive Experience with Recovery Manager (RMAN), Oracle Automatic Storage Management (ASM), Oracle Data Guard.
• Extensively worked on Oracle 12C, 11g RAC, 10g, 9i, Sql server 2012, RAC, ASM, OEM, Grid Control, RMAN, Flash Database, Data Guard Standby Database, Database Tuning, Database Security, Profiles and Privileges to the Various Users on Objects, and Optimization by Explain Plan and Rollback Segment and SQL TRACE facility, Maintaining Backup & RECOVERY in Sun/Linux UNIX systems administration, Shell programming.
• Proved Experience in Maintaining Documentation and Capacity Planning.
• Strong experience in working with oracle memory tuning (ASMM, AMM).
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.
• Experience on no SQL databases like Mark logic and mongo.
• Working with SUN, DELL, HP hardware and their storage system with RAID management.
• Well versed in creating and managing of Tables, table spaces, Segments, Extents, and Data Blocks.
• Well experienced in managing data files, redo logs, rollback segments, stored procedures, functions, packages and Triggers.
• Experienced in Database performance tuning, SQL debugging/tuning, Application server tuning, DB sizing and capacity planning.
• Secured the applications by implementing DMZ, SSL, and SSO.
• Expertise on Installing, maintaining, cloning, upgrading and migration ofFUSION MIDDLE WARE (FMW) like Web logic Server, SOA, OTM & OBIEE.
• Hands on experience in complete recovery, incomplete recovery (PITR), Flashback Recovery, Disaster Recovery, recovering data files, table spaces, and control files.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and Interim patches, Patch sets as per the Oracle recommendations.
• Performed backups using conventional hot & cold backups and RMAN.
• Experienced in moving the data using Logical backup utilities like Export, Import, Data Pump Export, Data pump Import.
• Strong skills in SQL* PLUS, PL/SQL, UNIX Shell scripts (KSH and CSH).

TECHNICAL SUMMARY HIGHLIGHTS:

• Very strong inOraclePL/SQL, Developer Tools like Forms and Reports and XML Publisher (BI Publisher) Reports.
• Very strong inOracleApplications Financials and Manufacturing Supply Chain Modules Technical Architectures and Integration of each module.
• Very strong withOracleApplications Workflow Architecture.
• Hands on Experience with APEX Tool.
• Hands on Experience with UPK/Tutor Installation and Development.
• Familiar with JAVA Programming.
• Experienced in developing scripts using PERL and UNIX Shell Script.
• Expertise in Developing MobileAppsusingOracleMobileAppsFramework

TECHNICAL SKILLS:

Databases: OracleRDBMS, Oracle 12c11g R2 RAC, 10gR2RAC, 9i

Operating Systems: HP-UX, Sun Solaris, RHEL 5.x, RHEL 6,x, Red Hat9,AIX, Linux and Windows, IBM DB2, Informix on IBM

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting

Tools: Rapid Clone, Rapid Install, DBUA, Autoconfig, Adsplice, Adpatch, Adadmin, Adcontroller, Admergepatch, Adutconf, Adrelink, Adident RMAN, OEM, OAM, Toad, Exp/Imp, Smitty, Putty, ADI, Tkprof, ASH, RAC,RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB Artisan 4.0, Migration, ASM, Cloning, Replication.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatica 5.1, Share Plex, SSIS, DTS

Data Modeling: Erwin, DB Artisan, Rational Rose, SOX

Other: EMC, Net App, VERITAS, Golden Gate,OracleWallet

GUI Tools: OracleEnterprise manager, TOAD, Data Loader, PLSQL Developer, SQL Developer

Storage/Server: NetApp, HP EVA,OracleVM

Hardware: IBM System x3650 M3 2 x 6C Xeon 1GHz, HP UX 4 x 2C PA-RISC 1GHz, HP UX 4 x 2C iTanium 1GHz, Sun Superdomes with 40 CPUs each, Dell Power Edge 6600, 2200, Sun Ultra E450, E250, Sun Fire 880, IBM RS 6000, SunFire 15K 40 CPUs; EMC SAN storage on DMX3 (1 Petabyte); DMX3000 and 2000 Series, UCS

WORK EXPERIENCE:

Confidential, MO

Sr Oracle Apps DBA

Responsibilities:

• I am responsible for the support and maintenance of the company's financial databases.
• Installed,FUSION MIDDLE WARE (FMW) like Web logic Server, SOA, OTM & OBIEE.
• Maintaining 2 node RAC environments on Oracle 11gR2 with ASM/NON-ASM File system on Linux environments. Experienced with SRVCTL, CRSCTL, OCR and Voting Disk.
• Upgrade of Oracle Applications EBS from R12.1.3 to R12.2.2 and 11.5.10.2 to R12.1.3
• Prepared Proof of Concept (PoC) for upgrading Oracle EBS from 11i to R12.2.2.
• Installation, configuring and maintaining Oracle 11g databases on ASM.
• Implemented Physical standby for disaster recovery using Data Guard on Oracle 11g.
• Preparing Documentation to perform cross platform migrations for Oracle 11gR2 to 12c from Solaris to Linux
• Cloning of Oracle Applications 11i with RAC and ASM.
• Cloning of Oracle Applications R12.1.3 using Snapshot Technology.
• To tune and configure Oracle 11g database for optimum performance.
• Coordinate with QA, development support upon production releases.
• Installed and configured OEM Grid Control agents 11g and 12c on Solaris, Linux server.
• Installed 12c and 11gR1/2 Oracle RDBMS and provision databases on Linux & Solaris.
• Upgraded and Migrated Databases from 10g to 11g and applying patches as needed.
• Performance monitoring and tuning up of the Database using STATSPACK, AWR, ADDM.
• Performed LOGICAL BACKUPS for Database migration using Data Pump, Export/Import and Transportable Table spaces.
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server.
• Worked closely with developers helping them identify and fix issues. (Eg: User login issues, concurrent managers, OID authentication, and vertex connectivity).
• Responsible for identifying gaps with and automating end-to-end Production to non-Production Refresh process.
• Within Cloud Services the Customer Management team is focused on operations and account management capabilities for the Cloud Services Customers.
• Worked on SAN / RAID configuration.
• Implementing zero downtime migration and upgrade of 11g to 12c database using Oracle GG.
• Involved in database Export/Import and performing backups using RMAN.
• Working with Networked Attached Storage (NAS) & Tivoli Storage Management (TSM).
• Involved in the Analyzing and monitoring the system performance and tune accordingly.
• Worked actively in planning for storage space requirements and placing them for optimum I/O performance.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using Golden gate.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Supported SQL server OLAP cubes along with installations and maintenance upgrades.
• Worked intensively on database migrations.
• Maintaining 110 Databases, Implemented 30 Production database, 40 Development database, 40 Test database.
• Created Users, Roles, Privileges, Profiles and managing security.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*Net connectivity.

Environment: Oracle 12c/11g/10g, Oracle Applications 11i, R12.1.3, R12.2.4 RAC, RMAN, Import/Export, Data Guard, Streams, ASM, Performance tuning, Patchset, Upgrade, Migration, SQL, PL/SQL, SQL*PLUS, Korn Shell, Perl Scripting, Sun Solaris and Linux.

Confidential, TN

Senior Oracle Application DBA

Responsibilities:

• InstalledOracleDatabase 11gR2 with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment.
• Installed, configured theOracle9i and 10g,Oracle11iappstech stacks and R12 tech stacks
• Worked on creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizingoracleprocesses and increasing SGA overall.
• Performed 11i to R12 Basic upgrade process involving Rapid Install & Autopatch
• Installed and configuredOracleSOA Suite on 10GOracleApplication server's OC4J for BPEL PM, ESB, OWSM.
• Administer Mongo databases, i.e. install, check alert log, health check of database.
• Coordinate and suggest PM, SA and LOB DBA to allocate and setup disks for data files, backups and achieve log sizes for ASM through SAN storage, SAN storage to setup VOTING and OCR ASM LUNS per cluster, swap storage and shared memory needed per each node.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Configuration and implementation of Golden Gate based replications through GGSCI.
• Configured SSL, SSO and DR Data guard architecture for effective fast starts of the fail overs.
• Performed extensive support to the AD admin, auto patching and patch merge processes for all the modules inOracleapps.
• Maintained Oracle Apps environments for SOX compliance all along.
• Configured the JDBC pools and data sources for the developer and other SOA integration environment accesses.
• Bi-directional replication and Uni-directional replication in Golden gate.
• Perform Daily Monitoring ofOracleinstances usingOracleEnterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Create multiple 11g databases on RHEL5 in development.
• Upgraded and configured theOracleDiscover 10G from Discoverer 4i with the eBusiness suite applications.
• Supported and admin of printers, accounts, OAM, site and application level profiles.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC 2 nodes on IBM AIX and debugging Golden Gate issues such as extract and replicate rebuild.
• Managed users and maintained security, populated databases of Oracle 10g & Oracle 11g on RHEL, Solaris and Windows 2003.
• Used scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache server configuration.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Involved in EDW support for OLTP and OLAP Data warehouse application.
• Rebuilding of Indexes for better performance ofOracledatabase.
• Upgraded Oracle database using DBUA or Data Pump Export/Import.
• Implemented Migration Strategies based on cost, time, and platforms requirements.
• Restore and point-in-time Recovery of database using RMAN techniques.
• Implemented Golden Gate Technology onOracle11g/10g.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Have automated/monitored backup strategies for different databases.
• Written Shell scripting which monitors the server's performance and logs output on periodic basis to database using Perl Scripting.
• Designed and developedSQL Server Analysis Services(SSAS) databases andOLAP cubesused in ad-hoc analytic research and automated reporting.
• Experience in using flashback feature oforaclethroughout the project.
• OracleExadata Management was efficiently used in the project.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup that are used for Data Scrubbing before loading the data into the Data warehouse.

Environment: Oracle11gR2/10g, RHEL, RAC, RMAN, PL/SQL, Stored procedures, SQL*Loader, Toad for Oracle, Golden Gate, OEM, SQL Loader, UNIX, Solaris, Linux, AIX 5.x, Windows.

Confidential, VA

Oracle DBA

Responsibilities:

• Part of core Development DBA team maintaining Development databases.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Export and Import of User, Tables and Data files using exp/imp and Data Pump.
• Tuning of the database using TKPROF utility, tuned the Shared pool and buffer cache to have better performance. Point in time recovery for recovering the master data when the tables are dropped by user errors.
• Performance Tuning: Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL Trace, Tk prof, Analyze, ADDM and Explain Plan methods.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Log Miner, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Supported SAN Migration and ASM migration, allotted new candidate disks.
• Installation and configuration of Oracle databases on LINUX platforms.
• Administering the physical aspects of the databases such as creation of Table spaces, Users, Rollback segments, creating data files, helping users in creating database objects.
• Configured and maintained data loads in huge Data warehousing systems using the Informatica Power Center ETL tool. Supported data warehousing and databases.
• Advanced troubleshooting using trace files, alert log, and external links (Meta link or Oracle Support).
• Analyzing performance issues and providing recommendation based on testing results using Oracle's tools like AWR, ASH& Data Recovery advisor.
• Configured Standby database for production database.
• Oracle Database Performance Tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc.
• Involved in EDW support for OLTP and OLAP Data warehouse application
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Configured Standby database for production database.
• Participate in establishing and involving database standards within the company.
• Preparing cluster, configuring and Installation of cluster ware and Oracle RAC on RHEL.
• Performance monitoring, Database tuning and Application tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack.
• Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage.
• Monitoring Database Activities, Checking for Table space Availability, Checking the Alert Log File for errors.
• Troubleshoot /Configuration of tnsnames, listeners setup.
• Responsible for online and offline backups and recoveries of the oracle database.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Create new database users as required. Plans and implements backup and recovery of the Oracle database.

Confidential, IA

Oracle DBA

Responsibilities:

• I was responsible for the support and maintenance of the company's financial and student databases.
• Involved in the upgrade of the11.5.5 applications instance to 11.5.8 and the database from 8i to 9.2.0.4 onto RAC nodes.
• Administered and maintained production, development, QA, test and patch instances of the Oracle production databases on a round-the-clock basis.
• Configured the workflow notification mailer.
• Installed and managed the daily business intelligence DBI 6.0.
• Reviewed, explored and applied the Oracle applications patches when the business requirements demanded.
• Worked on OLTP and OLAP database systems.
• Cloned the Oracle applications production system for development purposes, using RAPID clone.
• Developed and implemented the Disaster Recovery (DR) strategy for Oracle E-Business Suites.
• Developed and implemented backup and recovery strategies.
• Checked alert logs and troubleshoot and resolved the database issues, adding data files, resizing data files and analyzing tables, recovering and renamed the databases to create and sink the development data with production data in RAC environments.
• Installed Oracle RAC 9i on Linux Platforms.
• Interacted with the Oracle customer support and logged iTAR when required.
• Patched security vulnerabilities when released by Oracle support.

Environment: Red Hat Linux, HP-Unix, Oracle Applications 11.5.8/11.5.9 , (Financials & CRM Modules), Oracle 9i, Oracle Forms 6i, OAM, License Manager, STATSPACK, Rapid wiz, Rapid Clone, Auto upgrade, Adpatch, Adadmin, Adctrl, Toad 7.3, SQLplus, OEM, EMC Storage)

Confidential

DBA

Responsibilities:

• Installed, created and maintained new oracle 9i and 8i instances.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security).
• Coordinated with Infrastructure and storage teams to resolve performance issues and to improve system response and run times.
• Connectivity with different client programs using ODBC.
• Writing scripts to move data files, for monitoring system activities (I/O CPU), memory usage at process level, file growth, user login, and user's setup.
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle file structures.
• Involvement in all phases of the project life cycle.
• Developed and modified PL/SQL code to make new enhancements or resolve problems as per customer requirements.
• Involved in optimizing SQL statements using indexes and hints.
• Setting up configuration parameter of MySQL Database (my.inf).
• Frequent analysis of objects or schemas to improve the speed of the database.
• Analyze SQL statements using Explain plan.

Environment: Oracle 10g, 9i RHEL, UNIX Shell Scripts, TOAD, PL/SQL Developer, SQL Server 2000